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 vote217 views1 answer
How to use tkinter in google colab
Python
1 vote242 views1 answer
ModuleNotFoundError: No module named 'en_core_web_sm'
Python
0 vote215 views1 answer
Python argparse option groups
Python
0 vote207 views1 answer
Beautifulsoup find get value
Python
5 votes218 views3 answers
How to make addition in python
Python
0 vote212 views1 answer
Gui apps
Python
0 vote248 views1 answer
Sklearn recognising sentences
Python
4 votes296 views2 answers
Read binary file python
Python
2 votes235 views2 answers
Np logical not
Python
8 votes215 views2 answers
New dataframe based on certain row conditions
Python