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 vote262 views1 answer
Xarray add coordinate
Python
-1 vote257 views2 answers
Insert into string python more than one
Python
-1 vote290 views1 answer
Pandas don't truncate long values
Python
0 vote255 views1 answer
Scrapy selenium screnshot
Python
22 votes254 views4 answers
How to remove all characters after a specific character in python?
Python
22 votes263 views4 answers
Access first element of dictionary python
Python
1 vote277 views2 answers
Pygame collisions
Python
0 vote236 views1 answer
Pandas if value present in df index
Python
0 vote294 views1 answer
Python get item from list by index
Python
2 votes267 views1 answer
ValueError: I/O operation on closed file.
Python