Multiindex groupby python

Question

I have a Multiindex dataframe like this after groupby and sort value descending usage

peak = df.groupby(["month_year"]).apply(lambda x: x.sort_values(["Usage"], ascending = False)

                  DateTime	       Usage
month_year								
2012-01	  2055	2012-01-22 10:00:00	55	
          351	2012-01-04 16:00:00	52	
         .....
2012-12	 34545	2012-12-25 20:30:00	22
         34505	2012-12-25 10:30:00	21

How can I only keep just the index of first row of each month_year? In other word, I only want to keep '2055' and '34545'?

Scott Boston · Accepted Answer · 2018-07-11 15:41:10Z

1

One way to do this is to use reset_index and groupby:

df1.reset_index(level=1).groupby('month_year').first()

Output:

            level_1             DateTime  Usage
month_year                                     
2012-01        2055  2012-01-22 10:00:00     55
2012-12       34545  2012-12-25 20:30:00     22

answered Jul 11, 2018 at 15:41

Scott Boston

154k15 gold badges160 silver badges207 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Multiindex groupby python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related