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

10 votes129 views3 answers
How to round a number down in python
Python
4 votes168 views1 answer
Django slug int url mapping
Python Django
3 votes168 views1 answer
How to remove integer from string in python
Python
0 vote92 views1 answer
Nohup command python
Python
4 votes143 views1 answer
Flatten nested list
Python
1 vote120 views1 answer
Django pass data between views
Python Django
0 vote165 views1 answer
At=error code=h10 desc= app crashed python flask
Python Flask
4 votes125 views1 answer
Colorcodes Discord.py
Python
4 votes196 views6 answers
Python eval
Python
0 vote161 views1 answer
Free download django app for windows 10
Python Django