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 vote348 views2 answers
Generate random token or id in django
Python Django
0 vote320 views1 answer
How to find in which directory my python code is running
Python
0 vote293 views1 answer
Checking Availability of user inputted File name
Python
0 vote282 views1 answer
Python which __divs__ are there
Python
12 votes320 views3 answers
Python print on file
Python
0 vote318 views1 answer
Python string to list new line
Python
0 vote286 views1 answer
How to not round numbers in python
Python
0 vote342 views1 answer
Matplotlib.pyplot imshow size
Python
0 vote304 views1 answer
Mechanize python XE #29
Python
0 vote275 views12 answers
Installez django-cruds-adminlte
Python Django