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

5 votes158 views2 answers
Beautifulsoup find by class
Python
0 vote138 views1 answer
Reload is not defined python 3
Python
4 votes140 views1 answer
Python return -1
Python
1 vote145 views1 answer
Save pythonpath
Python
0 vote154 views2 answers
Stackoverflow search
Python
0 vote156 views2 answers
Dataframe multiindex query
Python
0 vote152 views1 answer
Circular heatmap python
Python
76 votes168 views6 answers
For loop in python
Python
6 votes147 views1 answer
Python sort
Python
1 vote155 views1 answer
Plot specific columns pandas
Python