/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

-2 votes136 views1 answer
Python telegram bot get user name
Python
0 vote148 views1 answer
Python write value in next row of existing .text file
Python
-1 vote140 views2 answers
Append multiple elements
Python
0 vote148 views2 answers
Operator in django query
Python Django
3 votes134 views1 answer
Python3 return a list of indexes of a specific character in a string
Python
0 vote150 views1 answer
Cross entropy
Python
1 vote161 views1 answer
Liczby zespolone python
Python
0 vote139 views1 answer
Dont truncate dataframe jupyter pd display options
Python
0 vote170 views1 answer
Spacy get number of tokens
Python
-1 vote130 views1 answer
Pandas don't truncate long values
Python