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

2 votes222 views4 answers
Mysql select into new table
SQL
0 vote241 views1 answer
Mysql query to select the highest value
SQL
0 vote258 views1 answer
Sql sort ages
SQL
0 vote222 views1 answer
Xampp mysql version
SQL
0 vote249 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
1 vote221 views1 answer
How to select department from table
SQL
3 votes219 views1 answer
Ms sql skip take
SQL
0 vote227 views1 answer
C# add a textbox in mysql select
SQL
0 vote243 views2 answers
Call to undefined function mysql_query()
SQL
8 votes231 views1 answer
Oracle create datafile
SQL