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

5 votes282 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
-3 votes186 views1 answer
Remove spaces sql 2008
SQL
1 vote205 views2 answers
Check if word is in column sql
SQL
2 votes180 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote247 views2 answers
Search stored procedures
SQL
7 votes195 views2 answers
MySQL IF without else
SQL
0 vote208 views1 answer
Postgres reorder columns
SQL
31 votes195 views3 answers
Sql count(*)
SQL
0 vote197 views1 answer
Oracle gather table statistics
SQL
0 vote267 views1 answer
Merge clause with inner join
SQL