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

4 votes197 views3 answers
How to describe a table in sqlite3
SQL
5 votes280 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
1 vote212 views1 answer
Myql find duplicates
SQL
9 votes189 views3 answers
Mysql show table column full description
SQL
0 vote223 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
0 vote189 views3 answers
Create and attach user to a postgresql database
SQL
0 vote187 views1 answer
Set column in all row mysql
SQL
0 vote356 views2 answers
Create new table from existing table with data in sql server
SQL
0 vote193 views1 answer
Dump db only triggers mysql
SQL
6 votes226 views5 answers
Oracle list tablespaces
SQL