SQL

Pakages

pandas SQL queries

Examples

code:python

from sqlalchemy import create_engine

import pandas as pd

engine = create_engine('sqlite:///test.sqlite')

with engine.connect() as con:

rs = con.execute("SELECT * FROM Test")

df = pd.DataFrame(rs.fetchall())

df.columns = rs.keys()

code:python

from sqlalchemy import create_engine

import pandas as pd

engine=create_engine("sqlite:///test.sqlite")

df = pd.read_sql_query("SELECT * from Album", engine)

Paid Tutorial

Importing Data in Python (Part 1) | DataCamp