/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

2 votes151 views2 answers
Sql lag
SQL
0 vote163 views1 answer
Sqlcl format
SQL
0 vote128 views1 answer
Update if else mysql
SQL
0 vote203 views1 answer
ORA-01400
SQL
0 vote128 views1 answer
Increment id in mysql
SQL
25 votes153 views6 answers
How to change column name in mysql
SQL
0 vote153 views1 answer
Oracle insert single quote in string
SQL
0 vote128 views1 answer
Oracle 11g forget password
SQL
0 vote203 views1 answer
Get last inserted primary key
SQL
1 vote133 views2 answers
Oracle difference between two dates in seconds
SQL