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