count duplicate USPS collection boxes by lat/lng

count.py

import pandas as pd 
df = pd.read_csv("collection_boxes.csv") 
df = df[['OUTLETID','LATITUDE','LONGITUDE']]
duplicates = df[df.duplicated(['LATITUDE','LONGITUDE'], keep=False)]
print(f'duplicates {duplicates.shape[0]}')
print(duplicates.groupby(by=['LATITUDE','LONGITUDE']).size())