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

1 vote358 views1 answer
Pl sql ptint
SQL
0 vote433 views1 answer
Mariadb change column type
SQL
6 votes346 views1 answer
Allsource oracle
SQL
6 votes358 views1 answer
What is where clause in sql
SQL
1 vote367 views1 answer
Copy postgres table from one schema into another
SQL
0 vote355 views1 answer
Sql server delete records with specific date
SQL
0 vote481 views1 answer
Oracle db timestamp auto add
SQL
3 votes383 views1 answer
Get current month last date in sql server
SQL
1 vote404 views1 answer
Create email address from first and last name in sql
SQL
0 vote375 views1 answer
Wordpress database query change url
SQL