/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 vote127 views1 answer
Updating to database
Python
0 vote160 views1 answer
Back button django template
Python Django
2 votes137 views1 answer
Python cv2 screen capture
Python
1 vote150 views1 answer
Service
Python
0 vote161 views1 answer
Django customize the user model
Python
0 vote153 views2 answers
Popups in tkinter
Python
0 vote134 views1 answer
Super title python
Python
0 vote170 views1 answer
Fetch json array from mysql django
Python Django
1 vote133 views1 answer
Python install pandas for linux
Python
3 votes120 views1 answer
Get range of items of python list
Python