create multiindex from dataframe pandas

Question

I'm trying to create the multi-index dataframe from following dataframe:

               date_time                   session
              2015-07-30 10:32:54.000        1
              2015-07-30 10:32:54.000        1
              2015-07-30 10:36:39.000        1            
              2015-07-30 10:36:39.000        1
             ........................        1
              2015-07-30 11:58:57.000        2
              2015-07-30 12:18:37.000        2
              2015-07-30 12:28:51.000        2

to obtain smth like:

        date_time                   session
      2015-07-30 10:32:54.000        1
      2015-07-30 10:32:54.000        
      2015-07-30 10:36:39.000                   
      2015-07-30 10:36:39.000        
     ........................        
      2015-07-30 11:58:57.000        2
      2015-07-30 12:18:37.000        
      2015-07-30 12:28:51.000        
      .......................        3

guiding by the answers for this question: MultiIndex Group By in Pandas Data Frame

I tried this code for my data:

def create_multi():
    multi=df.set_index(['session', 'date'], inplace=True)
    print multi

but it returns None I don't know if this method is appropriate for what I need to do and I just use it not correctly, or I should use another method

philtttx3x · Accepted Answer · 2021-11-11 20:42:07Z

13

You passed inplace=True so it's performed inplace so returns nothing when you assigned to multi.

def create_multi():
    multi=df.set_index(['session', 'date'], inplace=False)
    print multi

The above would work, check the docs, note that the default is inplace=False so it's strictly not necessary to specify if you want that behaviour

edited Nov 11, 2021 at 20:42

philtttx3x

33 bronze badges

answered Oct 15, 2015 at 8:10

EdChum

397k204 gold badges836 silver badges583 bronze badges

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

Collectives™ on Stack Overflow

create multiindex from dataframe pandas

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related