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

6 votes96 views1 answer
Wordpress change user password sql
SQL
1 vote98 views1 answer
Pv mysql import
SQL
0 vote102 views1 answer
Convert sql server guid to varbinary
SQL
0 vote110 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
11 votes108 views1 answer
How to get ddl for materialized view
SQL
7 votes101 views1 answer
Sql server convert string to date
SQL
0 vote112 views1 answer
Como hacer una consulta en sql
SQL
10 votes103 views1 answer
Oracle object dependencies
SQL
0 vote102 views2 answers
Sql join on comma separated field
SQL
0 vote102 views1 answer
18446744073709551615 mariadb left join order by
SQL