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 vote372 views1 answer
Get first match in each group mysql query
SQL
0 vote196 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote259 views2 answers
Return the number of records in a single table mysql
SQL
5 votes182 views6 answers
Sql add days to date
SQL
5 votes165 views2 answers
Oracle list columns schema
SQL
4 votes229 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote225 views1 answer
Take sql dump in to file
SQL
1 vote199 views1 answer
Show indices in mysql table
SQL
0 vote184 views1 answer
Mysql repair a table
SQL
9 votes186 views4 answers
How to alter table column name in mysql
SQL