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 vote229 views1 answer
SQL query to get all table records count from a database
SQL
3 votes225 views2 answers
Postgres show table schema
SQL
3 votes208 views1 answer
Show index table
SQL
0 vote205 views2 answers
Check mysql timezone
SQL
3 votes200 views1 answer
System.debug apex
SQL
2 votes209 views1 answer
Plsql block
SQL
0 vote220 views1 answer
Example of sql querry result sepapreted by comma
SQL
8 votes256 views2 answers
Default sql server port
SQL
0 vote219 views1 answer
Two inner joins sql
SQL
1 vote213 views1 answer
Sql server find tables referenced foreign key
SQL