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

8 votes248 views2 answers
Firefox selenium python
Python
1 vote241 views1 answer
Defaultdict key exists
Python
4 votes214 views1 answer
How to convert types of variablesin python
Python
0 vote274 views1 answer
Fetch image url discord py
Python
1 vote231 views1 answer
Python how often element in list
Python
1 vote231 views1 answer
Utc to local time python
Python
1 vote236 views2 answers
Find the highest 3 values in a dictionary.
Python
0 vote244 views1 answer
Merge two list of dictionaries python with string
Python
0 vote229 views1 answer
Set shortcut for Qaction pyqt5
Python
4 votes247 views3 answers
Python flip a coin
Python