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 vote167 views1 answer
Play framework connection via windows sql server
SQL
0 vote154 views1 answer
Mysql vs sql server performance benchmark
SQL
0 vote158 views1 answer
Count number of entires by months sql
SQL
0 vote167 views1 answer
T sql dynamic top n query
SQL
2 votes145 views1 answer
Sql create database
SQL
5 votes145 views1 answer
Update sql user password
SQL
2 votes155 views6 answers
Mysql change timezone
SQL
13 votes178 views3 answers
List all the tables in sql
SQL
0 vote140 views1 answer
Get who is hired in january in sql
SQL
2 votes155 views1 answer
Metasploit start postgresql
SQL