/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

11 votes326 views2 answers
Sql rank
SQL
0 vote334 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote347 views1 answer
Create query in where clasue
SQL
0 vote447 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
2 votes371 views1 answer
Sql as
SQL
10 votes396 views2 answers
Doublon sql
SQL
0 vote348 views1 answer
Mysql count number of occurrences in a column
SQL
42 votes429 views6 answers
Install beautifulsoup
SQL
1 vote323 views1 answer
Find logged in users mysql
SQL
1 vote324 views1 answer
Input in mysql
SQL