topic Re: Join a pandas dataframe to feature class table by matching column in ArcGIS API for Python Questions

Join a pandas dataframe to feature class table by matching column

MaxDuso — Sun, 07 Aug 2022 14:49:49 GMT

Hello there. I have a pandas dataframe and a feature class. The rows of each relate to a set of ecoregions and ecoregions are named in the same way in the "ecoregion_name" column of each. I would like to append, join, insert cursor, or what have you the dataframe to the feature class.

I do not believe that the "arcpy.management.AddJoin" tool supports dataframes. Does it support csv files by chance?

I have also tried using "update cursor" . The issue I encountered here was being unable to access the value of the join field within the "row" for each for loop iteration, so that I could write a conditional statement which made the match happen between the two join columns.

Is there a concise way of doing this without too much data conversion and code that I am missing? Any solution is very appreciated.

Thanks.

Max

Re: Join a pandas dataframe to feature class table by matching column

DanPatterson — Sun, 07 Aug 2022 16:59:57 GMT

csv as input to Table To Table (Conversion)—ArcGIS Pro | Documentation

then addjoin is one approach, unless you want to keep with the arcgis api

Re: Join a pandas dataframe to feature class table by matching column

MaxDuso — Tue, 09 Aug 2022 12:17:18 GMT

Just wondering if I am understanding correctly. You suggest converting the dataframe to a csv, then converting the csv to a gdb using the "Table To Table", at which point it should be able to join to my feature classes table using "AddJoin" as above?

To be clear, I jsut want to add the corresponding data from the df to the feature class whic will be my end product here.

Thanks or the help.

Re: Join a pandas dataframe to feature class table by matching column

DavidAnderson_1701 — Mon, 17 Oct 2022 20:15:07 GMT

Here is code sketch

arcpy.management.AddField('MyFeatureClass','NewFC_Field')

fields =['ecoregion_name', 'NewFC_Field']

with arcpy.da.UpdateCursor('MyFeatureClass','fields) as cursor:

for row in cursor:

row[1] = Dataframe[Dataframe['ecoregion_name' == row[0]]['DataframeFieldToTransfer']

cursor.updateRow(row)

Re: Join a pandas dataframe to feature class table by matching column

ArianaMo1912 — Tue, 12 Sep 2023 19:31:52 GMT

@MaxDuso where you able to find a solution on your own?