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 vote94 views1 answer
Alter user mysql native password
SQL
4 votes143 views1 answer
Wilayah indonesia database
SQL
5 votes135 views1 answer
Oracle get nls settings
SQL
1 vote146 views1 answer
How to fetch alternate records from two tables
SQL
0 vote126 views1 answer
Postgresql certain first 4 characters in string
SQL
0 vote131 views1 answer
Check mysql password with docker container magento 2
SQL
24 votes142 views5 answers
Sql server insert into select
SQL
60 votes333 views6 answers
Add column in sql
SQL
0 vote139 views1 answer
Sql query to delete row by id
SQL
1 vote160 views1 answer
Autocommit mysql
SQL