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 votes139 views1 answer
Oracle ora-00054 causes
SQL
3 votes132 views1 answer
Sql select all
SQL
2 votes134 views1 answer
SQL IF ELSE
SQL
0 vote154 views1 answer
Add SuperUser MySQL
SQL
0 vote143 views1 answer
Exec procedure oracle
SQL
1 vote306 views1 answer
Postgres convert text to number
SQL
0 vote166 views1 answer
How to find sql server name
SQL
0 vote143 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote151 views1 answer
Influxdb clone measurement
SQL
-1 vote149 views2 answers
First letter capital in mysql query
SQL