Python not recognizing multilevel index

Question

I have a dataframe that currently looks like this:

country series year value 
usa     a      2010 21
usa     b      2015 22
usa     a      2017 23
usa     b      2010 22
usa     b      2017 23

aus     a      2010 21
aus     b      2015 22
aus     a      2017 23
aus     b      2010 22
aus     b      2017 23

When I run this code, it reduces the duplicity of the countries but not the series like I expect it to.

pop2.set_index(['Country','Series'])

I want:

country series year value 
usa     a      2010 21
               2017 23
        b      2010 22
               2015 22
               2017 23
aus     a      2010 21                  
               2017 23
        b      2010 22
               2015 22
               2017 23

Instead, it is returning:

country series year value 
usa     a      2010 21
        b      2015 22
        a      2017 23
        b      2010 22
        b      2017 23
aus     a      2010 21
        b      2015 22
        a      2017 23
        b      2010 22
        b      2017 23

pandas.pydata.org/pandas-docs/stable/advanced.html

BENY
– BENY

2017-12-01 22:56:34 +00:00
Commented Dec 1, 2017 at 22:56 — BENY
– BENY, Commented Dec 1, 2017 at 22:56
What about a groupby instead?

Aakash Verma
– Aakash Verma

2017-12-01 22:57:43 +00:00
Commented Dec 1, 2017 at 22:57 — Aakash Verma
– Aakash Verma, Commented Dec 1, 2017 at 22:57

Scott Boston · Accepted Answer · 2017-12-02 02:35:13Z

1

There must be an index label for each row to display in a dataframe. Therefore, you need is a another level of index then you can show index "grouping" as you wish.

Let's try this:

df.set_index(['country','series',np.arange(df.shape[0])]).sort_index()

Output:

                  year  value
country series               
aus     a      5  2010     21
               7  2017     23
        b      6  2015     22
               8  2010     22
               9  2017     23
usa     a      0  2010     21
               2  2017     23
        b      1  2015     22
               3  2010     22
               4  2017     23

answered Dec 2, 2017 at 2:35

Scott Boston

154k15 gold badges160 silver badges207 bronze badges

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

Collectives™ on Stack Overflow

Python not recognizing multilevel index

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