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 vote108 views1 answer
Table infromation in sql server
SQL
1 vote123 views1 answer
Mysql get max value and id
SQL
6 votes128 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
3 votes89 views2 answers
Coalesce mysql
SQL
0 vote81 views1 answer
Select all domains of database firbird
SQL
1 vote222 views1 answer
Mysql data from file
SQL
2 votes142 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
-2 votes133 views3 answers
Sqlite reset autoincrement
SQL
1 vote115 views1 answer
Substr sql last character
SQL
-1 vote116 views1 answer
Io
SQL