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 vote167 views1 answer
Write int in file python
Python
1 vote163 views1 answer
How to use regex in a list
Python
0 vote297 views1 answer
Can u length a dictionary in python
Python
2 votes171 views1 answer
Best free rat for windows
Python
1 vote167 views1 answer
Lecture de fichier python
Python
0 vote153 views3 answers
Matlab to python
Python
0 vote148 views3 answers
How to create a login page in python
Python
0 vote142 views1 answer
Django get form data from post
Python
0 vote147 views3 answers
How to print a text in python
Python
10 votes136 views4 answers
Confusion matrix with labels sklearn
Python