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

0 vote142 views1 answer
Scrapy get text custom tags
Python
0 vote154 views1 answer
Pyqt button hover color
Python
15 votes150 views5 answers
Join on column pandas
Python
0 vote140 views1 answer
Add many instances to related field manytoamny django]
Python
0 vote146 views1 answer
List of python keywords
Python
0 vote141 views1 answer
Ipython.display latex in the IDE like spyder
Python
3 votes143 views1 answer
Streamlit ssl error
Python
67 votes153 views4 answers
How to know the version of python using cmd
Python
0 vote131 views1 answer
MIn-Max problem in python
Python
1 vote142 views1 answer
Rum system commands python
Python