/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

4 votes117 views2 answers
Selenium python maximize window
Python
0 vote142 views1 answer
Python turtle get mouse position
Python
20 votes146 views3 answers
Python sort list in reverse
Python
0 vote130 views1 answer
How to implement nfa in python
Python
0 vote137 views1 answer
Python move all txt files
Python
0 vote130 views1 answer
Python draw rectangle on image
Python
0 vote142 views1 answer
Group by pandas to list
Python
0 vote144 views1 answer
Python remove dtype from array
Python
0 vote129 views1 answer
Opencv houghlines only horizontal
Python
0 vote135 views1 answer
Pandas read csv encoding thai
Python