/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

9 votes135 views6 answers
Sql add column with default value
SQL
1 vote133 views2 answers
Extract weekday from date in sql
SQL
1 vote143 views1 answer
Postgres cast as currency format
SQL
2 votes128 views1 answer
Get first n letter of department name in sql
SQL
0 vote131 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote132 views1 answer
Oracle array
SQL
50 votes220 views6 answers
Install mysql on ubuntu
SQL
0 vote151 views1 answer
Oracle winter time change
SQL
0 vote285 views1 answer
Get first match in each group mysql query
SQL
0 vote133 views2 answers
How to use aggregate functions in sql
SQL