python中idxmax_Python Pandas groupby forloop& Idxmax

I have a DataFrame that must be grouped on three levels, and would then have the highest value returned. Each day there is a return for each unique value, and I would like to find the highest return and the details.

data.groupby(['Company','Product','Industry'])['ROI'].idxmax()

The return would show that:

Target - Dish Soap - House had a 5% ROI on 9/17

Best Buy - CDs - Electronics had a 3% ROI on 9/3

was the highest.

Here's some example data:

+----------+-----------+-------------+---------+-----+

| Industry | Product | Industry | Date | ROI |

+----------+-----------+-------------+---------+-----+

| Target | Dish Soap | House | 9/17/13 | 5% |

| Target | Dish Soap | House | 9/16/13 | 2% |

| BestBuy | CDs | Electronics |