lake_lat_long = (lake
             >> select(X.DNR_ID_Site_Number, X.latitude, X.longitude) \
             >> group_by(X.DNR_ID_Site_Number,X.latitude, X.longitude)
             >> summarise(counts = n(X.DNR_ID_Site_Number))
             >> drop(X.counts))
lake_lat_long.head()