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 vote228 views1 answer
Spacy get number of tokens
Python
0 vote225 views2 answers
Python fork error
Python
0 vote186 views1 answer
Difference between calling a function and referencing a function python
Python
0 vote194 views1 answer
Python read column data from text file
Python
1 vote197 views3 answers
Pandas difference between dates
Python
0 vote192 views2 answers
Python time a code segment
Python
0 vote190 views1 answer
How to print out even index in python
Python
0 vote183 views1 answer
Python if condition assignment in one line
Python
0 vote193 views1 answer
Open skype ifram through link html
Python
0 vote182 views1 answer
Python class destroying
Python