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 vote137 views1 answer
How to take long input in python
Python
0 vote135 views1 answer
List in one line of text in python
Python
0 vote137 views1 answer
Space complexity python
Python
0 vote141 views1 answer
Somebody please get rid of my annoying-as-hell sunburn!!!
Python
3 votes98 views1 answer
Torch view
Python
0 vote148 views1 answer
Program for length of the shortest word
Python
2 votes220 views3 answers
Django queryset to list
Python Django
0 vote132 views1 answer
Tree recursive function
Python
0 vote144 views1 answer
Using shebang python
Python
0 vote134 views1 answer
Inicio programacao python
Python