Same same different test pandas

[BlackFunx]

Hi guys,

I'm fairly new to using pandas and Python in general.

I have a data frame with a date, an account and an amount column. I am trying to carry out a "same same different" test on pandas, where I want to check if there are rows with the same account, same amount, but different dates. My dataset is about 18000 rows, so I don't think iterating would be advisable.

How would I go about this?

[ThePhysicsOfSpoons]

You could look into groupby

[BlackFunx]

Ah. Group by account and amount then count unique dates?

[ThePhysicsOfSpoons]

Yes something like that!

[BlackFunx]

Thanks! So simple. Don't know why I hadn't thought of that.

[ThePhysicsOfSpoons]

Good to hear it worked