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

17 votes243 views5 answers
Delete item from list python
Python
0 vote210 views1 answer
Cin python
Python
5 votes186 views2 answers
Python plot two lines on same graph
Python
0 vote200 views2 answers
Call shell script from python
Python
0 vote282 views1 answer
Create new columns pandas from another column
Python
0 vote273 views1 answer
How to add the sum of multiple columns into another column in a dataframe
Python
1 vote195 views1 answer
Dataframe drop rows by column value
Python
0 vote222 views1 answer
Python vrer un fichier texte
Python
0 vote242 views1 answer
Cumulative percentaile pandas
Python
1 vote252 views1 answer
How to change the favicon in flask
Python Flask