Attribute error while running apply function in python

Question

I am trying to use this technique Calculate distance between two coordinates for a fixed point in a DataFrame

   from typing import Tuple
import geopy.distance


def distance(
    lat: float, lon: float, fixed_coords: Tuple[float] = (36.7196, -4.42002)
) -> float:
    return geopy.distance.distance((lat, lon), fixed_coords).km


x = dataframe.apply(lambda row: distance(row[lat], row[lon],axis =1))

error:

---> 11 x = dataframe.apply(lambda row: distance(row[lat], row[lon],axis =1))

NameError: name 'lat' is not defined

If those are the literal column names then why aren't you passing them as strings? Like row["lat"], row["lon"]? — Random Davis
– Random Davis, Commented Nov 10, 2022 at 18:40
Yes, but lat and lon need to be in quotes: distance(row['lat'], row['lon'], axis=1) — Tim Roberts
– Tim Roberts, Commented Nov 10, 2022 at 18:41
KeyError: 'lat' when using distance(row['lat'], row['lon'], axis=1) — avxeesh
– avxeesh, Commented Nov 10, 2022 at 18:44

JRose · Accepted Answer · 2022-11-10 18:42:03Z

0

The name error is becasue the interpreter thinks lat and lon are variable names, not the name of columns. Try using strings instead.

x = dataframe.apply(lambda row: distance(row["lat"], row["lon"],axis =1))

answered Nov 10, 2022 at 18:42

JRose

1,4422 gold badges8 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

avxeesh Over a year ago

KeyError: 'lat'

JRose Over a year ago

What is the datatype of row? Are you sure that "lat" and "lon" are present in row?

avxeesh Over a year ago

they are column names in the dataframe containing longitude and latitude data as int64

JRose Over a year ago

If you are getting a KeyError that means "lat" and "lon" are not keys in the dataframe. You should verify all of the column names are what you expect, I recommend using something like this: stackoverflow.com/questions/49188960/…

Collectives™ on Stack Overflow

Attribute error while running apply function in python

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related