/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 vote270 views1 answer
Basic structure of sql expression having clause
SQL
0 vote360 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote260 views1 answer
What is logical database schema
SQL
0 vote258 views1 answer
How to use query in nosql
SQL
0 vote268 views2 answers
Wordpress change url in database
SQL
6 votes280 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
2 votes260 views1 answer
Wait delay in sql server
SQL
2 votes278 views2 answers
How to add not null constraint in sql
SQL
0 vote288 views1 answer
Sql quary stuf
SQL
15 votes279 views3 answers
Postgresql change column type
SQL