I have dataframe as shown below:
I need to transform the data set to something shown below.
I have tried to use groupby condition with agg as max. But it is not working as expected.
Could you please help with a python pandas code for the same?
I have dataframe as shown below:
I need to transform the data set to something shown below.
I have tried to use groupby condition with agg as max. But it is not working as expected.
Could you please help with a python pandas code for the same?