/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

14 votes190 views3 answers
Getting ip address based on phone number python
Python
1 vote184 views1 answer
How shorten with enter long script python
Python
0 vote172 views1 answer
Bulk file name changer in python
Python
0 vote189 views1 answer
How to let only admins do a command in discord.py
Python
3 votes169 views2 answers
Elon musk wikipedia
Python
0 vote178 views1 answer
Feature importance plot
Python
2 votes169 views1 answer
Set http response content type django
Python
1 vote182 views1 answer
How to make a alert box in python
Python
5 votes181 views4 answers
Python get last element in dict
Python
0 vote195 views1 answer
Module 'cv2.cv2' has no attribute 'videowriter'
Python