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 vote171 views3 answers
Above average salary in sql
SQL
3 votes179 views2 answers
How to start postgresql on windows
SQL
0 vote175 views1 answer
Postgresql update to unique
SQL
0 vote215 views1 answer
Select true if exists on another table or false sqlserver
SQL
12 votes164 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote171 views1 answer
Java mysql date format
SQL
0 vote162 views1 answer
Postgresql create user roles
SQL
1 vote167 views1 answer
Last 6 months postgresql
SQL
0 vote187 views1 answer
Postgresql linux password
SQL
0 vote168 views1 answer
Authentication in sql server
SQL