/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

5 votes164 views2 answers
Jupyter notebook to python script
Python
4 votes135 views1 answer
How to make a custom icon for pygame
Python
0 vote137 views1 answer
How to use import command in python
Python
0 vote155 views1 answer
Python multiclass inheritance with inputs
Python
6 votes131 views4 answers
Python transpose list of lists
Python
31 votes149 views2 answers
Python requests
Python
0 vote138 views1 answer
How to open jupyter notebook from firefox
Python
0 vote149 views1 answer
Beautifulsoup remove empty tags
Python
0 vote181 views1 answer
Python create empty dictionary with keys
Python
10 votes138 views4 answers
Discord.py events
Python