/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

3 votes231 views1 answer
Python cmd to remove file
Python
13 votes221 views1 answer
Get IP address python
Python
0 vote258 views1 answer
Recieve output from java python
Python
6 votes213 views1 answer
Save and load a dictionary python
Python
0 vote225 views1 answer
Print pattern a shape in python
Python
1 vote188 views1 answer
Install flake8 python
Python
0 vote279 views1 answer
Include app in django project
Python Django
0 vote239 views1 answer
'xml.etree.ElementTree.Element' to string python
Python
32 votes295 views6 answers
Get list of folders in directory python
Python
0 vote245 views1 answer
How to take total count of words in the list python
Python