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

3 votes329 views1 answer
Dbms_scheduler drop_job
SQL
3 votes321 views2 answers
Oracle synonym
SQL
0 vote319 views1 answer
Sqlalchemy query return only n results
SQL
0 vote331 views1 answer
Execut sql python
SQL
0 vote385 views1 answer
Mysql streaming example
SQL
2 votes336 views2 answers
How to rename column name in sql server using query
SQL
0 vote320 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote323 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote347 views1 answer
Min mysql
SQL
10 votes356 views3 answers
Sql select between two dates
SQL