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

9 votes131 views4 answers
Mysql set id auto increment
SQL
0 vote123 views1 answer
Ksql quickstart docker
SQL
0 vote118 views1 answer
Database xml sql
SQL
0 vote242 views1 answer
Sqlite display data in separated columns
SQL
16 votes123 views3 answers
Delete row psql
SQL
2 votes136 views1 answer
Oracle percentage
SQL
3 votes119 views3 answers
C# sql select
SQL
0 vote140 views1 answer
Mysql installer no packages found
SQL
0 vote145 views1 answer
Table user postgres
SQL
1 vote112 views1 answer
How to ckeck that email is present in databse in mysqli
SQL