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 vote262 views1 answer
Sql server select record with max id
SQL
0 vote266 views1 answer
Null column as zero in mysql
SQL
-1 vote259 views1 answer
Mac mysql workbench console
SQL
11 votes264 views1 answer
Get ddl materialized view oracle
SQL
0 vote285 views1 answer
Delete hangfire retries list
SQL
5 votes245 views1 answer
Oracle ora-00054 causes
SQL
1 vote252 views1 answer
Alter table column size oracle
SQL
2 votes260 views1 answer
Add default sql server
SQL
4 votes250 views1 answer
Adding data to table in sql python
SQL
0 vote298 views1 answer
Dual in db2
SQL