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 vote176 views1 answer
Vagrant mysql downgrade version
SQL
6 votes203 views6 answers
Rename column postgres
SQL
2 votes181 views1 answer
Drop sequence
SQL
0 vote165 views1 answer
Dump only data
SQL
1 vote163 views1 answer
Mysql current time
SQL
0 vote163 views1 answer
Connexion mysql
SQL
0 vote197 views1 answer
Delete ids between sql
SQL
0 vote164 views1 answer
Postgresql interview questions
SQL
0 vote178 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
0 vote189 views1 answer
Regex any word except sql
SQL