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 vote147 views1 answer
Mysql start of today
SQL
0 vote180 views1 answer
Getting next sequence value jpa postgress
SQL
7 votes146 views6 answers
Group_concat mysql
SQL
1 vote190 views1 answer
Oracle grant select on schema
SQL
0 vote165 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
0 vote156 views1 answer
Sql delete from with relation
SQL
1 vote143 views1 answer
Nested if in mysql
SQL
6 votes164 views2 answers
Where clause in sql
SQL
-1 vote162 views1 answer
Export mysql table to file
SQL
0 vote161 views1 answer
Java sql timestamp now
SQL