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 vote112 views1 answer
Name =input ("hello how are you ") if name==("good"): print ("Thats nice") else print("stfu")
Python
0 vote102 views1 answer
Remove exponent pandas plot
Python
0 vote99 views1 answer
How many perfect squared lie between 1 and 400
Python
76 votes133 views6 answers
Python iterate through list
Python
0 vote152 views1 answer
Python multi-line statement
Python
4 votes108 views2 answers
How to access variables from a class in python
Python
0 vote102 views1 answer
How to make gtts text to speech converter
Python
0 vote96 views2 answers
Download python on wsl
Python
0 vote104 views1 answer
Python comment header
Python
52 votes110 views6 answers
Save json to file
Python