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

14 votes256 views1 answer
Average value of list elements in python
Python
-1 vote173 views2 answers
Microsoft visual c++ 14.0 is required
Python
1 vote175 views1 answer
Argparse boolean default
Python
0 vote216 views1 answer
Code suggestion html not working in django-html
Python Django
40 votes190 views6 answers
Send email python
Python
1 vote188 views1 answer
Install sklearn-features
Python
0 vote276 views1 answer
How do you read from a dictionary in python
Python
0 vote220 views1 answer
Intersection python dict
Python
-2 votes258 views1 answer
Start django project in windows
Python Django
0 vote217 views2 answers
Check dictionary values pandas dataframe colu
Python