/SQL/Convert sqlite table to pandas dataframe

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

Similar codes

1 vote193 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
2 votes183 views1 answer
Mysql find tables with name
SQL
-1 vote182 views1 answer
Sql getdate date only
SQL
0 vote200 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
0 vote197 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
10 votes139 views1 answer
Oracle view dependencies
SQL
1 vote245 views1 answer
Psql search table
SQL
0 vote203 views1 answer
Window function to forward fill
SQL
0 vote199 views1 answer
Sql server for loop
SQL
1 vote201 views1 answer
Where not in array sql
SQL