/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 vote194 views1 answer
Skip security check selenium linkedin python
Python
1 vote171 views1 answer
Variable inside class not detecting global variable in python
Python
0 vote158 views1 answer
How to check if a list is a subset of another list
Python
0 vote180 views1 answer
Radio button selected event
Python
0 vote179 views1 answer
Multiple args for pandas apply
Python
6 votes254 views6 answers
Fibonacci python
Python
0 vote211 views1 answer
Django extend user model
Python Django
4 votes170 views2 answers
Python join array of ints
Python
0 vote170 views1 answer
Aws lambda logging with python logging library
Python
2 votes173 views1 answer
Database default code in settings django
Python