/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 vote230 views1 answer
Show table details postgresql
SQL
1 vote243 views1 answer
Sql select max value from multiple rows
SQL
0 vote225 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote222 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
5 votes241 views3 answers
Sql server utc to local
SQL
9 votes240 views4 answers
How to alter table column name in mysql
SQL
0 vote237 views1 answer
How to get specific salary in sql
SQL
0 vote216 views1 answer
Database get 10 user aleatory
SQL
8 votes218 views2 answers
Mysql query dates between two dates
SQL
0 vote229 views2 answers
Select index table oracle
SQL