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

3 votes180 views5 answers
Python sha256 crypt decrypt
Python
1 vote158 views1 answer
Py exe tkinter
Python
16 votes172 views1 answer
Np.load
Python
4 votes165 views3 answers
How to install python on visual studio code
Python
0 vote164 views1 answer
Arcpy select visible raster
Python
1 vote159 views1 answer
Python convert string to sentence case
Python
1 vote166 views1 answer
Python pandas dataframe column date to string
Python
2 votes160 views1 answer
Python get local ipv4
Python
0 vote170 views1 answer
Colored loop in python turtle
Python
19 votes167 views4 answers
Install python on ubuntu
Python