/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

3 votes292 views1 answer
Matplotlib text too small
Python
0 vote284 views1 answer
Python placeholder
Python
9 votes264 views2 answers
Pygame render text
Python
4 votes279 views1 answer
Get os information python
Python
0 vote291 views1 answer
Send operator by parameter python
Python
0 vote286 views1 answer
Spark sparsevector to list
Python
51 votes317 views6 answers
Pandas reorder columns
Python
7 votes281 views3 answers
Pandas df remove index
Python
12 votes290 views6 answers
Python 2d array
Python
0 vote283 views1 answer
Numpy savetext in one line
Python