/Python/How to save query data into dataframe pscopg2

How to save query data into dataframe pscopg2

import pandas as pd
import pandas.io.sql as sqlio
import psycopg2

conn = psycopg2.connect("host='{}' port={} dbname='{}' user={} password={}".format(host, port, dbname, username, pwd))
sql = "select count(*) from table;"
dat = sqlio.read_sql_query(sql, conn)
conn = None

Similar codes

0 vote368 views1 answer
Queryset.raw() in django rest framework joining tables
Python Django
3 votes224 views2 answers
Python replace values in a matrix
Python
1 vote272 views3 answers
Django logout user
Python
8 votes283 views4 answers
Df.drop index
Python
0 vote264 views6 answers
Sd
Python
0 vote356 views1 answer
Django 3 create async rest api
Python Django
0 vote278 views1 answer
Pyglet on button press
Python
0 vote261 views1 answer
How to restart a loop
Python
23 votes327 views3 answers
Install django rest framework
Python Django
3 votes257 views2 answers
Find all indices of element in string python
Python