/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

48 votes352 views6 answers
Random password generator python
Python
0 vote313 views1 answer
Seconds since epoc python
Python
0 vote357 views2 answers
Insert data tinydb
Python
1 vote283 views1 answer
Django auto increment field
Python Django
31 votes348 views1 answer
Télécharger dataframe python extract
Python
1 vote319 views1 answer
Pandas dataframe convert nan to string
Python
0 vote340 views1 answer
Hsv to rgb python
Python
0 vote351 views1 answer
Django require_POST body
Python Django
97 votes314 views5 answers
How to make a python exe
Python
5 votes341 views4 answers
Xticks and yticks matplotlib
Python