/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 vote154 views1 answer
Tsql cmd exec script from file
SQL
8 votes157 views1 answer
Oracle create datafile
SQL
-1 vote159 views3 answers
My sql alter table
SQL
0 vote170 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
6 votes164 views2 answers
Where clause in sql
SQL
1 vote168 views1 answer
Sql server update column based on another table
SQL
18 votes185 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
7 votes147 views1 answer
Sql server convert string to date
SQL
0 vote151 views1 answer
Show create table in postgresql
SQL
0 vote255 views1 answer
Mssql unique key accept nulls
SQL