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 vote350 views1 answer
Create new dataframe from columns pandas
Python
0 vote341 views1 answer
Introduction to sets python3
Python
1 vote369 views1 answer
Os.execl(sys.executable, sys.executable, *sys.argv)
Python
3 votes371 views2 answers
How to connect python to html
Python
10 votes372 views2 answers
Python get absolute path of file
Python
0 vote347 views2 answers
Py search and get objects from array
Python
184 votes437 views6 answers
How to upgrade pip
Python
3 votes367 views2 answers
Jupyter print full dataframe
Python
0 vote405 views1 answer
Django tempalte tag datetime to timestamp
Python
0 vote368 views1 answer
Find width and height of imported video frame opencv2
Python