/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 vote124 views1 answer
How to print some string in mysql
SQL
0 vote130 views1 answer
Mysql grouping functions
SQL
1 vote122 views1 answer
How to subtract from the value of a table in sql
SQL
0 vote66 views1 answer
Ms sql print more than 1 variable
SQL
3 votes108 views1 answer
Delete all content in table mysql
SQL
0 vote79 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
1 vote111 views1 answer
Get count by weekly pivot table sql server
SQL
0 vote120 views1 answer
Why mysql is used?
SQL
0 vote125 views1 answer
Sql server on mac m1
SQL
3 votes138 views1 answer
Define REGEXP?
SQL