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

0 vote260 views1 answer
Dinoscape für pc
Python
0 vote321 views1 answer
REMOVE ALL ROWS FROM DATFRAME WGICH HAS DATA OLDER THAN 3 MONTHS PANDAS
Python
0 vote302 views3 answers
How to create a User and User profile in django rest framework
Python Django
1 vote253 views1 answer
Array and list in python
Python
8 votes305 views3 answers
Np.arrange
Python
0 vote260 views2 answers
Pandas count number missing values
Python
0 vote280 views1 answer
Rounding with .2g gives strange results
Python
0 vote262 views1 answer
Find all nan columns pandas
Python
0 vote260 views1 answer
Login system user exist in textfile python
Python
-1 vote252 views1 answer
If with && in python
Python