And I want to filter the results by grouping the columns based on max transaction_date column
I have the following dataset
So the results will be like
What's the easiest way for doing this with pandas Thanks