Can pandas fetch data from sql

import pandas as pd
import sqlite3

con = sqlite3.connect("data/portal_mammals.sqlite")

# Load the data into a DataFrame
surveys_df = pd.read_sql_query("SELECT * from surveys", con)

# Select only data for 2002
surveys2002 = surveys_df[surveys_df.year == 2002]

# Write the new DataFrame to a new SQLite table
surveys2002.to_sql("surveys2002", con, if_exists="replace")

con.close()

-1

Source: datacarpentry.org

Similar codes

0 vote136 views1 answer
Sql find leading space
SQL
0 vote134 views1 answer
Suse start MySQL
SQL
0 vote137 views1 answer
Oracle list proxy users
SQL
13 votes137 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote158 views1 answer
Last date for each user sql
SQL
0 vote142 views1 answer
Select sql in descending order
SQL
0 vote137 views1 answer
Postgresql like
SQL
0 vote134 views1 answer
Vowels in sql
SQL
0 vote131 views1 answer
Sql comparison operators
SQL
1 vote145 views1 answer
Postgres start database on linux
SQL