read sqlite table as dataframe code example
Example: 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)
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)