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 vote347 views2 answers
Cumulative chart python plotly
Python
0 vote343 views1 answer
Run django using nssm
Python
2 votes324 views5 answers
Django documentation
Python
0 vote331 views1 answer
Openpyxl read cell value
Python
0 vote327 views1 answer
Line continutation in r string python
Python
0 vote351 views1 answer
Ctrl c exception python
Python
2 votes376 views2 answers
Django regexvalidator example
Python
2 votes327 views2 answers
Check all python versions ubuntu
Python
0 vote368 views1 answer
Collecting candies codevita solution in python
Python
0 vote342 views1 answer
Python save base64 temp file
Python