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

4 votes284 views1 answer
Postgresql list sequences
SQL
1 vote267 views2 answers
Sql multiline comment
SQL
0 vote271 views1 answer
Mysql 1 hour ago
SQL
2 votes265 views4 answers
List databases in sql server
SQL
0 vote274 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
0 vote268 views1 answer
Teller stamp , bmo , PDF
SQL
2 votes268 views1 answer
Sql missing records from another table
SQL
1 vote250 views1 answer
Substr sql last character
SQL
1 vote258 views1 answer
User privileges postgresql information_schema
SQL
3 votes267 views2 answers
Oracle apex view logs
SQL