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 vote207 views1 answer
Pl/pgsql declare variable
SQL
1 vote221 views2 answers
Difference between in and between in sql
SQL
0 vote181 views1 answer
Limit and offset in stored procedure mssql
SQL
1 vote234 views1 answer
Varchar plsql
SQL
51 votes281 views6 answers
Change column name sql
SQL
0 vote211 views1 answer
Finding leap year in sql
SQL
4 votes163 views3 answers
Copy table postgres
SQL
0 vote182 views1 answer
Insert overwrite table in mysql in nifi
SQL
4 votes182 views1 answer
Phone number sql
SQL
0 vote176 views1 answer
Mysql Install Ubuntu with native password
SQL