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

-1 vote119 views1 answer
Py to flag converter online
Python
0 vote91 views1 answer
Blender change text during animation
Python
0 vote99 views1 answer
Cannot import name 'joblib'
Python
2 votes93 views2 answers
First day of the month python
Python
0 vote89 views1 answer
Access field values of form django
Python
1 vote94 views1 answer
Sparse categorical cross entropy python
Python
0 vote100 views1 answer
Different types f python loops
Python
0 vote103 views1 answer
Replace substrings in python
Python
0 vote136 views1 answer
Python os.walk recursive
Python
11 votes89 views2 answers
How to send whatsapp message with python
Python