Skip to main content
`Ctrl`+`K`

# pandas.DataFrame.expanding

DataFrame.expanding(min_periods=1, axis=<no_default>, method='single')

  Provide expanding window calculations.

  Parameters:
    min_periodsint, default 1

      Minimum number of observations in window required to have a value; otherwise, result is `np.nan`.

    axisint or str, default 0

      If `0` or `'index'`, roll across the rows.

      If `1` or `'columns'`, roll across the columns.

      For Series this parameter is unused and defaults to 0.

    methodstr {‘single’, ‘table’}, default ‘single’

      Execute the rolling operation per single column or row (`'single'`) or over the entire object (`'table'`).

      This argument is only implemented when specifying `engine='numba'` in the method call.

      Added in version 1.3.0.

  Returns:
    pandas.api.typing.Expanding

  See also

  `rolling`

    Provides rolling window calculations.

  `ewm`

    Provides exponential weighted functions.

  Notes

  See Windowing Operations for further usage details and examples.

  Examples

      >>> df = pd.DataFrame({"B": [0, 1, 2, np.nan, 4]})
      >>> df
           B
      0  0.0
      1  1.0
      2  2.0
      3  NaN
      4  4.0

  min_periods

  Expanding sum with 1 vs 3 observations needed to calculate a value.

      >>> df.expanding(1).sum()
           B
      0  0.0
      1  1.0
      2  3.0
      3  3.0
      4  7.0
      >>> df.expanding(3).sum()
           B
      0  NaN
      1  NaN
      2  3.0
      3  3.0
      4  7.0