/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 vote245 views1 answer
Grant owner postgresql
SQL
0 vote322 views1 answer
Psql create usr
SQL
0 vote283 views1 answer
How to read the potentail error messages in ssis package
SQL
2 votes283 views1 answer
Oracle drop sequence if exists
SQL
0 vote287 views2 answers
Mysql decimal remove trailing zeros
SQL
1 vote275 views1 answer
Apex select list ORA-20999
SQL
-2 votes281 views1 answer
Group functions in sql
SQL
0 vote224 views1 answer
Denied
SQL
8 votes297 views2 answers
Replace string value in sql
SQL
0 vote280 views1 answer
Mysql select where field like in list
SQL