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 vote101 views1 answer
Oracle list chain steps
SQL
0 vote130 views1 answer
How to inner join 4 tables in sql
SQL
0 vote110 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote135 views1 answer
Why do we need data structure in sql
SQL
0 vote134 views1 answer
Postgresql cast as year and month from timestamp
SQL
2 votes130 views2 answers
Python escape string for sql
SQL
0 vote115 views2 answers
How to update date in oracle
SQL
0 vote127 views1 answer
Stratified sampling sql
SQL
0 vote137 views1 answer
Find how many tables in database sql query
SQL
0 vote112 views1 answer
Sql file in postgres with pgadmin
SQL