/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 votes106 views1 answer
No module named 'django.core.urlresolvers'
Python
2 votes132 views2 answers
Django queryset is in list
Python Django
0 vote154 views1 answer
Set allowed methods flask
Python Flask
0 vote106 views1 answer
Python 'encoding' is an invalid keyword argument for this function"
Python
30 votes92 views6 answers
Is number python
Python
1 vote104 views1 answer
Install python cap
Python
8 votes99 views4 answers
ImportError: No module named pandas
Python
-1 vote99 views1 answer
What does filename = path(file).stem python
Python
-2 votes102 views1 answer
Stats.norm.cdf(2,loc=mean, scale=std_dev)
Python
0 vote101 views1 answer
Shared a local host django
Python