在Pandas数据帧中有效地找到id上一列的最大值

I am working with a very large dataframe (3.5 million X 150 and takes 25 gigs of memory when unpickled) and I need to find maximum of one column over an id number and a date and keep I am working with a very large dataframe (3.5 m