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

4 votes205 views2 answers
Truncate oracle
SQL
103 votes322 views1 answer
Like sql
SQL
1 vote197 views1 answer
Sql restore backup query
SQL
0 vote223 views1 answer
Add user mysql wordpress
SQL
1 vote203 views1 answer
Oracle turn off constraint
SQL
6 votes196 views5 answers
Mysql get last insert id
SQL
0 vote190 views1 answer
Oracle job schedules
SQL
0 vote241 views1 answer
Postgres docs /copy metacomand
SQL
0 vote211 views1 answer
Get rows from 1 table with other table empty mysql
SQL
0 vote227 views1 answer
How to make sure two tables have same exact data in sql
SQL