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 vote181 views1 answer
Power bi find all ids not in other tables
SQL
2 votes181 views1 answer
Oracle current date without time
SQL
1 vote190 views1 answer
Continue in sql
SQL
42 votes227 views6 answers
Rename table sql server
SQL
0 vote142 views1 answer
Store query result in variable sql
SQL
0 vote175 views1 answer
Renombrar tabla mysql
SQL
0 vote172 views1 answer
Mysql page segment
SQL
1 vote193 views2 answers
Foreign key set 0
SQL
0 vote176 views1 answer
Sql server inner join convert collation
SQL
1 vote174 views1 answer
Sql drop with dependencies
SQL