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 vote107 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
-1 vote91 views2 answers
How to display top 50 rows?
SQL
13 votes97 views6 answers
Restart postgresql
SQL
0 vote146 views1 answer
Sql check if field is not null
SQL
1 vote119 views1 answer
Postgres see sequence current state
SQL
3 votes100 views2 answers
Plsql print
SQL
0 vote110 views1 answer
Sql server beginning of month
SQL
0 vote115 views2 answers
Update query with between in mysql
SQL
0 vote97 views1 answer
Sql make sure every user is unqiuew
SQL
2 votes115 views1 answer
Sql string_agg
SQL