/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

3 votes207 views2 answers
How to plotting bar on matplotlib
Python
0 vote193 views1 answer
Matrix diagonal sum leetcode in Python
Python
0 vote197 views1 answer
Selenium python chrome path
Python
0 vote187 views1 answer
Access to specific column array numpy
Python
1 vote183 views1 answer
.replit file python
Python
3 votes179 views2 answers
Map dataframe
Python
3 votes225 views2 answers
How to create a network scanner in python
Python
0 vote187 views1 answer
Student notebook (finish), INB (finish), Food and Fitness log (log necessary), debate speech (finish)
Python
3 votes189 views2 answers
Secondary y axis matplotlib
Python
1 vote189 views1 answer
How many data types are specified to numeric values in python
Python