python - Pandas Latitude-Longitude: Calculate the distance between two points and select the nearest one

Question

I have a dataframe with 15k rows with coordinates and the names of the locations (mainly businesses)

spot	lat1	l1	place	lat2	lon2
1	41,1808128356934	-8,53291034698486	A	41.146749	-8.613889
1	41,1808128356934	-8,53291034698486	B	41.146105	-8.609868
2	41,1491432189941	-8,61034202575684	A	41.146749	-8.613889
2	41,1491432189941	-8,61034202575684	B	41.146105	-8.609868

question from:https://stackoverflow.com/questions/66047318/pandas-latitude-longitude-calculate-the-distance-between-two-points-and-select

Answer 1

Your lat1 and lon1 are strings. Maybe you want to replace , with . and convert to float before you calculate the norm:

df[['lat1', 'lon1']] = df[['lat1','lon1']].apply(lambda x: pd.to_numeric(x.str.replace(',','.')) )