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 vote304 views1 answer
SELECT statement to find the specific cell in database table
SQL
0 vote290 views1 answer
Como hacer un select entre fechas mysql
SQL
1 vote305 views1 answer
Postgresql how to show table names
SQL
7 votes293 views3 answers
Restore postgres database from sql file
SQL
0 vote309 views2 answers
Postgresql gset
SQL
0 vote286 views1 answer
Use where instead of join
SQL
0 vote288 views1 answer
Mssql check if date is greater than today
SQL
0 vote277 views1 answer
Delete insert record in sql server
SQL
6 votes297 views6 answers
Count mysql
SQL
0 vote477 views2 answers
Create new table from existing table with data in sql server
SQL