Hello, I'm trying to build a list of people who fit into a certain criteria from a large list where ID's appear multiple times.
For safety of information I will use a different topic of data but the process/results would be the same.
Say I want to build a zoo and I have a list of names and animals people have seen, the names can appear multiple times due to each animal they have seen.
I decided that I want to advertise to this list of people that my zoo has tigers so I want to filter this list of names to all the the people that haven't seen tigers before.
For ease this list has four animals, penguins, tigers, elephants, giraffes. My end result wanted would be a list of names that haven't seen a tiger, because they might have seen the other three animals they'll be in the list three times. How do I filter and work out how to calculate the ones that haven't seen tigers?
Data will look like this
NAME: Alice ANIMAL: penguin
NAME: James ANIMAL tiger
NAME: Charlie ANIMAL giraffe
NAME: James ANIMAL penguin
NAME: Alice ANIMAL giraffe
So from the above my results need to pull out Alice and Charlie because both have not seen Tigers, but I can't just do a simple question of "if the animal equals tiger then don't include name" because, like with James, he's seen a tiger, so the line with animal as tiger wont be included but the line with the penguin will which is not what I want.
Hopefully this makes sense.
If it helps the end result is just a data set wanted, simple row of names and the names being only those that haven't seen tigers before.
