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 vote185 views1 answer
Recursive query herarchical data sql server
SQL
0 vote273 views1 answer
Do you know sql
SQL
1 vote247 views1 answer
Tsql create unique index composite
SQL
0 vote181 views1 answer
Oracle dynamic select into
SQL
0 vote248 views1 answer
Sql server remove primary key without dropping table
SQL
6 votes185 views2 answers
Can't connect to local mysql server through socket
SQL
3 votes196 views2 answers
Postgresql select all column names
SQL
0 vote218 views1 answer
Mysql last friday of current month
SQL
0 vote174 views1 answer
Truncate table sql server foreign key
SQL
0 vote189 views1 answer
Sql server select ignore dupplicates
SQL