/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

8 votes163 views3 answers
Remove the First Character From the String in Python Using the Slicing
Python
0 vote239 views1 answer
How to add static files in django 3.2.9
Python Django
1 vote159 views1 answer
Django httpresponseredirect
Python
0 vote165 views1 answer
User registration
Python
0 vote154 views1 answer
Python open multiple .py windows
Python
0 vote169 views1 answer
Dfs and bfs inn python
Python
6 votes170 views2 answers
How to check if django is installed( in python shell)
Python
0 vote215 views1 answer
Django extract array from post matrix
Python Django
2 votes180 views1 answer
Python string remove whitespace and newlines
Python
0 vote172 views1 answer
Get next iterator without incrementing python
Python