### Navigation

- index
- modules |
- next |
- previous |
- pandas 0.14.1 documentation »
- API Reference »

# pandas.DataFrame.xs

`DataFrame.``xs`(key, axis=0, level=None, copy=None, drop_level=True)

  Returns a cross-section (row(s) or column(s)) from the Series/DataFrame. Defaults to cross-section on the rows (axis=0).

  Parameters : | key : object Some label contained in the index, or partially in a MultiIndex axis : int, default 0 Axis to retrieve cross-section on level : object, defaults to first n levels (n=1 or len(key)) In case of a key partially contained in a MultiIndex, indicate which levels are used. Levels can be referred by label or position. copy : boolean [deprecated] Whether to make a copy of the data drop_level : boolean, default True If False, returns object with same levels as self.
  Returns : | xs : Series or DataFrame

  Notes

  xs is only for getting, not setting values.

  MultiIndex Slicers is a generic way to get/set values on any level or levels it is a superset of xs functionality, see MultiIndex Slicers

  Examples

      >>> df
         A  B  C
      a  4  5  2
      b  4  0  9
      c  9  7  3
      >>> df.xs('a')
      A    4
      B    5
      C    2
      Name: a
      >>> df.xs('C', axis=1)
      a    2
      b    9
      c    3
      Name: C

      >>> df
                          A  B  C  D
      first second third
      bar   one    1      4  1  8  9
            two    1      7  5  5  0
      baz   one    1      6  6  8  0
            three  2      5  3  5  3
      >>> df.xs(('baz', 'three'))
             A  B  C  D
      third
      2      5  3  5  3
      >>> df.xs('one', level=1)
                   A  B  C  D
      first third
      bar   1      4  1  8  9
      baz   1      6  6  8  0
      >>> df.xs(('baz', 2), level=[0, 'third'])
              A  B  C  D
      second
      three   5  3  5  3

### Navigation

- index
- modules |
- next |
- previous |
- pandas 0.14.1 documentation »
- API Reference »