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

10 votes323 views4 answers
Discord.py fetch channel
Python
5 votes342 views3 answers
Pandas show duplicate rows
Python
0 vote340 views1 answer
Open chrome with python stack overflow
Python
1 vote299 views1 answer
Matlab find in python
Python
1 vote380 views1 answer
Print only small Latin letters a found in the given string.
Python
2 votes334 views1 answer
Pass in queryset as filter django
Python
4 votes328 views4 answers
Autocomplete in jupyter notebook
Python
5 votes337 views2 answers
Selenium driver wait python
Python
1 vote328 views1 answer
How to smooth a function in python
Python
0 vote340 views1 answer
Pandas column string first n characters
Python