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

1 vote190 views1 answer
Add time delta pytohn
Python
0 vote184 views1 answer
Find word position in string python
Python
7 votes202 views2 answers
Open csv in coalb
Python
0 vote217 views1 answer
Can't use "pyimage2" as iconphoto
Python
23 votes190 views6 answers
How to take input for list in python
Python
6 votes234 views2 answers
Kill port django
Python Django
5 votes249 views1 answer
Pip3 install pyaml
Python
-1 vote234 views3 answers
Ceil function in python
Python
0 vote211 views1 answer
<type 'file'> python3
Python
0 vote178 views1 answer
Global /tmp/pip-req-build-civioau0/opencv/modules/videoio/src/cap_v4l.cpp (587) autosetup_capture_mode_v4l2 VIDEOIO(V4L2:/dev/video0): device is busy
Python