/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 vote112 views1 answer
All the symbols on a keyboard python list
Python
0 vote95 views1 answer
Transformers bert
Python
0 vote99 views1 answer
Python playsound stop
Python
3 votes101 views2 answers
How to find the path of a python module
Python
0 vote105 views1 answer
Change date format python code
Python
2 votes103 views1 answer
Version of scikit learn
Python
2 votes297 views2 answers
Python django query
Python Django
18 votes104 views6 answers
Python resize image
Python
-1 vote108 views2 answers
How to find a square root of a number using python
Python
0 vote99 views1 answer
Kivy button on click
Python