Untitled

total_dist = pd.read_csv('total_distances_short.csv')

# Coordinates of Dubai with 20km buffer
N_lat = 25.492410
N_lon = 55.409309
S_lat = 24.805714
S_lon = 55.177467
E_lat = 25.000000
E_lon = 55.696944
W_lat = 25.040857
W_lon = 54.937834

# Find out the number of vendors in total_dist lie within these coordinates
total_dist = total_dist[(total_dist['vendor_lat'] >= S_lat) & (total_dist['vendor_lat'] <= N_lat)]
print(f"Total number of vendors within the coordinates: {total_dist.shape[0]}")

total_dist.to_csv('total_distances_short.csv', index=False)