/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 vote347 views1 answer
Automated psql csv export script on windows
SQL
0 vote332 views1 answer
Mysql grant access to one database
SQL
0 vote372 views1 answer
Trigger vérifier stock
SQL
3 votes337 views1 answer
Fk in insert mysql
SQL
14 votes410 views1 answer
How to export db from mysql
SQL
0 vote322 views1 answer
Eliminar ultimo carcacter mysql
SQL
3 votes355 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
0 vote356 views1 answer
Shortcut run sql pgadmin
SQL
15 votes347 views5 answers
Show tables in oracle
SQL
0 vote359 views1 answer
Sql sum if
SQL