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

12 votes241 views2 answers
Matplotlib legend out of plot
Python
1 vote230 views1 answer
How to refresh windows 10 with python
Python
1 vote238 views1 answer
Installing more modules in pypy
Python
0 vote240 views1 answer
Python how to close the turtle tab on click
Python
0 vote247 views1 answer
Python add column with constant value
Python
81 votes247 views6 answers
Loop in python
Python
1 vote277 views1 answer
Use sqlalchemy to create sqlite3 database
Python
0 vote243 views1 answer
Cartpole dqn reward max is 200
Python
0 vote294 views1 answer
Django pre_save get old instance
Python Django
1 vote216 views1 answer
Stringf replcae in python
Python