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

18 votes333 views1 answer
How to get directory path in python
Python
0 vote378 views2 answers
Generate random password django
Python Django
0 vote324 views1 answer
How to iclude parcentage in pivot table in pandas
Python
22 votes315 views2 answers
How to plotting points on matplotlib
Python
1 vote387 views1 answer
Django queryset multiple filters
Python Django
1 vote380 views2 answers
Django sum get 0 if none
Python
0 vote354 views1 answer
Pandas pull value from column
Python
0 vote361 views1 answer
How to rename rengeindex pandas
Python
0 vote351 views1 answer
Flask gunicorn get ip
Python
7 votes332 views1 answer
Python xrange
Python