/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

14 votes137 views3 answers
Delete all records from table except sql
SQL
0 vote140 views1 answer
Sql how to display two atributes as one in sql
SQL
15 votes148 views2 answers
Open postgress in terminal mac
SQL
3 votes138 views3 answers
Into in sql
SQL
5 votes161 views1 answer
Purge undo tablespace usage
SQL
0 vote160 views2 answers
What is rownum in oracle
SQL
0 vote129 views2 answers
How to start postgresql laravel
SQL
0 vote119 views0 answer
SQL
6 votes147 views2 answers
Join vs union
SQL
20 votes159 views4 answers
Sql count if
SQL