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 vote200 views2 answers
Database owner can't create new tables postgres
SQL
1 vote192 views1 answer
Column with prefix in sql
SQL
0 vote230 views1 answer
Sql server for loop
SQL
1 vote282 views1 answer
Mysql get max value and id
SQL
2 votes220 views1 answer
Sql finding longest and shortest names in a fleld
SQL
0 vote188 views1 answer
Suse start MySQL
SQL
10 votes163 views1 answer
Oracle view dependencies
SQL
0 vote211 views1 answer
Sql ignore
SQL
0 vote205 views2 answers
Mysql on update current_timestamp
SQL
0 vote205 views1 answer
Mysql count number of occurrences in a column
SQL