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 vote445 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
5 votes359 views4 answers
Mysql on duplicate key update
SQL
5 votes335 views4 answers
Describe table postgres
SQL
1 vote360 views1 answer
Psql search table
SQL
2 votes358 views1 answer
Sql ends with string
SQL
0 vote351 views1 answer
Sqlplus change user
SQL
0 vote358 views1 answer
Create relationship with betwen two tables in postgersql
SQL
-1 vote373 views5 answers
Operator in sql
SQL
0 vote360 views1 answer
Oracle temporary table
SQL
5 votes354 views2 answers
Oracle list columns schema
SQL