/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

6 votes201 views2 answers
Decimal in python
Python
21 votes219 views6 answers
Python remove key from dict
Python
16 votes211 views4 answers
Python remove last instance of a list
Python
3 votes225 views3 answers
Python codes
Python
0 vote220 views1 answer
Eastvale roblox python
Python
0 vote195 views3 answers
Array of numbers
Python
0 vote210 views1 answer
Sql like equivalent in python
Python
1 vote244 views1 answer
How to make pyautogui faster
Python
0 vote205 views1 answer
Python Split list into chunks using List Comprehension
Python
0 vote197 views1 answer
Customise django admin edit model button in field
Python