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 vote297 views1 answer
Chat bot in python
Python
0 vote280 views1 answer
How to import api keys
Python
10 votes279 views2 answers
TypeError: can only concatenate str (not “int”) to str
Python
0 vote282 views1 answer
Converting column data to sha256 pandas
Python
0 vote271 views1 answer
Change python from 3.8 to 3.7
Python
0 vote279 views1 answer
What is tf.repeat()
Python
-1 vote282 views1 answer
Date and time using tkinter
Python
2 votes305 views1 answer
Downgrade python 3.8 to 3.7 ubuntu
Python
14 votes364 views2 answers
How to delete the last item in a list python
Python
6 votes310 views1 answer
How to set the icon of the window in pygame
Python