Skip to main content
`Ctrl`+`K`

# Version 0.21.1 (December 12, 2017)

This is a minor bug-fix release in the 0.21.x series and includes some small regression fixes, bug fixes and performance improvements. We recommend that all users upgrade to this version.

Highlights include:

- Temporarily restore matplotlib datetime plotting functionality. This should resolve issues for users who implicitly relied on pandas to plot datetimes with matplotlib. See here.

- Improvements to the Parquet IO functions introduced in 0.21.0. See here.

## Restore Matplotlib datetime converter registration

pandas implements some matplotlib converters for nicely formatting the axis labels on plots with `datetime` or `Period` values. Prior to pandas 0.21.0, these were implicitly registered with matplotlib, as a side effect of `import pandas`.

In pandas 0.21.0, we required users to explicitly register the converter. This caused problems for some users who relied on those converters being present for regular `matplotlib.pyplot` plotting methods, so we’re temporarily reverting that change; pandas 0.21.1 again registers the converters on import, just like before 0.21.0.

We’ve added a new option to control the converters: `pd.options.plotting.matplotlib.register_converters`. By default, they are registered. Toggling this to `False` removes pandas’ formatters and restore any converters we overwrote when registering them (GH 18301).

We’re working with the matplotlib developers to make this easier. We’re trying to balance user convenience (automatically registering the converters) with import performance and best practices (importing pandas shouldn’t have the side effect of overwriting any custom converters you’ve already set). In the future we hope to have most of the datetime formatting functionality in matplotlib, with just the pandas-specific converters in pandas. We’ll then gracefully deprecate the automatic registration of converters in favor of users explicitly registering them when they want them.

## New features

### Improvements to the Parquet IO functionality

- `DataFrame.to_parquet()` will now write non-default indexes when the underlying engine supports it. The indexes will be preserved when reading back in with `read_parquet()` (GH 18581).

- `read_parquet()` now allows to specify the columns to read from a parquet file (GH 18154)

- `read_parquet()` now allows to specify kwargs which are passed to the respective engine (GH 18216)

### Other enhancements

- `Timestamp.timestamp()` is now available in Python 2.7. (GH 17329)

- `Grouper` and `TimeGrouper` now have a friendly repr output (GH 18203).

## Deprecations

- `pandas.tseries.register` has been renamed to `pandas.plotting.register_matplotlib_converters()` (GH 18301)

## Performance improvements

- Improved performance of plotting large series/dataframes (GH 18236).

## Bug fixes

### Conversion

- Bug in `TimedeltaIndex` subtraction could incorrectly overflow when `NaT` is present (GH 17791)

- Bug in `DatetimeIndex` subtracting datetimelike from DatetimeIndex could fail to overflow (GH 18020)

- Bug in `IntervalIndex.copy()` when copying and `IntervalIndex` with non-default `closed` (GH 18339)

- Bug in `DataFrame.to_dict()` where columns of datetime that are tz-aware were not converted to required arrays when used with `orient='records'`, raising `TypeError` (GH 18372)

- Bug in `DateTimeIndex` and `date_range()` where mismatching tz-aware `start` and `end` timezones would not raise an err if `end.tzinfo` is None (GH 18431)

- Bug in `Series.fillna()` which raised when passed a long integer on Python 2 (GH 18159).

### Indexing

- Bug in a boolean comparison of a `datetime.datetime` and a `datetime64[ns]` dtype Series (GH 17965)

- Bug where a `MultiIndex` with more than a million records was not raising `AttributeError` when trying to access a missing attribute (GH 18165)

- Bug in `IntervalIndex` constructor when a list of intervals is passed with non-default `closed` (GH 18334)

- Bug in `Index.putmask` when an invalid mask passed (GH 18368)

- Bug in masked assignment of a `timedelta64[ns]` dtype `Series`, incorrectly coerced to float (GH 18493)

### IO

- Bug in `StataReader` not converting date/time columns with display formatting addressed (GH 17990). Previously columns with display formatting were normally left as ordinal numbers and not converted to datetime objects.

- Bug in `read_csv()` when reading a compressed UTF-16 encoded file (GH 18071)

- Bug in `read_csv()` for handling null values in index columns when specifying `na_filter=False` (GH 5239)

- Bug in `read_csv()` when reading numeric category fields with high cardinality (GH 18186)

- Bug in `DataFrame.to_csv()` when the table had `MultiIndex` columns, and a list of strings was passed in for `header` (GH 5539)

- Bug in parsing integer datetime-like columns with specified format in `read_sql` (GH 17855).

- Bug in `DataFrame.to_msgpack()` when serializing data of the `numpy.bool_` datatype (GH 18390)

- Bug in `read_json()` not decoding when reading line delimited JSON from S3 (GH 17200)

- Bug in `pandas.io.json.json_normalize()` to avoid modification of `meta` (GH 18610)

- Bug in `to_latex()` where repeated MultiIndex values were not printed even though a higher level index differed from the previous row (GH 14484)

- Bug when reading NaN-only categorical columns in `HDFStore` (GH 18413)

- Bug in `DataFrame.to_latex()` with `longtable=True` where a latex multicolumn always spanned over three columns (GH 17959)

### Plotting

- Bug in `DataFrame.plot()` and `Series.plot()` with `DatetimeIndex` where a figure generated by them is not picklable in Python 3 (GH 18439)

### GroupBy/resample/rolling

- Bug in `DataFrame.resample(...).apply(...)` when there is a callable that returns different columns (GH 15169)

- Bug in `DataFrame.resample(...)` when there is a time change (DST) and resampling frequency is 12h or higher (GH 15549)

- Bug in `pd.DataFrameGroupBy.count()` when counting over a datetimelike column (GH 13393)

- Bug in `rolling.var` where calculation is inaccurate with a zero-valued array (GH 18430)

### Reshaping

- Error message in `pd.merge_asof()` for key datatype mismatch now includes datatype of left and right key (GH 18068)

- Bug in `pd.concat` when empty and non-empty DataFrames or Series are concatenated (GH 18178 GH 18187)

- Bug in `DataFrame.filter(...)` when `unicode` is passed as a condition in Python 2 (GH 13101)

- Bug when merging empty DataFrames when `np.seterr(divide='raise')` is set (GH 17776)

### Numeric

- Bug in `pd.Series.rolling.skew()` and `rolling.kurt()` with all equal values has floating issue (GH 18044)

### Categorical

- Bug in `DataFrame.astype()` where casting to ‘category’ on an empty `DataFrame` causes a segmentation fault (GH 18004)

- Error messages in the testing module have been improved when items have different `CategoricalDtype` (GH 18069)

- `CategoricalIndex` can now correctly take a `pd.api.types.CategoricalDtype` as its dtype (GH 18116)

- Bug in `Categorical.unique()` returning read-only `codes` array when all categories were `NaN` (GH 18051)

- Bug in `DataFrame.groupby(axis=1)` with a `CategoricalIndex` (GH 18432)

### String

- `Series.str.split()` will now propagate `NaN` values across all expanded columns instead of `None` (GH 18450)

## Contributors

A total of 46 people contributed patches to this release. People with a “+” by their names contributed a patch for the first time.

- Aaron Critchley +

- Alex Rychyk

- Alexander Buchkovsky +

- Alexander Michael Schade +

- Chris Mazzullo

- Cornelius Riemenschneider +

- Dave Hirschfeld +

- David Fischer +

- David Stansby +

- Dror Atariah +

- Eric Kisslinger +

- Hans +

- Ingolf Becker +

- Jan Werkmann +

- Jeff Reback

- Joris Van den Bossche

- Jörg Döpfert +

- Kevin Kuhl +

- Krzysztof Chomski +

- Leif Walsh

- Licht Takeuchi

- Manraj Singh +

- Matt Braymer-Hayes +

- Michael Waskom +

- Mie~~~ +

- Peter Hoffmann +

- Robert Meyer +

- Sam Cohan +

- Sietse Brouwer +

- Sven +

- Tim Swast

- Tom Augspurger

- Wes Turner

- William Ayd +

- Yee Mey +

- bolkedebruin +

- cgohlke

- derestle-htwg +

- fjdiod +

- gabrielclow +

- gfyoung

- ghasemnaddaf +

- jbrockmendel

- jschendel

- miker985 +

- topper-123