How calculate distance between two points measured in longitude and latitude

Asked Apr 28 '21 at 14:41

Active Apr 30 '21 at 07:33

Viewed 95 times

I have a dataframe where, columns with subscript 1 are starting points and with 2 are end points. I want to find a difference in kilometers between them. I tried following code however got an error

import mpu
import pandas as pd
import numpy as np

data = {'lat1': [116.51172,116.51135,116.51135,116.51627,116.47186],
        'lon1': [39.92123,39.93883,39.93883,39.91034,39.91248],
        'lat2': [np.nan,116.51172,116.51135,116.51135,116.51627],
        'lon2': [np.nan,39.92123,39.93883,39.93883,39.91034]}  
  
# Create DataFrame  
df_test = pd.DataFrame(data)  


mpu.haversine_distance((df.lat1, df.lon1), (df.lat2, df.lon2))

edited Apr 29 '21 at 11:46

asked Apr 28 '21 at 14:41

John Mayer

what was the error? – Nicholas Hunter Apr 28 '21 at 14:42
have a look at this question: https://stackoverflow.com/q/63722124/4800086 – Swier Apr 28 '21 at 14:43
It says `The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().`. Yes, I also looked that, but could not apply to my dataset (as I have columns, but in this example they have only two points) – John Mayer Apr 28 '21 at 14:52
Edit your question to provide [mre], incl. sample input (we are not going to type in your dataset) as well as full traceback you get. – buran Apr 28 '21 at 15:00
@buran I added the reproducible example of my dataframe – John Mayer Apr 30 '21 at 08:17

How calculate distance between two points measured in longitude and latitude

0 Answers0