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 vote153 views1 answer
Knn imputation in r
Python
7 votes146 views2 answers
Discord.py reference
Python
95 votes150 views6 answers
Create virtual env
Python
0 vote177 views1 answer
How to know if the space button has been clicked in python pygame
Python
0 vote148 views1 answer
Python save figure as pdf
Python
0 vote151 views1 answer
Python dictionary to array
Python
1 vote155 views1 answer
Python how to remove the title of the index from dataframe
Python
25 votes164 views4 answers
Python is ascii
Python
6 votes229 views4 answers
Django change password command line
Python Django
0 vote157 views1 answer
Destroy label tkinter
Python