/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

1 vote212 views1 answer
Discord.py commands not working
Python
0 vote197 views1 answer
Python search file in directory
Python
1 vote184 views2 answers
How to import file from a different location python
Python
0 vote194 views2 answers
Python multilevel list comprehension
Python
0 vote295 views1 answer
Http://techforcurious.website/simulation-of-pendulum-vpython-tutorial-visual-python/
Python
2 votes228 views2 answers
Numpy print full array to srdout
Python
0 vote210 views1 answer
Assert_series_equal
Python
1 vote192 views1 answer
Read pdf py
Python
11 votes235 views4 answers
Length of string python
Python
0 vote197 views2 answers
Read excel spark
Python