Sqlite to pandas

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)

Source: stackoverflow.com

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 query here>, con)

Source: stackoverflow.com

Similar codes

6 votes311 views1 answer
Pandas standard deviation on column
Python
1 vote280 views1 answer
How to identify GPU with pytorch script
Python
0 vote311 views1 answer
Multiple args for pandas apply
Python
3 votes301 views3 answers
String list to list
Python
0 vote279 views2 answers
Python test if you can convert to int
Python
2 votes284 views1 answer
How to install dask in python
Python
9 votes338 views3 answers
Find python path windows
Python
3 votes298 views1 answer
Chech box in tkinter
Python
0 vote302 views1 answer
Performance of extend vs append loop
Python
0 vote292 views1 answer
Turn off xticks matplotlib
Python