/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

1 vote181 views1 answer
Check string equal with regular expression python
Python
0 vote184 views1 answer
Legend of colorbar python
Python
1 vote196 views1 answer
Python see if a number is greater than other
Python
1 vote209 views1 answer
Pandas iterate over a series
Python
4 votes210 views2 answers
Python convert nan to empty string
Python
6 votes181 views6 answers
Pandas drop missing values for any column
Python
-1 vote180 views2 answers
How to find a square root of a number using python
Python
0 vote230 views1 answer
Insert-cells-in-empty-pandas-dataframe
Python
0 vote180 views1 answer
Python import only one function
Python
0 vote214 views1 answer
Python get unique pairs from two lists
Python