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 vote130 views2 answers
Oracle difference between two dates in seconds
SQL
0 vote136 views1 answer
Mysql select smaller of two values
SQL
0 vote142 views1 answer
How to put is null in where in clause
SQL
0 vote114 views1 answer
Separator mysql
SQL
23 votes142 views4 answers
How to uninstall postgresql in ubuntu
SQL
0 vote141 views1 answer
Sql column contains special character
SQL
0 vote166 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
1 vote89 views1 answer
Python escape string for sql
SQL
2 votes133 views1 answer
Plsql left() function
SQL
0 vote126 views1 answer
Mysql select statement after index
SQL