/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 vote121 views2 answers
Convert string to list of dictionaries
Python
0 vote136 views1 answer
What is a good django orm cookbook
Python
13 votes113 views1 answer
Python read file to variable
Python
0 vote137 views1 answer
List adding to the begining python
Python
0 vote124 views1 answer
Verbose python
Python
-2 votes146 views4 answers
Django datepicker
Python
0 vote127 views1 answer
Skills=request.POST['skills']
Python
1 vote135 views1 answer
Show integer seabron heatmap values
Python
4 votes119 views2 answers
Django how to delete a db field
Python
2 votes123 views2 answers
Python add list to dictionary in loop
Python