How to remove a data point if it is less than a certain number

Hi,

I hope someone can help as I am very stuck here.

I am trying to protect the data so that individuals cannot be identified.

For example, if I had item for sale, ID of purchaser and gender of purchaser how could I do this so that on the row it pulls our if an item had less than 5 male purchasers it would say "less than 5" under gender?

Thanks 🙂

Output

Preparation

Optimization

Interface Tools

Text Mining

Data Investigation

Accepted answers

Kenda

Hi @rheatubby

I still may be a little unclear to what exactly you're looking for, but here is my attempt at solving your problem. I use a summarize tool to group by the product and gender so I can count how many of each gender has purchased each item. From here, I use a formula to create a field identifying those with a count less than 5 and join it back to the original data. Check out the attached workflow and adapt as you see fit.

If you still have questions, please attach sample input and output data so we can get a better sense of what you're looking for.

Hope this helps!

New Workflow3.yxmd

All comments

Kenda

Hi @rheatubby

If you still have questions, please attach sample input and output data so we can get a better sense of what you're looking for.

Hope this helps!

New Workflow3.yxmd

afv2688

Hello @rheatubby ,

you could use a summarize tool and group by itemID as well as gener and do a count of the amount of purchases.

Afterwards with a formula tool you could easily establish the rules based on an if else ruling.

Regards

rheatubby

This worked perfectly, thank you so much 🙂

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703