/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

2 votes193 views2 answers
Sqlalchemy filter or
SQL
0 vote184 views1 answer
Strat with in sql
SQL
0 vote202 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote311 views1 answer
Drop check command
SQL
4 votes190 views1 answer
Mysql insert from local csv
SQL
0 vote197 views1 answer
Min:sec datediff mssql
SQL
1 vote244 views1 answer
Postgresql can you have null foreign key
SQL
11 votes230 views1 answer
Ddl view
SQL
0 vote185 views2 answers
Drop check constraint in ms sql
SQL
4 votes189 views1 answer
What are the data types in sql
SQL