/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 vote181 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote212 views1 answer
Get initial in sql
SQL
0 vote249 views1 answer
Get first monday of month sql
SQL
8 votes187 views1 answer
Oracle search stored procedures for text
SQL
2 votes204 views2 answers
Mysql does sentence contain word
SQL
0 vote177 views1 answer
Mysql change default collation
SQL
0 vote184 views1 answer
Ajax error exception handeling
SQL
3 votes222 views1 answer
Export postgres database linux
SQL
3 votes232 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote184 views1 answer
Trigger stock phpmyadmin output message
SQL