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 vote194 views1 answer
Lost connection to mysql
SQL
0 vote204 views1 answer
Sql shell psql cannot enter password
SQL
0 vote221 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
15 votes195 views4 answers
How to get all tables in sql
SQL
1 vote239 views2 answers
Install sql server management studio ubuntu
SQL
1 vote197 views2 answers
Sql server add time to date
SQL
1 vote228 views1 answer
Increase existing date in sql oracle
SQL
0 vote195 views1 answer
Forcefully delete a row in mysql which has references
SQL
1 vote212 views1 answer
Sql server: query to find out all the places where the table is used
SQL
5 votes222 views3 answers
MySql get fields of table
SQL