Dataframe with two index columns - reset to one index column

Question

I have a data-frame df1 that looks like:

                 col2  col3
date       dept            
2020-05-07 A       29    21
2020-05-08 B       56    12
2020-05-09 C       82    15
2020-05-10 D       13     9
2020-05-11 E       35    13
2020-05-12 F       53    87
2020-05-13 G       25     9
2020-05-14 H       23    63

the data-frame has two index columns (date and dept). How can I change the data-frame so that it is only indexed by date? So my desired output looks like:

           dept  col2  col3
date                   
2020-05-07    A    29    21
2020-05-08    B    56    12
2020-05-09    C    82    15
2020-05-10    D    13     9
2020-05-11    E    35    13
2020-05-12    F    53    87
2020-05-13    G    25     9
2020-05-14    H    23    63

I have tried to use:

df1 = df1.reset_index('date')

without success.

jezrael · Accepted Answer · 2020-05-07 12:17:11Z

1

Here is necessary select column(s) or position(s) for converting to columns:

#convert dept to columns
df1 = df1.reset_index(level='dept')
#convert date to columns
#df1 = df1.reset_index('date')

Or:

df1 = df1.reset_index(level=1)

answered May 7, 2020 at 12:17

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Dataframe with two index columns - reset to one index column

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