pandas get row where max code example

Example 1: pandas get index of max value in column

#use this to get the index of the max value of a column
max_index = column.idxmax()

Example 2: how to find out the max and min date on the basis of property id in pandas

df.groupby([key_field]).agg({'time_field': [np.min,np.max]})