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 vote295 views1 answer
Do you know sql
SQL
1 vote308 views3 answers
Epoch to datetime
SQL
4 votes284 views2 answers
SELECT table_name FROM user_tables;
SQL
0 vote289 views1 answer
Sql case sttement with set
SQL
0 vote287 views1 answer
Ksql quickstart docker
SQL
0 vote288 views1 answer
Firebird where
SQL
0 vote303 views1 answer
How to add session data into mysql database from button
SQL
0 vote298 views1 answer
Sql last 3 rows
SQL
0 vote291 views1 answer
USING THE NOT CONDITION IN SQL
SQL
4 votes268 views2 answers
How to delete row in sql
SQL