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 vote290 views1 answer
Postgresql newline character
SQL
0 vote352 views1 answer
Declare or use variable in snowflake
SQL
0 vote339 views1 answer
Mysql config address
SQL
3 votes342 views1 answer
Start mysql server linux terminal
SQL
0 vote319 views1 answer
Mysql return column names when table is empty
SQL
0 vote317 views1 answer
Horizontal join sqlite
SQL
3 votes319 views2 answers
Sql get month name
SQL
0 vote354 views1 answer
Bigrock database connection string
SQL
23 votes314 views3 answers
Mysqldump
SQL
-1 vote305 views2 answers
On update cascade
SQL