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 vote318 views1 answer
Oracle select partition
SQL
0 vote321 views1 answer
Group by 15 minute interval sql server
SQL
0 vote310 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote322 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote339 views1 answer
Dual in db2
SQL
0 vote318 views1 answer
How to find lowest in sql
SQL
1 vote315 views1 answer
Raise application error in oracle
SQL
0 vote310 views2 answers
Reseed sql identity
SQL
14 votes318 views3 answers
Alter foreign key
SQL
1 vote316 views1 answer
Quit mysql
SQL