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 votes275 views1 answer
Sql quote in string
SQL
0 vote264 views1 answer
Mysql money value
SQL
0 vote222 views1 answer
Oracle function select into
SQL
3 votes271 views1 answer
Select table column in sql
SQL
0 vote279 views1 answer
Which lock mode is not available in sql
SQL
4 votes261 views3 answers
Count with where
SQL
12 votes276 views1 answer
Psql drop column
SQL
0 vote263 views1 answer
Order by ip address sql
SQL
2 votes270 views1 answer
Mysql query unique column
SQL
3 votes272 views1 answer
Mysql replace string in table
SQL