Check out example codes for "convert sqlite table to pandas dataframe". It will help you in understanding the concepts better.

Code Example 1

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)

Learn ReactJs, React Native from akashmittal.com