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 vote283 views1 answer
How to make a config txt file on python
Python
0 vote277 views1 answer
Viola conda
Python
1 vote270 views1 answer
How to remove python3 on mac
Python
0 vote292 views1 answer
Pd.options.display.max_columns()pd.options.display.max_row()
Python
0 vote249 views1 answer
Matplotlib convert color string to int
Python
5 votes290 views2 answers
A2+b2=c2 calculator
Python
1 vote270 views3 answers
Making ckeditor django responsive
Python
4 votes299 views6 answers
Counter method in python
Python
0 vote274 views2 answers
How to store the variable in dictionary
Python
0 vote270 views1 answer
Modules django
Python