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 vote140 views1 answer
Update set with inner join oracle
SQL
0 vote157 views1 answer
Select all columns except one sql
SQL
0 vote172 views2 answers
Plpgsql
SQL
0 vote166 views1 answer
Query builder doctrien return sql
SQL
2 votes147 views1 answer
Oracle find constraints referencing a table
SQL
1 vote142 views3 answers
Getdate function in postgresql
SQL
1 vote149 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote187 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
18 votes114 views2 answers
How to get all the tables displayed in oracle
SQL
-1 vote146 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL