DataFrame.interpolate(method='linear', axis=0, limit=None, inplace=False, limit_direction='forward', limit_area=None, downcast=None, **kwargs)
[source]
Interpolate values according to different methods.
Please note that only method='linear'
is supported for DataFrames/Series with a MultiIndex.
Parameters: |
method : {‘linear’, ‘time’, ‘index’, ‘values’, ‘nearest’, ‘zero’, ‘slinear’, ‘quadratic’, ‘cubic’, ‘barycentric’, ‘krogh’, ‘polynomial’, ‘spline’, ‘piecewise_polynomial’, ‘from_derivatives’, ‘pchip’, ‘akima’}
New in version 0.18.1: Added support for the ‘akima’ method Added interpolate method ‘from_derivatives’ which replaces ‘piecewise_polynomial’ in scipy 0.18; backwards-compatible with scipy < 0.18 axis : {0, 1}, default 0
limit : int, default None. Maximum number of consecutive NaNs to fill. Must be greater than 0.
limit_area : {‘inside’, ‘outside’}, default None
If limit is specified, consecutive NaNs will be filled in this direction. New in version 0.21.0. inplace : bool, default False Update the NDFrame in place if possible. downcast : optional, ‘infer’ or None, defaults to None Downcast dtypes if possible.
|
---|---|
Returns: |
|
Filling in NaNs
>>> s = pd.Series([0, 1, np.nan, 3]) >>> s.interpolate() 0 0 1 1 2 2 3 3 dtype: float64
© 2008–2012, AQR Capital Management, LLC, Lambda Foundry, Inc. and PyData Development Team
Licensed under the 3-clause BSD License.
http://pandas.pydata.org/pandas-docs/version/0.23.4/generated/pandas.DataFrame.interpolate.html