/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 vote349 views1 answer
Syntax of Ternary Operator
Python
0 vote314 views1 answer
Starting variable name with underscore python
Python
0 vote275 views1 answer
Create requirements file and load it in new envirnment.
Python
0 vote292 views2 answers
Python if not none in one line
Python
0 vote287 views1 answer
Python drop the first word
Python
2 votes286 views1 answer
Python calling dynamic function on object
Python
0 vote274 views1 answer
Choose custom index pandas
Python
0 vote281 views1 answer
Dataframe move row up one
Python
1 vote292 views1 answer
Python get os cores
Python
6 votes303 views6 answers
Python dict
Python