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 vote165 views2 answers
Is vowel python
Python
1 vote173 views1 answer
Numpy find rows containing nan
Python
0 vote173 views4 answers
Comprehension list iloc pandas
Python
25 votes180 views4 answers
Python is ascii
Python
0 vote163 views1 answer
Python format decimal list
Python
5 votes237 views4 answers
Import user in django
Python Django
0 vote185 views1 answer
Make a effective figure in python
Python
0 vote165 views6 answers
Python django
Python
5 votes169 views2 answers
Openpyxl read excel
Python
1 vote250 views1 answer
Pyton count number of character in a word
Python