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

20 votes243 views3 answers
Download image python
Python
1 vote250 views1 answer
Django get form id from request
Python Django
0 vote300 views1 answer
Jupyter notebook set password
Python
-2 votes228 views1 answer
Django modelform datetime
Python
0 vote209 views1 answer
How to import files from desktop to python
Python
0 vote245 views1 answer
Sieve of eratosthenes python
Python
1 vote225 views1 answer
Change color of butto in thkinter
Python
1 vote234 views1 answer
How to print time python 3
Python
22 votes247 views4 answers
No module named 'sklearn.cross_validation'
Python
0 vote229 views1 answer
Numpy euclidean distance matrix broadcasting
Python