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 vote209 views1 answer
Get only first row mysql
SQL
1 vote217 views1 answer
MySQL AND Operator
SQL
0 vote220 views1 answer
How many columns can be used for creating index?
SQL
0 vote228 views1 answer
How to change the field size of an existing column
SQL
0 vote246 views1 answer
Groupby sort sql hive
SQL
0 vote228 views1 answer
Update one column from another column in same table
SQL
0 vote231 views2 answers
Mysql multiply
SQL
1 vote254 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote254 views1 answer
Express api ith mysql data
SQL
0 vote256 views1 answer
Mariadb change column type
SQL