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 vote122 views1 answer
List reverse method in python
Python
1 vote124 views1 answer
Get from time secs and nsecs
Python
0 vote129 views1 answer
Renomear colunas pandas
Python
0 vote133 views1 answer
Django datepicker mindate and maxdate
Python
1 vote131 views1 answer
How to print text after an interger
Python
0 vote126 views1 answer
Python keyboard hold key
Python
0 vote115 views4 answers
Food
Python
17 votes140 views6 answers
Euclidean distance python
Python
0 vote110 views2 answers
TypeError: unsupported operand type(s) for +: 'Fraction' and 'Fraction'
Python
1 vote177 views2 answers
Sns figsize
Python