/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

0 vote122 views2 answers
Unique key
SQL
0 vote98 views1 answer
Oracle gather table statistics
SQL
-1 vote139 views1 answer
Mysql faster insert
SQL
1 vote113 views1 answer
How to get alternate records from a table in sql
SQL
0 vote107 views1 answer
Sql server delete records with specific date
SQL
0 vote112 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote99 views1 answer
Postgresql update to unique
SQL
0 vote107 views1 answer
Postgresql regular expression special characters
SQL
7 votes116 views3 answers
Sql server reset auto increment
SQL
0 vote100 views1 answer
Oracle select invalid views
SQL