/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 vote211 views1 answer
Select row from mysql where date more than 30 days
SQL
6 votes219 views1 answer
Oracle trigger after logon on schema
SQL
6 votes213 views2 answers
Can't connect to local mysql server through socket
SQL
3 votes250 views1 answer
Laravel paginate raw sql
SQL
8 votes249 views1 answer
Mysql limit rows
SQL
2 votes222 views3 answers
Current month mysql query
SQL
0 vote228 views1 answer
Database db connection string format
SQL
0 vote229 views1 answer
Search from comma separated values in sql server
SQL
0 vote216 views1 answer
Mysql utc timestamp
SQL
5 votes238 views2 answers
Mysql create database charset utf8mb4
SQL