/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 vote298 views2 answers
Alpaca api python wrapper
Python
1 vote366 views1 answer
Portscan with python
Python
0 vote344 views1 answer
Struct trong python
Python
0 vote314 views1 answer
Create series with number intervals
Python
0 vote402 views1 answer
Return the biggest even fro a list python
Python
1 vote324 views2 answers
Python list iterator
Python
0 vote350 views1 answer
Tkinter while button not pressed
Python
2 votes342 views2 answers
Random choice dictionary python
Python
0 vote382 views1 answer
Filter one dataframe by another
Python
0 vote359 views1 answer
Rabin karp algorithm
Python