topic Re: Python notebook to delete features in hosted table when any set of 3 values in 3 distinct fields repeats in Python Questions

Python notebook to delete features in hosted table when any set of 3 values in 3 distinct fields repeats

DavidFrisbey — Thu, 09 Nov 2023 20:00:38 GMT

Hi super smart Esri Community,

I am seeking a solution to delete rows in a hosted table through python script in a notebook on AGOL. I can't use any solution that touches a local file like a csv file.

The chunk before this need is:

# delete features with where avg_ is less than 2
Carc.delete_features(where="avg_ < 2")

# where Carc =

The need is something that will delete all rows from this table if three distinct fields within Carc repeat.

For example, in the picture below, the solution would leave each row in the table with a unique set of 3 values in the fields sensor_id, time_stamp, and avg_. So, in the picture below, the solution would leave the 2 first rows and remove 2 of 4 of the last 4 rows, because they have non-unique sets of sensor_id, time_stamp, and avg_.

Best,

Eli L

Re: Python notebook to delete features in hosted table when any set of 3 values in 3 distinct fields repeats

AlfredBaldenweck — Thu, 09 Nov 2023 22:43:12 GMT

Can you use DeleteIdentical()?

Delete Identical (Data Management)—ArcGIS Pro | Documentation

Re: Python notebook to delete features in hosted table when any set of 3 values in 3 distinct fields repeats

KellyTaylor — Wed, 15 Nov 2023 21:10:00 GMT

I haven't tested this so you may have to mess with it a bit but I believe the logic is solid

Re: Python notebook to delete features in hosted table when any set of 3 values in 3 distinct fields repeats

DavidFrisbey — Wed, 22 Nov 2023 20:08:43 GMT

Thank you, Kelly. That works great!

Re: Python notebook to delete features in hosted table when any set of 3 values in 3 distinct fields repeats

DavidFrisbey — Wed, 22 Nov 2023 20:10:52 GMT

Thank you, Alfred. I don't normally use the advanced runtime required for arcpy, yet it is a simple, good solution and I appreciate your time and help.