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 vote258 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
0 vote258 views1 answer
Recursive query herarchical data sql server
SQL
0 vote269 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote278 views1 answer
Running query in redshift
SQL
18 votes294 views3 answers
Get the list of all tables in sql server
SQL
0 vote278 views1 answer
Sqlplus change user
SQL
8 votes274 views2 answers
Oracle auto increment primary key
SQL
0 vote306 views1 answer
Space not removing from column in sql
SQL
0 vote285 views1 answer
Mysql sql.gz
SQL
1 vote286 views2 answers
Mysql trim spaces
SQL