/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 vote227 views1 answer
Python manually trigger exception
Python
0 vote247 views3 answers
How to use css in php example
Python
0 vote227 views1 answer
Python utf upper()
Python
0 vote233 views2 answers
Flask api abort
Python
3 votes220 views1 answer
Python find all elements of substring in string
Python
0 vote216 views1 answer
Python pandas return column name of a specific column
Python
0 vote222 views1 answer
Selenium python has no attrirute getText
Python
0 vote227 views1 answer
Reset button combobocx tkinter
Python
0 vote249 views1 answer
Streamlit headings;streamlit text
Python
0 vote210 views1 answer
Python if something exception
Python