/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

2 votes243 views2 answers
Python get location of script
Python
1 vote265 views1 answer
Get from time secs and nsecs
Python
2 votes253 views2 answers
Install ide python ubuntu
Python
0 vote255 views1 answer
Small Python Game
Python
0 vote230 views1 answer
Python - subtracting dictionary values
Python
3 votes215 views1 answer
Get_absolute_url in django template
Python
0 vote277 views2 answers
Displaying flash message django
Python Django
1 vote242 views1 answer
Update set python
Python
0 vote240 views1 answer
How to xor two element in python
Python
1 vote248 views2 answers
Python file open try except error
Python