/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 vote120 views2 answers
Model.layers[4].set_weights([embedding_matrix])
Python
0 vote106 views1 answer
How to skip the first line of a csv file
Python
8 votes129 views3 answers
Add new column based on condition on some other column in pandas.
Python
2 votes103 views2 answers
How to store object in file python
Python
0 vote111 views2 answers
Scikit learn to identify highly correlated features
Python
0 vote108 views1 answer
Python create a lsit
Python
0 vote116 views1 answer
%%writefile jupyter notebook
Python
1 vote118 views1 answer
How to make a bot send whatever you dm it into a server discord.py
Python
0 vote108 views1 answer
First and last digit codechef solution
Python
41 votes114 views6 answers
Python comments
Python