What’s new in 1.2.2 (February 09, 2021)#
These are the changes in pandas 1.2.2. See Release notes for a full changelog including other versions of pandas.
Fixed regressions#
Fixed regression in
read_excel()
that caused it to raiseAttributeError
when checking version of older xlrd versions (GH38955)Fixed regression in
DataFrame
constructor reordering element when construction from datetime ndarray with dtype not"datetime64[ns]"
(GH39422)Fixed regression in
DataFrame.astype()
andSeries.astype()
not casting to bytes dtype (GH39474)Fixed regression in
to_pickle()
failing to create bz2/xz compressed pickle files withprotocol=5
(GH39002)Fixed regression in
pandas.testing.assert_series_equal()
andpandas.testing.assert_frame_equal()
always raisingAssertionError
when comparing extension dtypes (GH39410)Fixed regression in
to_csv()
openingcodecs.StreamWriter
in binary mode instead of in text mode and ignoring user-providedmode
(GH39247)Fixed regression in
Categorical.astype()
casting to incorrect dtype whennp.int32
is passed to dtype argument (GH39402)Fixed regression in
to_excel()
creating corrupt files when appending (mode="a"
) to an existing file (GH39576)Fixed regression in
DataFrame.transform()
failing in case of an empty DataFrame or Series (GH39636)Fixed regression in
groupby()
orresample()
when aggregating an all-NaN or numeric object dtype column (GH39329)Fixed regression in
Rolling.count()
where themin_periods
argument would be set to0
after the operation (GH39554)Fixed regression in
read_excel()
that incorrectly raised when the argumentio
was a non-path and non-buffer and theengine
argument was specified (GH39528)
Bug fixes#
pandas.read_excel()
error message when a specifiedsheetname
does not exist is now uniform across engines (GH39250)Fixed bug in
pandas.read_excel()
producing incorrect results when the engineopenpyxl
is used and the excel file is missing or has incorrect dimension information; the fix requiresopenpyxl
>= 3.0.0, prior versions may still fail (GH38956, GH39001)Fixed bug in
pandas.read_excel()
sometimes producing aDataFrame
with trailing rows ofnp.nan
when the engineopenpyxl
is used (GH39181)
Contributors#
A total of 14 people contributed patches to this release. People with a “+” by their names contributed a patch for the first time.
Andrew Wieteska
Erfan Nariman
Joris Van den Bossche
Matthew Roeschke
MeeseeksMachine
Pandas Development Team
Pav A
Richard Shadrach
Simon Hawkins
Thomas Li
Torsten Wörtwein
Vladimir Podolskiy +
jbrockmendel
patrick