/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 vote123 views1 answer
Get who is hired in february in sql
SQL
2 votes124 views2 answers
Mysql alter column default
SQL
5 votes116 views4 answers
Restart the psql server windows
SQL
0 vote160 views1 answer
Sqlite display data in separated columns
SQL
0 vote109 views1 answer
Sql select duplicates based on two columns
SQL
7 votes136 views2 answers
How to create index mysql
SQL
0 vote131 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote124 views1 answer
What does leave do in mysql
SQL
1 vote119 views1 answer
Postgres get month name from date
SQL
0 vote119 views1 answer
Connect to nginx server mysql remotly
SQL