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

2 votes158 views1 answer
Graph implementation in python
Python
1 vote160 views1 answer
Swapping of two numbers in python
Python
3 votes177 views1 answer
Clean punctuation from string python
Python
0 vote145 views1 answer
Python create directory if non existent
Python
10 votes148 views2 answers
Selenium refresh page python
Python
0 vote167 views2 answers
Python how to keep turtle window open
Python
66 votes146 views6 answers
Wait function python
Python
4 votes187 views2 answers
Django how to delete a db field
Python Django
0 vote143 views1 answer
Fix certain parameters during curve fit python lambda
Python
16 votes154 views2 answers
Access row of dataframe
Python