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 vote298 views1 answer
Custom django password checker
Python
1 vote319 views1 answer
How to Add a overall Title to Seaborn Plots
Python
21 votes304 views4 answers
Floor function in python
Python
4 votes366 views4 answers
Convert image to grayscale opencv
Python
0 vote356 views1 answer
RuntimeError: Please use tf.experimental.tensorrt.Converter in TF 2.0. site:stackoverflow.com
Python
0 vote300 views1 answer
Summation django queryset
Python Django
1 vote319 views1 answer
__delattr__ python
Python
0 vote333 views1 answer
Find Files With a Certain Extension in the Directory and Its Subdirectories in Python
Python
0 vote299 views1 answer
Django multiple search fields
Python
0 vote351 views1 answer
Pandas resamples stratified by columns values
Python