/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 vote163 views1 answer
How to see a full row in pandas
Python
3 votes157 views1 answer
Get common elements from two lists
Python
1 vote157 views1 answer
Removing features pandas
Python
3 votes192 views1 answer
Spark df shape
Python
4 votes260 views1 answer
How to make sun as first day in calendar python
Python
3 votes151 views1 answer
Dataframe, sort by columns
Python
1 vote143 views1 answer
Python value error
Python
1 vote165 views1 answer
Python catch sigterm
Python
0 vote155 views1 answer
Jupyter notebook fancy print cross tab
Python
1 vote141 views1 answer
Resto division python
Python