Skip to content

Latest commit

 

History

History
525 lines (354 loc) · 17.2 KB

indexing.rst

File metadata and controls

525 lines (354 loc) · 17.2 KB

Indexing and selecting data

.. ipython:: python
   :suppress:

    import numpy as np
    import pandas as pd
    import xarray as xr
    np.random.seed(123456)

Similarly to pandas objects, xarray objects support both integer and label based lookups along each dimension. However, xarray objects also have named dimensions, so you can optionally use dimension names instead of relying on the positional ordering of dimensions.

Thus in total, xarray supports four different kinds of indexing, as described below and summarized in this table:

Dimension lookup Index lookup DataArray syntax Dataset syntax
Positional By integer arr[:, 0] not available
Positional By label arr.loc[:, 'IA'] not available
By name By integer arr.isel(space=0) or
arr[dict(space=0)]
ds.isel(space=0) or
ds[dict(space=0)]
By name By label arr.sel(space='IA') or
arr.loc[dict(space='IA')]
ds.sel(space='IA') or
ds.loc[dict(space='IA')]

Positional indexing

Indexing a :py:class:`~xarray.DataArray` directly works (mostly) just like it does for numpy arrays, except that the returned object is always another DataArray:

.. ipython:: python

    arr = xr.DataArray(np.random.rand(4, 3),
                       [('time', pd.date_range('2000-01-01', periods=4)),
                        ('space', ['IA', 'IL', 'IN'])])
    arr[:2]
    arr[0, 0]
    arr[:, [2, 1]]

Attributes are persisted in all indexing operations.

Warning

Positional indexing deviates from the NumPy when indexing with multiple arrays like arr[[0, 1], [0, 1]], as described in :ref:`orthogonal`. See :ref:`pointwise indexing` for how to achieve this functionality in xarray.

xarray also supports label-based indexing, just like pandas. Because we use a :py:class:`pandas.Index` under the hood, label based indexing is very fast. To do label based indexing, use the :py:attr:`~xarray.DataArray.loc` attribute:

.. ipython:: python

    arr.loc['2000-01-01':'2000-01-02', 'IA']

You can perform any of the label indexing operations supported by pandas, including indexing with individual, slices and arrays of labels, as well as indexing with boolean arrays. Like pandas, label based indexing in xarray is inclusive of both the start and stop bounds.

Setting values with label based indexing is also supported:

.. ipython:: python

    arr.loc['2000-01-01', ['IL', 'IN']] = -10
    arr


Indexing with labeled dimensions

With labeled dimensions, we do not have to rely on dimension order and can use them explicitly to slice data. There are two ways to do this:

  1. Use a dictionary as the argument for array positional or label based array indexing:

    .. ipython:: python
    
        # index by integer array indices
        arr[dict(space=0, time=slice(None, 2))]
    
        # index by dimension coordinate labels
        arr.loc[dict(time=slice('2000-01-01', '2000-01-02'))]
    
    
  2. Use the :py:meth:`~xarray.DataArray.sel` and :py:meth:`~xarray.DataArray.isel` convenience methods:

    .. ipython:: python
    
        # index by integer array indices
        arr.isel(space=0, time=slice(None, 2))
    
        # index by dimension coordinate labels
        arr.sel(time=slice('2000-01-01', '2000-01-02'))
    
    

The arguments to these methods can be any objects that could index the array along the dimension given by the keyword, e.g., labels for an individual value, Python :py:func:`slice` objects or 1-dimensional arrays.

Note

We would love to be able to do indexing with labeled dimension names inside brackets, but unfortunately, Python does yet not support indexing with keyword arguments like arr[space=0]

Warning

Do not try to assign values when using any of the indexing methods isel, isel_points, sel or sel_points:

# DO NOT do this
arr.isel(space=0) = 0

Depending on whether the underlying numpy indexing returns a copy or a view, the method will fail, and when it fails, it will fail silently. Instead, you should use normal index assignment:

# this is safe
arr[dict(space=0)] = 0

Pointwise indexing

xarray pointwise indexing supports the indexing along multiple labeled dimensions using list-like objects. While :py:meth:`~xarray.DataArray.isel` performs orthogonal indexing, the :py:meth:`~xarray.DataArray.isel_points` method provides similar numpy indexing behavior as if you were using multiple lists to index an array (e.g. arr[[0, 1], [0, 1]] ):

.. ipython:: python

    # index by integer array indices
    da = xr.DataArray(np.arange(56).reshape((7, 8)), dims=['x', 'y'])
    da
    da.isel_points(x=[0, 1, 6], y=[0, 1, 0])

There is also :py:meth:`~xarray.DataArray.sel_points`, which analogously allows you to do point-wise indexing by label:

.. ipython:: python

    times = pd.to_datetime(['2000-01-03', '2000-01-02', '2000-01-01'])
    arr.sel_points(space=['IA', 'IL', 'IN'], time=times)

The equivalent pandas method to sel_points is :py:meth:`~pandas.DataFrame.lookup`.

Dataset indexing

We can also use these methods to index all variables in a dataset simultaneously, returning a new dataset:

.. ipython:: python

    ds = arr.to_dataset(name='foo')
    ds.isel(space=[0], time=[0])
    ds.sel(time='2000-01-01')
    ds2 = da.to_dataset(name='bar')
    ds2.isel_points(x=[0, 1, 6], y=[0, 1, 0], dim='points')

Positional indexing on a dataset is not supported because the ordering of dimensions in a dataset is somewhat ambiguous (it can vary between different arrays). However, you can do normal indexing with labeled dimensions:

.. ipython:: python


    ds[dict(space=[0], time=[0])]
    ds.loc[dict(time='2000-01-01')]

Using indexing to assign values to a subset of dataset (e.g., ds[dict(space=0)] = 1) is not yet supported.

Dropping labels

The :py:meth:`~xarray.Dataset.drop` method returns a new object with the listed index labels along a dimension dropped:

.. ipython:: python

    ds.drop(['IN', 'IL'], dim='space')

drop is both a Dataset and DataArray method.

Nearest neighbor lookups

The label based selection methods :py:meth:`~xarray.Dataset.sel`, :py:meth:`~xarray.Dataset.reindex` and :py:meth:`~xarray.Dataset.reindex_like` all support method and tolerance keyword argument. The method parameter allows for enabling nearest neighbor (inexact) lookups by use of the methods 'pad', 'backfill' or 'nearest':

.. ipython:: python

    data = xr.DataArray([1, 2, 3], [('x', [0, 1, 2])])
    data.sel(x=[1.1, 1.9], method='nearest')
    data.sel(x=0.1, method='backfill')
    data.reindex(x=[0.5, 1, 1.5, 2, 2.5], method='pad')

Tolerance limits the maximum distance for valid matches with an inexact lookup:

.. ipython:: python

    data.reindex(x=[1.1, 1.5], method='nearest', tolerance=0.2)

Using method='nearest' or a scalar argument with .sel() requires pandas version 0.16 or newer. Using tolerance requries pandas version 0.17 or newer.

The method parameter is not yet supported if any of the arguments to .sel() is a slice object:

.. ipython::
    :verbatim:

    In [1]: data.sel(x=slice(1, 3), method='nearest')
    NotImplementedError

However, you don't need to use method to do inexact slicing. Slicing already returns all values inside the range (inclusive), as long as the index labels are monotonic increasing:

.. ipython:: python

    data.sel(x=slice(0.9, 3.1))

Indexing axes with monotonic decreasing labels also works, as long as the slice or .loc arguments are also decreasing:

.. ipython:: python

    reversed_data = data[::-1]
    reversed_data.loc[3.1:0.9]

Masking with where

Indexing methods on xarray objects generally return a subset of the original data. However, it is sometimes useful to select an object with the same shape as the original data, but with some elements masked. To do this type of selection in xarray, use :py:meth:`~xarray.DataArray.where`:

.. ipython:: python

    arr2 = xr.DataArray(np.arange(16).reshape(4, 4), dims=['x', 'y'])
    arr2.where(arr2.x + arr2.y < 4)

This is particularly useful for ragged indexing of multi-dimensional data, e.g., to apply a 2D mask to an image. Note that where follows all the usual xarray broadcasting and alignment rules for binary operations (e.g., +) between the object being indexed and the condition, as described in :ref:`comput`:

.. ipython:: python

    arr2.where(arr2.y < 2)

By default where maintains the original size of the data. For cases where the selected data size is much smaller than the original data, use of the option drop=True clips coordinate elements that are fully masked:

.. ipython:: python

    arr2.where(arr2.y < 2, drop=True)

Multi-level indexing

Just like pandas, advanced indexing on multi-level indexes is possible with loc and sel. You can slice a multi-index by providing multiple indexers, i.e., a tuple of slices, labels, list of labels, or any selector allowed by pandas:

.. ipython:: python

    midx = pd.MultiIndex.from_product([list('abc'), [0, 1]],
                                      names=('one', 'two'))
    mda = xr.DataArray(np.random.rand(6, 3),
                       [('x', midx), ('y', range(3))])
    mda
    mda.sel(x=(list('ab'), [0]))

You can also select multiple elements by providing a list of labels or tuples or a slice of tuples:

.. ipython:: python

   mda.sel(x=[('a', 0), ('b', 1)])

Additionally, xarray supports dictionaries:

.. ipython:: python

   mda.sel(x={'one': 'a', 'two': 0})

For convenience, sel also accepts multi-index levels directly as keyword arguments:

.. ipython:: python

   mda.sel(one='a', two=0)

Note that using sel it is not possible to mix a dimension indexer with level indexers for that dimension (e.g., mda.sel(x={'one': 'a'}, two=0) will raise a ValueError).

Like pandas, xarray handles partial selection on multi-index (level drop). As shown below, it also renames the dimension / coordinate when the multi-index is reduced to a single index.

.. ipython:: python

   mda.loc[{'one': 'a'}, ...]

Unlike pandas, xarray does not guess whether you provide index levels or dimensions when using loc in some ambiguous cases. For example, for mda.loc[{'one': 'a', 'two': 0}] and mda.loc['a', 0] xarray always interprets ('one', 'two') and ('a', 0) as the names and labels of the 1st and 2nd dimension, respectively. You must specify all dimensions or use the ellipsis in the loc specifier, e.g. in the example above, mda.loc[{'one': 'a', 'two': 0}, :] or mda.loc[('a', 0), ...].

Multi-dimensional indexing

xarray does not yet support efficient routines for generalized multi-dimensional indexing or regridding. However, we are definitely interested in adding support for this in the future (see :issue:`475` for the ongoing discussion).

Copies vs. views

Whether array indexing returns a view or a copy of the underlying data depends on the nature of the labels. For positional (integer) indexing, xarray follows the same rules as NumPy:

  • Positional indexing with only integers and slices returns a view.
  • Positional indexing with arrays or lists returns a copy.

The rules for label based indexing are more complex:

  • Label-based indexing with only slices returns a view.
  • Label-based indexing with arrays returns a copy.
  • Label-based indexing with scalars returns a view or a copy, depending upon if the corresponding positional indexer can be represented as an integer or a slice object. The exact rules are determined by pandas.

Whether data is a copy or a view is more predictable in xarray than in pandas, so unlike pandas, xarray does not produce SettingWithCopy warnings. However, you should still avoid assignment with chained indexing.

Orthogonal (outer) vs. vectorized indexing

Indexing with xarray objects has one important difference from indexing numpy arrays: you can only use one-dimensional arrays to index xarray objects, and each indexer is applied "orthogonally" along independent axes, instead of using numpy's broadcasting rules to vectorize indexers. This means you can do indexing like this, which would require slightly more awkward syntax with numpy arrays:

.. ipython:: python

    arr[arr['time.day'] > 1, arr['space'] != 'IL']

This is a much simpler model than numpy's advanced indexing. If you would like to do advanced-style array indexing in xarray, you have several options:

.. ipython:: python

    arr.values[arr.values > 0.5]

Align and reindex

xarray's reindex, reindex_like and align impose a DataArray or Dataset onto a new set of coordinates corresponding to dimensions. The original values are subset to the index labels still found in the new labels, and values corresponding to new labels not found in the original object are in-filled with NaN.

xarray operations that combine multiple objects generally automatically align their arguments to share the same indexes. However, manual alignment can be useful for greater control and for increased performance.

To reindex a particular dimension, use :py:meth:`~xarray.DataArray.reindex`:

.. ipython:: python

    arr.reindex(space=['IA', 'CA'])

The :py:meth:`~xarray.DataArray.reindex_like` method is a useful shortcut. To demonstrate, we will make a subset DataArray with new values:

.. ipython:: python

    foo = arr.rename('foo')
    baz = (10 * arr[:2, :2]).rename('baz')
    baz

Reindexing foo with baz selects out the first two values along each dimension:

.. ipython:: python

    foo.reindex_like(baz)

The opposite operation asks us to reindex to a larger shape, so we fill in the missing values with NaN:

.. ipython:: python

    baz.reindex_like(foo)

The :py:func:`~xarray.align` function lets us perform more flexible database-like 'inner', 'outer', 'left' and 'right' joins:

.. ipython:: python

    xr.align(foo, baz, join='inner')
    xr.align(foo, baz, join='outer')

Both reindex_like and align work interchangeably between :py:class:`~xarray.DataArray` and :py:class:`~xarray.Dataset` objects, and with any number of matching dimension names:

.. ipython:: python

    ds
    ds.reindex_like(baz)
    other = xr.DataArray(['a', 'b', 'c'], dims='other')
    # this is a no-op, because there are no shared dimension names
    ds.reindex_like(other)

Missing coordinate labels

Coordinate labels for each dimension are optional (as of xarray v0.9). Label based indexing with .sel and .loc uses standard positional, integer-based indexing as a fallback for dimensions without a coordinate label:

.. ipython:: python

    array = xr.DataArray([1, 2, 3], dims='x')
    array.sel(x=[0, -1])

Alignment between xarray objects where one or both do not have coordinate labels succeeds only if all dimensions of the same name have the same length. Otherwise, it raises an informative error:

.. ipython::
    :verbatim:

    In [62]: xr.align(array, array[:2])
    ValueError: arguments without labels along dimension 'x' cannot be aligned because they have different dimension sizes: {2, 3}

Underlying Indexes

xarray uses the :py:class:`pandas.Index` internally to perform indexing operations. If you need to access the underlying indexes, they are available through the :py:attr:`~xarray.DataArray.indexes` attribute.

.. ipython:: python

   arr
   arr.indexes
   arr.indexes['time']

Use :py:meth:`~xarray.DataArray.get_index` to get an index for a dimension, falling back to a default :py:class:`pandas.RangeIndex` if it has no coordinate labels:

.. ipython:: python

    array
    array.get_index('x')