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 vote347 views1 answer
Oracle convert run duration to number
SQL
5 votes357 views1 answer
Mysql count newlines in field
SQL
0 vote465 views1 answer
Reset a table's identity column and remove test records
SQL
6 votes397 views2 answers
How to get last element sql
SQL
1 vote384 views1 answer
Alter constraint in sql
SQL
0 vote342 views1 answer
Oracle exchange partition
SQL
0 vote327 views1 answer
What does the -p flag do in mysql cli
SQL
1 vote356 views2 answers
Mysql show views
SQL
4 votes379 views1 answer
W3schools create table
SQL
1 vote365 views1 answer
Mysql alter decimal precision
SQL