/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

0 vote193 views6 answers
Nlp generate parse tree in python
Python
0 vote145 views1 answer
Tkinter convert Entry to string
Python
0 vote155 views1 answer
Python apt manager
Python
13 votes137 views1 answer
What is a slug
Python
0 vote136 views1 answer
Jupyter notebook do not show matplotlib text above plot
Python
10 votes142 views2 answers
How to find length of number in python
Python
0 vote160 views3 answers
When was python 3 released
Python
0 vote151 views1 answer
Rename column in pandas with second row
Python
0 vote133 views5 answers
Python calculator code copy and paste
Python
0 vote164 views1 answer
Compose functions python
Python