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 vote369 views1 answer
Mysql remove last character
SQL
0 vote304 views1 answer
Create bakupd database sqlserver
SQL
12 votes349 views4 answers
Import mysql database command line linux
SQL
0 vote334 views1 answer
Find largest table in mysql database
SQL
0 vote378 views1 answer
Sqlite unique multiple columns
SQL
0 vote334 views2 answers
Postgresql get long running queries
SQL
0 vote547 views1 answer
Dublicate row sql
SQL
0 vote306 views1 answer
Create duplicate table in postgresql
SQL
0 vote349 views1 answer
Oracle create job if not exists
SQL
27 votes370 views3 answers
Mysql show tables in database
SQL