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 vote104 views1 answer
How to deploy to heroku djangorest framework app
Python
0 vote104 views1 answer
Python - Comment convertir le texte en discours
Python
0 vote101 views1 answer
Selenium click on item in a list
Python
0 vote119 views1 answer
NameError: name 'after_this_request' is not defined
Python
5 votes107 views4 answers
Shebang python
Python
15 votes107 views3 answers
Discord.py send image
Python
1 vote125 views1 answer
F string python not working in linux
Python
2 votes132 views1 answer
Values of unique from dataframe with count
Python
24 votes226 views3 answers
Flask vs django
Python Flask
31 votes109 views6 answers
Try except python
Python