/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

11 votes269 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
0 vote252 views1 answer
Mysql_error replacement
SQL
0 vote259 views1 answer
Mysql multiple count
SQL
0 vote233 views8 answers
Convert sql query to linq online
SQL
-1 vote238 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
23 votes270 views2 answers
Query to delete a database in mysql
SQL
1 vote267 views2 answers
Backup table mssql
SQL
2 votes253 views1 answer
Mysql virtual column
SQL
0 vote234 views1 answer
How to check replication lag in mySQL
SQL
12 votes257 views4 answers
Import mysql database command line linux
SQL