FilesExpand file tree

 master

/

querydf.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

7 lines (7 loc) · 257 Bytes

 master

/

querydf.py

Copy path

Top

File metadata and controls

• Code
• Blame

7 lines (7 loc) · 257 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

import psycopg2 as db

import pandas as pd

conn_string="dbname='dataengineering' host='localhost' user='postgres' password='postgres'"

conn=db.connect(conn_string)

df=pd.read_sql("select * from users", conn)

print(df.head())

print(df['city'].value_counts())