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 vote220 views2 answers
Scikit learn to identify highly correlated features
Python
0 vote170 views1 answer
Programmatically determining programming languages based on file extensions in python
Python
2 votes171 views10 answers
Javascript
Python
14 votes197 views2 answers
How to convert csv to excel in python
Python
0 vote183 views1 answer
Jupyter notebook plot background dark theme
Python
0 vote179 views1 answer
How to convert a matrix string back to a matrix python
Python
2 votes175 views2 answers
How to get key of a particular value in dictionary python using index
Python
0 vote212 views1 answer
=adaqtar
Python
0 vote165 views1 answer
Pip.exe The system cannot find the file specified
Python
0 vote188 views1 answer
Mechanize python XE #27
Python