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 vote211 views1 answer
Concatenating datfra,esin pandas
Python
0 vote227 views1 answer
2 - 20 python
Python
1 vote232 views1 answer
Add background image in django uploaded file
Python
0 vote188 views1 answer
How to Set Axis Range (xlim, ylim) in Matplotlib
Python
0 vote176 views1 answer
For loop pattern in python stack overflow
Python
33 votes192 views5 answers
Python exit program
Python
1 vote202 views1 answer
Olst = [] a = int(input()) b = int(input()) for ele in range(a,b+1): if ele%2 != 0: olst.append(ele) print(olst[::-1])
Python
0 vote222 views1 answer
A way to extract from a DateTime value data without seconds
Python
1 vote219 views1 answer
Assert len(lex) < self.bucket_specs[-1][1]
Python
4 votes200 views1 answer
How to add condition if null value in django orm
Python