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 vote136 views2 answers
Pywhatkit docs
Python
0 vote142 views1 answer
_csv.Error: field larger than field limit (131072)
Python
0 vote121 views1 answer
Python raise filenotfounderror
Python
1 vote140 views2 answers
Winsound python
Python
0 vote152 views1 answer
Python "response is not accessed"
Python
13 votes138 views4 answers
Pickle save
Python
0 vote139 views1 answer
Pandas df to R df
Python
2 votes122 views2 answers
Flask hello world get
Python Flask
0 vote143 views1 answer
Plt text verticalalignment
Python
1 vote126 views3 answers
Convert grayscale to rgb python
Python