/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 vote146 views1 answer
Recursive Folder scan
Python
1 vote163 views1 answer
Set icon title tkinter
Python
0 vote135 views1 answer
Frontmost flag qt
Python
0 vote191 views1 answer
Python conditions symbols
Python
6 votes143 views2 answers
Multiple plot in one figure python
Python
2 votes207 views2 answers
Correlation plot python seaborn
Python
1 vote151 views2 answers
Maximizar ventana tkinter python
Python
3 votes182 views2 answers
Df.loc
Python
13 votes154 views5 answers
How to press enter in selenium python
Python
1 vote156 views1 answer
Frequency of occurrence of that element in the list and the positions
Python