Pandas Latitude-Longitude to distance between successive rows [duplicate]

by

you can use this great solution (c) @derricw (don’t forget to upvote it ;-):

# vectorized haversine function
def haversine(lat1, lon1, lat2, lon2, to_radians=True, earth_radius=6371):
    """
    slightly modified version: of http://stackoverflow.com/a/29546836/2901002

    Calculate the great circle distance between two points
    on the earth (specified in decimal degrees or in radians)

    All (lat, lon) coordinates must have numeric dtypes and be of equal length.

    """
    if to_radians:
        lat1, lon1, lat2, lon2 = np.radians([lat1, lon1, lat2, lon2])

    a = np.sin((lat2-lat1)/2.0)**2 + \
        np.cos(lat1) * np.cos(lat2) * np.sin((lon2-lon1)/2.0)**2

    return earth_radius * 2 * np.arcsin(np.sqrt(a))


df['dist'] = \
    haversine(df.LAT.shift(), df.LONG.shift(),
                 df.loc[1:, 'LAT'], df.loc[1:, 'LONG'])

Result:

In [566]: df
Out[566]:
   Ser_Numb        LAT       LONG         dist
0         1  74.166061  30.512811          NaN
1         2  72.249672  33.427724   232.549785
2         3  67.499828  37.937264   554.905446
3         4  84.253715  69.328767  1981.896491
4         5  72.104828  33.823462  1513.397997
5         6  63.989462  51.918173  1164.481327
6         7  80.209112  33.530778  1887.256899
7         8  68.954132  35.981256  1252.531365
8         9  83.378214  40.619652  1606.340727
9        10  68.778571   6.607066  1793.921854

UPDATE: this will help to understand the logic:

In [573]: pd.concat([df['LAT'].shift(), df.loc[1:, 'LAT']], axis=1, ignore_index=True)
Out[573]:
           0          1
0        NaN        NaN
1  74.166061  72.249672
2  72.249672  67.499828
3  67.499828  84.253715
4  84.253715  72.104828
5  72.104828  63.989462
6  63.989462  80.209112
7  80.209112  68.954132
8  68.954132  83.378214
9  83.378214  68.778571

More Related Contents:

  1. Fast Haversine Approximation (Python/Pandas)
  2. How do I make a function in python which takes a list of integers as an input and outputs smaller lists with only two values?
  3. pandas create new column based on values from other columns / apply a function of multiple columns, row-wise
  4. Fast punctuation removal with pandas
  5. String concatenation of two pandas columns
  6. How to one-hot-encode from a pandas column containing a list?
  7. Calculate average of every x rows in a table and create new table
  8. Find column name in pandas that matches an array
  9. Efficiently return the index of the first value satisfying condition in array
  10. Vectorised Haversine formula with a pandas dataframe
  11. Group duplicate column IDs in pandas dataframe
  12. Most efficient way to forward-fill NaN values in numpy array
  13. Select multiple ranges of columns in Pandas DataFrame
  14. Suppressing scientific notation in pandas? [duplicate]
  15. Improve Row Append Performance On Pandas DataFrames
  16. Missing data, insert rows in Pandas and fill with NAN
  17. Precision lost while using read_csv in pandas
  18. how to read certain columns from Excel using Pandas – Python
  19. Compute *rolling* maximum drawdown of pandas Series
  20. Normalize data in pandas
  21. Create new column based on values from other columns / apply a function of multiple columns, row-wise in Pandas
  22. How to implode(reverse of pandas explode) based on a column
  23. Pandas in AWS lambda gives numpy error
  24. Pandas groupby with categories with redundant nan
  25. Filling in date gaps in MultiIndex Pandas Dataframe
  26. Python numpy: cannot convert datetime64[ns] to datetime64[D] (to use with Numba)
  27. What’s the best way to sum all values in a Pandas dataframe? [duplicate]
  28. Split Python sequence (time series/array) into subsequences with overlap
  29. Add density curve on the histogram
  30. Numpy.dtype has the wrong size, try recompiling

Leave a Comment