In my dataset, I have a record of credit card transactions. I am trying to create a new column that has the number of times a card has been flagged as fraud.
So if I have a card 11111, and this card has had three transactions flagged as fraud in the entire dataset, I want that column to have the value of three in every row (transaction record) that has this card.
I feel like this should be possible, but I don’t know how to go about it.
Your help is appreciated!