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 votes129 views1 answer
How to make a star in python turtle
Python
0 vote117 views1 answer
Python turtle triangle
Python
0 vote116 views1 answer
Make a copy for parsing dataframe python
Python
0 vote134 views1 answer
Dalsports
Python
1 vote117 views1 answer
Python cv2 imwrite
Python
2 votes115 views3 answers
Python datetime no milliseconds
Python
0 vote117 views1 answer
How to show line chart in seaborn lib
Python
0 vote63 views0 answer
Python
0 vote104 views1 answer
IBM Maximo automation python
Python
0 vote106 views1 answer
Alpaca examples
Python