/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 vote168 views2 answers
2nd max salary query in sql
SQL
2 votes175 views1 answer
Mysql select default if null
SQL
3 votes180 views1 answer
DB: in eloquent using sql
SQL
1 vote168 views1 answer
Sql into vs insert into
SQL
0 vote174 views1 answer
Greater than or equal to symbol in postgres
SQL
1 vote148 views1 answer
Can we drop a primary key
SQL
3 votes186 views4 answers
Psql list tables in schema
SQL
0 vote156 views1 answer
INSERT INTO table using OpenQuery
SQL
11 votes187 views3 answers
Sql_mode=only_full_group_by
SQL
1 vote173 views1 answer
Access the postgres psql
SQL