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

5 votes345 views3 answers
Oracle first day of last year
SQL
3 votes356 views2 answers
To_char sql
SQL
7 votes387 views2 answers
How to create index mysql
SQL
0 vote294 views1 answer
Mysql find foreign key references
SQL
0 vote356 views1 answer
Where date major today mysql
SQL
1 vote326 views2 answers
Mysql current user
SQL
0 vote383 views1 answer
Traccar mysql
SQL
0 vote324 views1 answer
Denormalise SQL command
SQL
0 vote317 views1 answer
Ms Sql set us timezone
SQL
0 vote354 views1 answer
Uncheck constraints and delete from table
SQL