topic Re: GoeAccessor - "Address column not found in dataframe" in ArcGIS API for Python Questions

GoeAccessor - "Address column not found in dataframe"

Anonymous User — Thu, 27 Aug 2020 19:55:53 GMT

Hello everyone,

I am using Python API (1.8.1) and ArcGIS Enterprise (10.7.1) for scripting and automation. I am creating spatially enabled data frames from both feature layer and feature class with GeoAccessor. The conversion is working well. However, when I am trying to use GeoAccessor.from_df(), I am receiving this error message "ValueError: Address column not found in dataframe". There is no column with the name of address in my both feature layer and feature class. I checked the documentation of ArcGIS API for Python. The address_column in GeoAccessor.from_df() is optional. I do not know how to solve this problem.

Thank you

Re: GoeAccessor - "Address column not found in dataframe"

JoeBorgione — Thu, 27 Aug 2020 20:10:48 GMT

This is just a shot in the dark, but what if you were to add that field name and see how it goes? I'm finding with some of the latest technologies (the Arcgis API for Python included) that there are few bumps in the road ahead for as users. That said, as we encounter them and let ESRI know about them, they'll be able to respond and get them taken care of.

Re: GoeAccessor - "Address column not found in dataframe"

LouieRodriguez — Tue, 03 Aug 2021 16:01:18 GMT

Were you ever able to figure out how to use from_df()? There isn't much documentation on how to use it online and yours is the only post I can find mentioning it.

Re: GoeAccessor - "Address column not found in dataframe"

Justin_Greco — Tue, 26 Apr 2022 23:57:32 GMT

In the documentation it says it is optional and if you don’t specify it will look for a column named “address”. This is only for geocoding a data frame on an address field. Probably not the best name for that function in my opinion, from_address might be easier to understand. Best way to get a data frame from a feature layer is to query it and set as_df=True. To get it from a feature class use pd.DataFrame.from_featureclass()