Access two one index of multiindex DataFrame

Question

I look for accessing to all elements where the second index equal 'P0 (YI)' but my command doesn't work. Can somebody help me ?

>>> G11
<class 'pandas.core.frame.DataFrame'>
MultiIndex: 10000 entries, (s0000, Averaging) to (s0999, P0 (YI))
Data columns (total 3 columns):
Volume    10000  non-null values
dtypes: float64(3)

>>> G11.ix[(:,'P0 (YI)')]
  File "<stdin>", line 1
    G11.ix[(:,'P0 (YI)')]
            ^
SyntaxError: invalid syntax

use df.xs('P0 (YI)',level=1); The syntax that you want will be available in 0.14, see here: pandas-docs.github.io/pandas-docs-travis/… — Jeff
– Jeff, Commented Mar 25, 2014 at 15:37

Jeff · Accepted Answer · 2014-03-25 15:39:07Z

2

Use G11.xs('P0 (YI)',level=1)

The syntax that you are suggesting will be available in 0.14, see here

answered Mar 25, 2014 at 15:39

Jeff

129k21 gold badges223 silver badges189 bronze badges

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

Comments

acushner · Accepted Answer · 2014-03-25 15:39:10Z

0

try

G11.xs('P0 (YI)', level=1)

answered Mar 25, 2014 at 15:39

acushner

9,9461 gold badge38 silver badges37 bronze badges

Collectives™ on Stack Overflow

Access two one index of multiindex DataFrame

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related