Sqlite to pandas

This article is tagged with: Sqlite to pandas and mysql

sqlite to pandas

import pandas as pd
import sqlite3
con = sqlite3.connect('/Users/mac/Desktop/Python/Baye_stat/productiondisruption/PCI_meat.sqlite')
df = pd.read_sql(<your here="" query="">, con)
</your>

convert sqlite table to pandas dataframe

import sqlite3
import pandas as pd
dat = sqlite3.connect('data.db')
query = dat.execute("SELECT * From <tablename>")
cols = [column[0] for column in query.description]
results= pd.DataFrame.from_records(data = query.fetchall(), columns = cols)</tablename>

This article is tagged with: Sqlite to pandas and mysql