I am using Arcgis Desktop 10.2. Using python script i am trying to resolve the following :
I have 2 columns of data, one containing alphanumeric values, the other some strings like "-1", "-2", "-3" etc.
"-1" means that the data in the first column in no longer needed. The data set is large, millions of rows/ I am supposed to find duplicate string in the first columns. For every match , if all of the rows are marked with "-1" then that value will be removed, or marked by a commentary in another column. If for the match one value(or more) are not "-1" then that value will ignored
Looking at the picture:
"string_1" is found 5 times. Because the last instance is not marked "-1" all the 5 "string_1"'s will remain in the table.
"string_2" is found 4 time. The last values is not marked with "-1", but with "-4", so all the 4 values remain in the table
- "string_3" is found 5 times, and all of this values are marked with "-1". For each of this values a commentary must be made in another column, so that in the future i can remove them form the table.
How can i mach the values in the first column (i need the script to find for itself the duplicate values, because i can't tell it what it is supposed to find, there are millions of values) and then find the duplicates that ALL have "-1" attribute?