v0.25.0.rst

What's New in 0.25.0 (April XX, 2019)

Warning

Starting with the 0.25.x series of releases, pandas only supports Python 3.5 and higher. See :ref:`install.dropping-27` for more details.

{{ header }}

These are the changes in pandas 0.25.0. See :ref:`release` for a full changelog including other versions of pandas.

Other Enhancements

• Indexing of DataFrame and Series now accepts zerodim np.ndarray (:issue:`24919`)
• :meth:`Timestamp.replace` now supports the fold argument to disambiguate DST transition times (:issue:`25017`)
• :meth:`DataFrame.at_time` and :meth:`Series.at_time` now support :meth:`datetime.time` objects with timezones (:issue:`24043`)
• Series.str has gained :meth:`Series.str.casefold` method to removes all case distinctions present in a string (:issue:`25405`)
• :meth:`DataFrame.set_index` now works for instances of abc.Iterator, provided their output is of the same length as the calling frame (:issue:`22484`, :issue:`24984`)
• :meth:`DatetimeIndex.union` now supports the sort argument. The behaviour of the sort parameter matches that of :meth:`Index.union` (:issue:`24994`)

Backwards incompatible API changes

Indexing with date strings with UTC offsets

Indexing a :class:`DataFrame` or :class:`Series` with a :class:`DatetimeIndex` with a date string with a UTC offset would previously ignore the UTC offset. Now, the UTC offset is respected in indexing. (:issue:`24076`, :issue:`16785`)

Previous Behavior:

In [1]: df = pd.DataFrame([0], index=pd.DatetimeIndex(['2019-01-01'], tz='US/Pacific'))

In [2]: df
Out[2]:
                           0
2019-01-01 00:00:00-08:00  0

In [3]: df['2019-01-01 00:00:00+04:00':'2019-01-01 01:00:00+04:00']
Out[3]:
                           0
2019-01-01 00:00:00-08:00  0

New Behavior:

.. ipython:: ipython

    df = pd.DataFrame([0], index=pd.DatetimeIndex(['2019-01-01'], tz='US/Pacific'))
    df['2019-01-01 12:00:00+04:00':'2019-01-01 13:00:00+04:00']

Other API Changes

• :class:`DatetimeTZDtype` will now standardize pytz timezones to a common timezone instance (:issue:`24713`)
• Timestamp and Timedelta scalars now implement the :meth:`to_numpy` method as aliases to :meth:`Timestamp.to_datetime64` and :meth:`Timedelta.to_timedelta64`, respectively. (:issue:`24653`)
• :meth:`Timestamp.strptime` will now rise a NotImplementedError (:issue:`25016`)

Deprecations

• Deprecated the M (months) and Y (year) units parameter of :func: pandas.to_timedelta, :func: pandas.Timedelta and :func: pandas.TimedeltaIndex (:issue:`16344`)

Removal of prior version deprecations/changes

• Removed (parts of) :class:`Panel` (:issue:`25047`,:issue:25191,:issue:25231)

Performance Improvements

• Significant speedup in SparseArray initialization that benefits most operations, fixing performance regression introduced in v0.20.0 (:issue:`24985`)
• DataFrame.to_stata() is now faster when outputting data with any string or non-native endian columns (:issue:`25045`)
• Improved performance of :meth:`Series.searchsorted`. The speedup is especially large when the dtype is int8/int16/int32 and the searched key is within the integer bounds for the dtype (:issue:`22034`)

Bug Fixes

Categorical

Datetimelike

Timedelta

Timezones

• Bug in :func:`to_datetime` with utc=True and datetime strings that would apply previously parsed UTC offsets to subsequent arguments (:issue:`24992`)
• Bug in :func:`Timestamp.tz_localize` and :func:`Timestamp.tz_convert` does not propagate freq (:issue:`25241`)

Numeric

• Bug in :meth:`to_numeric` in which large negative numbers were being improperly handled (:issue:`24910`)
• Bug in :meth:`to_numeric` in which numbers were being coerced to float, even though errors was not coerce (:issue:`24910`)

Conversion

Strings

Interval

Indexing

Missing

• Fixed misleading exception message in :meth:`Series.missing` if argument order is required, but omitted (:issue:`10633`, :issue:`24014`).

MultiIndex

• Bug in which incorrect exception raised by :meth:`pd.Timedelta` when testing the membership of :class:`MultiIndex` (:issue:`24570`)

I/O

• Fixed bug in missing text when using :meth:`to_clipboard` if copying utf-16 characters in Python 3 on Windows (:issue:`25040`)
• Bug in :func:`read_json` for orient='table' when it tries to infer dtypes by default, which is not applicable as dtypes are already defined in the JSON schema (:issue:`21345`)

Plotting

Groupby/Resample/Rolling

• Bug in :meth:`pandas.core.resample.Resampler.agg` with a timezone aware index where OverflowError would raise when passing a list of functions (:issue:`22660`)

Reshaping

• Bug in :func:`pandas.merge` adds a string of None if None is assigned in suffixes instead of remain the column name as-is (:issue:`24782`).
• Bug in :func:`merge` when merging by index name would sometimes result in an incorrectly numbered index (:issue:`24212`)
• :func:`to_records` now accepts dtypes to its column_dtypes parameter (:issue:`24895`)

Sparse

• Significant speedup in SparseArray initialization that benefits most operations, fixing performance regression introduced in v0.20.0 (:issue:`24985`)

Other

Contributors

.. contributors:: v0.24.x..HEAD