Version 2.0 Compatibility Tracker (original) (raw)

This is the list of things that are in pandas 2.0 release notes that need to be addressed in pandas-stubs. PR's welcome. If you do a PR, check off the item and put a link to the PR that closed it. One PR can address multiple issues.

Some of these may already have been taken care of, so if so, check them off and indicate with a comment such as "previously complete"

• Int64Index, UInt64Index & Float64Index were deprecated in pandas version 1.4 and have now been removed. Instead Index should be used directly, and can it now take all numpy numeric dtypes, i.e. int8/ int16/int32/int64/uint8/uint16/uint32/uint64/float32/float64 dtypes: remove 1.5 tests and types #626
• The various numeric datetime attributes of DatetimeIndex (day, month, year etc.) were previously in of dtype int64, while they were int32 for arrays.DatetimeArray. They are now int32 on DatetimeIndex also first part of v2.0 changes #632
• Level dtypes on Indexes from Series.sparse.from_coo() are now of dtype int32, the same as they are on the rows/cols on a scipy sparse matrix. Previously they were of dtype int64 first part of v2.0 changes #632
• Index cannot be instantiated using a float16 dtype. Previously instantiating an Index using dtype float16 resulted in a Float64Index with a float64 dtype. first part of v2.0 changes #632
• The following functions gained a new keyword dtype_backend (GH36712) GH: 624 - Added dtype_backend to all read_* functions #655
  • read_csv()
  • read_clipboard()
  • read_fwf()
  • read_excel()
  • read_html()
  • read_xml()
  • read_json()
  • read_sql() GH - 624: Added dtype arg to read_sql #649
  • read_sql_query()
  • read_sql_table()
  • read_orc()
  • read_feather()
  • read_spss()
  • to_numeric()
  • DataFrame.convert_dtypes()
  • Series.convert_dtypes()
• Copy-on-Write can be enabled through one of
  • pd.set_option("mode.copy_on_write", True)
  • pd.options.mode.copy_on_write = True
  • with pd.option_context("mode.copy_on_write", True):
• Added support for str accessor methods when using ArrowDtype with a pyarrow.string type
• Added support for dt accessor methods when using ArrowDtype with a pyarrow.timestamp type
• read_sas() now supports using encoding='infer' to correctly read and use the encoding specified by the sas file.
• Series.add_suffix(), DataFrame.add_suffix(), Series.add_prefix() and DataFrame.add_prefix() support an axis argument. gh-624 : Added index parameter to to_dict and added axis argument to Series.add_suffix(), DataFrame.add_suffix(), Series.add_prefix() and DataFrame.add_prefix() #638
• Added index parameter to DataFrame.to_dict() gh-624 : Added index parameter to to_dict and added axis argument to Series.add_suffix(), DataFrame.add_suffix(), Series.add_prefix() and DataFrame.add_prefix() #638
• Added cumsum, cumprod, cummin and cummax to the ExtensionArray interface via _accumulate feat(array): #624 accumulate #1400
• CategoricalConversionWarning, InvalidComparison, InvalidVersion, LossySetitemError, and NoBufferPresent are now exposed in pandas.errors feat(error): #624 new warnings and errors #1402
• date_range() now supports a unit keyword (“s”, “ms”, “us”, or “ns”) to specify the desired resolution of the output index GH - 624: date_range() now supports a unit keyword "s" , "ms" , "us" , or "ns" #734
• DataFrame.to_json() now supports a mode keyword with supported inputs ‘w’ and ‘a’. Defaulting to ‘w’, ‘a’ can be used when lines=True and orient=’records’ to append record oriented json lines to an existing json file. GH:624 - added mode keyword to DataFrame.to_json #684
• Added name parameter to IntervalIndex.from_breaks(), IntervalIndex.from_arrays() and IntervalIndex.from_tuples()
• Added Index.infer_objects() analogous to Series.infer_objects() GH1264 Version 2.0 cleanup #1265
• DataFrame.plot.hist() now recognizes xlabel and ylabel arguments
• Series.drop_duplicates() has gained ignore_index keyword to reset index Add ignore_index keyword arg in dropna and drop_duplicates (Part of GH624) #1030
• Series.dropna() and DataFrame.dropna() has gained ignore_index keyword to reset index Add ignore_index keyword arg in dropna and drop_duplicates (Part of GH624) #1030
• Added DatetimeIndex.as_unit() and [TimedeltaIndex.as_unit()] (https://pandas.pydata.org/docs/reference/api/pandas.TimedeltaIndex.as_unit.html#pandas.TimedeltaIndex.as_unit) to convert to different resolutions; supported resolutions are “s”, “ms”, “us”, and “ns” Add unit property and as_unit method to DatetimeIndex, TimedeltaIndex and Series.dt #865
• Added Series.dt.unit() and Series.dt.as_unit() to convert to different resolutions; supported resolutions are “s”, “ms”, “us”, and “ns” Add unit property and as_unit method to DatetimeIndex, TimedeltaIndex and Series.dt #865
• Added new argument dtype to read_sql() to be consistent with read_sql_query() GH - 624: Added dtype arg to read_sql #649
• read_csv() now accept date_format Adds 'date_format' parameter to 'read_csv' #650
• read_table(), read_fwf() and read_excel() now accept date_format GH:624- added date_format to read_table,read_fwf and read_excel #695
• ~~to_datetime() now accepts "ISO8601" as an argument to format, which will match any ISO8601 string (but possibly not identically-formatted)~
• to_datetime() now accepts "mixed" as an argument to format, which will infer the format for each element individually
• Added new argument engine to read_json() to support parsing JSON with pyarrow by specifying engine="pyarrow" Added new argument engine to read_json() to support parsing JSON with pyarrow by specifying engine="pyarrow" #1033
• Added support for decimal parameter when engine="pyarrow" in read_csv() align typing with pandas source #1219
• Index set operations Index.union(), Index.intersection(), Index.difference(), and Index.symmetric_difference() now support sort=True, which will always return a sorted result, unlike the default sort=None which does not sort in some cases GH1264 Version 2.0 cleanup #1265
• Construction with datetime64 or timedelta64 dtype with unsupported resolution (check allowable resolutions for pd.Series())
• Disallow astype conversion to non-supported datetime64/timedelta64 dtypes
• The pandas latex options below are no longer used and have been removed. The generic max rows and columns arguments remain but for this functionality should be replaced by the Styler equivalents. The alternative options giving similar functionality are indicated below:
  • display.latex.escape: replaced with styler.format.escape,
  • display.latex.longtable: replaced with styler.latex.environment,
  • display.latex.multicolumn, display.latex.multicolumn_format and display.latex.multirow: replaced with styler.sparse.rows, styler.sparse.columns, styler.latex.multirow_align and styler.latex.multicol_align,
  • display.latex.repr: replaced with styler.render.repr,
  • display.max_rows and display.max_columns: replace with styler.render.max_rows, styler.render.max_columns and styler.render.max_elements.
  • The freq, tz, nanosecond, and unit keywords in the Timestamp constructor are now keyword-only
• Default value of dtype in get_dummies() is changed to bool from uint8
• DatetimeIndex.astype(), TimedeltaIndex.astype(), PeriodIndex.astype() Series.astype(), DataFrame.astype() with datetime64, timedelta64 or PeriodDtype dtypes no longer allow converting to integer dtypes other than “int64”, do obj.astype('int64', copy=False).astype(dtype) instead
• The other argument in DataFrame.mask() and Series.mask() now defaults to no_default instead of np.nan consistent with [DataFrame.where()] (https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.where.html#pandas.DataFrame.where) and Series.where(). Version 2.0 Migration Timestamp/Mask #1065
• Series.unique() with dtype “timedelta64[ns]” or “datetime64[ns]” now returns TimedeltaArray or DatetimeArray instead of numpy.ndarray Series.unique() with dtype “timedelta64[ns]” or “datetime64[ns]” #1039
• to_datetime() and DatetimeIndex now allow sequences containing both datetime objects and numeric entries, matching Series behavior
• Added "None" to default na_values in read_csv() GH: 624 - added new is_any_real_numeric_dtype function #715
• Disallow computing cumprod for Timedelta object; previously this returned incorrect values
• The levels of the index of the Series returned from Series.sparse.from_coo now always have dtype int32. Previously they had dtype int64
• Added pandas.api.types.is_any_real_numeric_dtype() to check for real numeric dtypes GH: 624 - added new is_any_real_numeric_dtype function #715
• Deprecated argument infer_datetime_format in to_datetime() and read_csv(), as a strict version of it is now the default Migration to 2.0 - Deprecation in Resample #1063
• Deprecated pandas.io.sql.execute() Migration to 2.0 - Deprecation in Resample #1063
• Index.is_boolean() has been deprecated GH1049 Deprecate Index and Grouper methods for 2.0 migration #1050
• Index.is_integer() has been deprecated. GH1049 Deprecate Index and Grouper methods for 2.0 migration #1050
• Index.is_floating() has been deprecated. GH1049 Deprecate Index and Grouper methods for 2.0 migration #1050
• Index.holds_integer() has been deprecated. GH1049 Deprecate Index and Grouper methods for 2.0 migration #1050
• Index.is_numeric() has been deprecated. GH1049 Deprecate Index and Grouper methods for 2.0 migration #1050
• Index.is_categorical() has been deprecated. GH1049 Deprecate Index and Grouper methods for 2.0 migration #1050
• Index.is_object() has been deprecated. GH1049 Deprecate Index and Grouper methods for 2.0 migration #1050
• Index.is_interval() has been deprecated. GH1049 Deprecate Index and Grouper methods for 2.0 migration #1050
• Deprecated argument date_parser in read_csv(), read_table(), read_fwf(), and read_excel() in favour of date_format GH:624- added date_format to read_table,read_fwf and read_excel #695
• Deprecated unused arguments *args and **kwargs in Resampler Migration to 2.0 - Deprecation in Resample #1063
• Deprecated Grouper.groups() GH1049 Deprecate Index and Grouper methods for 2.0 migration #1050
• Deprecated Grouper.grouper()
• Deprecated Grouper.obj()
• Deprecated Grouper.indexer()
• Deprecated Grouper.ax()
• Deprecated keyword use_nullable_dtypes in [read_parquet()] (https://pandas.pydata.org/docs/reference/api/pandas.read_parquet.html#pandas.read_parquet) GH1049 Deprecate Index and Grouper methods for 2.0 migration #1050
• Deprecated Series.pad()
• Deprecated Series.backfill()
• Deprecated DataFrame.pad()
• Deprecated DataFrame.backfill()
• Deprecated close(). Use StataReader as a context manager instead Migration to 2.0 - Deprecation in Resample #1063
• Removed Int64Index, UInt64Index and Float64Index.
• Removed deprecated Timestamp.freq, Timestamp.freqstr and argument freq from the Timestamp constructor and [Timestamp.fromordinal()] Version 2.0 Migration Timestamp/Mask #1065
• (https://pandas.pydata.org/docs/reference/api/pandas.Timestamp.fromordinal.html#pandas.Timestamp.fromordinal)
• Removed deprecated CategoricalBlock, Block.is_categorical(), require datetime64 and timedelta64 values to be wrapped in DatetimeArray or TimedeltaArray before passing to Block.make_block_same_class(), require DatetimeTZBlock.values to have the correct ndim when passing to the BlockManager constructor, and removed the “fastpath” keyword from the SingleBlockManager constructor
• Removed deprecated global option use_inf_as_null in favor of use_inf_as_na
• Removed deprecated module pandas.core.index
• Removed deprecated alias pandas.core.tools.datetimes.to_time
• Removed deprecated alias pandas.io.json.json_normalize
• Removed deprecated Categorical.to_dense() (pandas 2.0 removals in core/arrays #932)
• Removed deprecated Categorical.take_nd() (pandas 2.0 removals in core/indexes #931) (pandas 2.0 removals in core/arrays #932)
• Removed deprecated Categorical.mode() (pandas 2.0 removals in core/arrays #932)
• Removed deprecated Categorical.is_dtype_equal() and CategoricalIndex.is_dtype_equal() (pandas 2.0 removals in core/arrays #932)
• Removed deprecated CategoricalIndex.take_nd() (pandas 2.0 removals in core/indexes #931)
• Removed deprecated Index.is_type_compatible() (pandas 2.0 removals in core/indexes #931)
• Removed deprecated Index.is_mixed() (pandas 2.0 removals in core/indexes #931)
• Removed deprecated pandas.api.types.is_categorical()
• Removed deprecated Index.asi8() (pandas 2.0 removals in core/indexes #931)
• Removed deprecated DataFrame._AXIS_NUMBERS(), DataFrame._AXIS_NAMES(), Series._AXIS_NUMBERS(), Series._AXIS_NAMES()
• Removed deprecated Index.to_native_types() (pandas 2.0 removals in core/indexes #931)
• Removed deprecated Series.iteritems(), DataFrame.iteritems()
• Removed deprecated DataFrame.lookup() (pandas 2.0 removals for NDFrame and subclasses #930)
• Removed deprecated Series.append(), DataFrame.append() remove append #261
• Removed deprecated Series.iteritems(), DataFrame.iteritems() and HDFStore.iteritems()
• Removed deprecated DatetimeIndex.union_many()
• Removed deprecated weekofyear and week attributes of DatetimeArray, DatetimeIndex and dt accessor (pandas 2.0 removals in core/arrays #932)
• Removed deprecated RangeIndex._start(), RangeIndex._stop(), RangeIndex._step()
• Removed deprecated DatetimeIndex.to_perioddelta() (pandas 2.0 removals in core/indexes #931)
• Removed deprecated Styler.hide_index() and Styler.hide_columns()
• Removed deprecated Styler.set_na_rep() and Styler.set_precision()
• Removed deprecated Styler.where()
• Removed deprecated Styler.render()
• Removed deprecated argument col_space in DataFrame.to_latex() (pandas 2.0 removals for NDFrame and subclasses #930)
• Removed deprecated argument null_color in Styler.highlight_null()
• Removed deprecated argument check_less_precise in testing.assert_frame_equal(), testing.assert_extension_array_equal(), testing.assert_series_equal(), testing.assert_index_equal() (pandas 2.0 removals in testing and clipboard #933)
• Removed deprecated null_counts argument in DataFrame.info() Added types to df.info() #875
• Removed deprecated Index.is_monotonic(), and Series.is_monotonic()
• Removed deprecated Index.is_all_dates() (pandas 2.0 removals in core/indexes #931)
• Enforced deprecation disallowing unit-less “datetime64” dtype in Series.astype() and DataFrame.astype()
• Enforced deprecation disallowing passing non boolean argument to sort in concat()
• Removed Date parser functions parse_date_time(), parse_date_fields(), parse_all_fields() and generic_parser()
• Removed argument index from the core.arrays.SparseArray constructor
• Remove argument squeeze from DataFrame.groupby() and Series.groupby()
• Removed deprecated apply, apply_index, call, onOffset, and isAnchored attributes from DateOffset
• Removed keep_tz argument in DatetimeIndex.to_series() reportIncompatibleMethodOverride #802
• Remove arguments names and dtype from Index.copy() and levels and codes from MultiIndex.copy()
• Remove argument inplace from MultiIndex.set_levels() and MultiIndex.set_codes()
• Removed arguments verbose and encoding from DataFrame.to_excel() and Series.to_excel()
• Removed argument line_terminator from DataFrame.to_csv() and Series.to_csv(),
• Removed argument inplace from DataFrame.set_axis() and Series.set_axis()
• Disallow passing positional arguments to MultiIndex.set_levels() and MultiIndex.set_codes()
• Disallow parsing to Timedelta strings with components with units “Y”, “y”, or “M”, as these do not represent unambiguous durations
• Removed MultiIndex.is_lexsorted() and MultiIndex.lexsort_depth()
• Removed argument how from PeriodIndex.astype() GH1099 Remove how arg from Periodindex.astype #1100
• Removed argument try_cast from DataFrame.mask(), DataFrame.where(), Series.mask() and Series.where() (pandas 2.0 removals for NDFrame and subclasses #930)
• Removed argument tz from Period.to_timestamp()
• Removed argument sort_columns in [DataFrame.plot()](https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.plot.html#pandas.DataFrame.plot) and Series.plot()
• Removed argument is_copy from DataFrame.take() and Series.take() (pandas 2.0 removals for NDFrame and subclasses #930)
• Removed argument kind from Index.get_slice_bound(), Index.slice_indexer() and Index.slice_locs()
• Removed arguments prefix, squeeze, error_bad_lines and warn_bad_lines from read_csv()
• Removed arguments squeeze from [read_excel()](https://pandas.pydata.org/docs/reference/api/pandas.read_excel.html#pandas.read_excel)
• Removed argument datetime_is_numeric from DataFrame.describe() and Series.describe() (pandas 2.0 removals for NDFrame and subclasses #930)
• Disallow passing list key to Series.xs() and DataFrame.xs()
• Disallow subclass-specific keywords (e.g. “freq”, “tz”, “names”, “closed”) in the Index constructor
• Removed argument inplace from Categorical.remove_unused_categories() (pandas 2.0 removals in core/arrays #932)
• Remove keywords convert_float and mangle_dupe_cols from read_excel()
• Remove keyword mangle_dupe_cols from read_csv() and read_table()
• Removed errors keyword from DataFrame.where(), Series.where(), DataFrame.mask() and Series.mask()
• Disallow passing non-keyword arguments to [read_excel()] (https://pandas.pydata.org/docs/reference/api/pandas.read_excel.html#pandas.read_excel) except io and sheet_name
• Disallow passing non-keyword arguments to DataFrame.drop() and Series.drop() except labels refactor: comply to more ruff and pyright rules #1403 ba7aa5f
• Disallow passing non-keyword arguments to DataFrame.fillna() and Series.fillna() except value TYP: fix almost all keyword-only reported by stubtest #474
• Disallow passing non-keyword arguments to StringMethods.split() and StringMethods.rsplit() except for pat GH1074 Add type hint Series[list[str]] for Series.str.split with expand=False #1075
• Disallow passing non-keyword arguments to DataFrame.set_index() except keys
• Disallow passing non-keyword arguments to Resampler.interpolate() except method
• Disallow passing non-keyword arguments to DataFrame.reset_index() and Series.reset_index() except level
• Disallow passing non-keyword arguments to DataFrame.dropna() and Series.dropna()
• Disallow passing non-keyword arguments to ExtensionArray.argsort()
• Disallow passing non-keyword arguments to Categorical.sort_values()
• Disallow passing non-keyword arguments to Index.drop_duplicates() and Series.drop_duplicates()
• Disallow passing non-keyword arguments to DataFrame.drop_duplicates() except for subset
• Disallow passing non-keyword arguments to DataFrame.sort_index() and Series.sort_index()
• Disallow passing non-keyword arguments to DataFrame.interpolate() and Series.interpolate() except for method
• Disallow passing non-keyword arguments to DataFrame.any() and Series.any()
• Disallow passing non-keyword arguments to Index.set_names() except for names
• Disallow passing non-keyword arguments to Index.join() except for other
• Disallow passing non-keyword arguments to concat() except for objs
• Disallow passing non-keyword arguments to pivot() except for data
• Disallow passing non-keyword arguments to DataFrame.pivot()
• Disallow passing non-keyword arguments to read_html() except for io
• Disallow passing non-keyword arguments to read_json() except for path_or_buf
• Disallow passing non-keyword arguments to read_sas() except for filepath_or_buffer
• Disallow passing non-keyword arguments to read_stata() except for filepath_or_buffer
• Disallow passing non-keyword arguments to read_csv() except filepath_or_buffer
• Disallow passing non-keyword arguments to read_table() except filepath_or_buffer
• Disallow passing non-keyword arguments to read_fwf() except filepath_or_buffer
• Disallow passing non-keyword arguments to read_xml() except for path_or_buffer
• Disallow passing non-keyword arguments to Series.mask() and DataFrame.mask() except cond and other
• Disallow passing non-keyword arguments to DataFrame.to_stata() except for path
• Disallow passing non-keyword arguments to DataFrame.where() and Series.where() except for cond and other
• Disallow passing non-keyword arguments to Series.set_axis() and DataFrame.set_axis() except for labels
• Disallow passing non-keyword arguments to Series.rename_axis() and DataFrame.rename_axis() except for mapper
• Disallow passing non-keyword arguments to Series.clip() and DataFrame.clip()
• Disallow passing non-keyword arguments to Series.bfill(), Series.ffill(), DataFrame.bfill() and DataFrame.ffill()
• Disallow passing non-keyword arguments to DataFrame.replace(), Series.replace() except for to_replace and value
• Disallow passing non-keyword arguments to DataFrame.sort_values() except for by
• Disallow passing non-keyword arguments to Series.sort_values()
• Disallow passing non-keyword arguments to DataFrame.reindex() except for labels
• Disallowed constructing Categorical with scalar data
• Removed Rolling.validate(), Expanding.validate(), and ExponentialMovingWindow.validate()
• Removed Rolling.win_type returning "freq"
• Removed Rolling.is_datetimelike
• Removed the level keyword in DataFrame and Series aggregations
• Removed deprecated Timedelta.delta(), Timedelta.is_populated(), and Timedelta.freq
• Removed deprecated NaT.freq
• Removed deprecated Categorical.replace()
• Removed the numeric_only keyword from Categorical.min() and Categorical.max()
• Removed is_extension_type() in favor of is_extension_array_dtype()
• Removed .ExponentialMovingWindow.vol
• Removed Index.get_value() and Index.set_value() (pandas 2.0 removals in core/indexes #931)
• Removed Series.slice_shift() and DataFrame.slice_shift() (pandas 2.0 removals for NDFrame and subclasses #930)
• Remove DataFrameGroupBy.pad() and DataFrameGroupBy.backfill()
• Remove numpy argument from read_json()
• Disallow passing abbreviations for orient in DataFrame.to_dict() gh-624 : Added index parameter to to_dict and added axis argument to Series.add_suffix(), DataFrame.add_suffix(), Series.add_prefix() and DataFrame.add_prefix() #638
• Removed get_offset
• Removed the warn keyword in [infer_freq()](https://pandas.pydata.org/docs/reference/api/pandas.infer_freq.html#pandas.infer_freq)
• Removed the include_start and include_end arguments in DataFrame.between_time()
• Removed the closed argument in date_range() and bdate_range()
• Removed the center keyword in DataFrame.expanding()
• Removed the truediv keyword from eval()
• Removed the method and tolerance arguments in Index.get_loc()
• Removed the pandas.datetime submodule
• Removed the pandas.np submodule
• Removed pandas.util.testing
• Removed Series.str.iter()
• Removed pandas.SparseArray
• Removed pandas.SparseSeries and pandas.SparseDataFrame
• Enforced disallowing passing an integer fill_value to DataFrame.shift() and Series.shift`() with datetime64, timedelta64, or period dtypes
• Enforced disallowing a string column label into times in DataFrame.ewm()
• Enforced disallowing passing True and False into inclusive in Series.between() in favor of "both" and "neither" respectively
• Enforced disallowing the use of **kwargs in ExcelWriter
• Enforced disallowing a tuple of column labels into DataFrameGroupBy.getitem()
• Enforced disallowing set or dict indexers in getitem and setitem methods
• Enforced disallowing dict or set objects in suffixes in merge()
• Removed setting Categorical._codes directly
• Removed setting Categorical.categories directly
• Removed argument inplace from Categorical.add_categories(), Categorical.remove_categories(), Categorical.set_categories(), Categorical.rename_categories(), Categorical.reorder_categories(), (pandas 2.0 removals in core/arrays #932)
• Removed argument inplace from Categorical.set_ordered(), Categorical.as_ordered(), Categorical.as_unordered()
• Renamed fname to path in DataFrame.to_parquet(), DataFrame.to_stata() and DataFrame.to_feather()
• Removed the display.column_space option
• Removed the deprecated method mad from pandas classes
• Removed the deprecated method tshift from pandas classes (pandas 2.0 removals for NDFrame and subclasses #930)
• Changed behavior of Index.ravel() to return a view on the original Index instead of a np.ndarray
• Removed the deprecated base and loffset arguments from pandas.DataFrame.resample(), pandas.Series.resample() and pandas.Grouper
• Change the default argument of regex for Series.str.replace() from True to False
• Changed behavior of comparison of a Timestamp with a datetime.date object; these now compare as un-equal and raise on inequality comparisons
• Changed behavior of comparison of NaT with a datetime.date object; these now raise on inequality comparisons
• Removed na_sentinel argument from factorize(), Index.factorize(), and [ExtensionArray.factorize()] (https://pandas.pydata.org/docs/reference/api/pandas.api.extensions.ExtensionArray.factorize.html#pandas.api.extensions.ExtensionArray.factorize) Removed na_sentinel argument from factorize(), Index.factorize(), and ExtensionArray.factorize() #1037
• Enforced deprecation disallowing passing numeric_only=True to Series reductions (rank, any, all, …) with non-numeric dtype
• Changed default of numeric_only to False in all DataFrame methods with that argument
• Changed default of numeric_only to False in [Series.rank()](https://pandas.pydata.org/docs/reference/api/pandas.Series.rank.html#pandas.Series.rank)
• ~~Changed default of numeric_only in various DataFrameGroupBy methods; all methods now default to numeric_only=False ~~
• ~~Changed default of numeric_only to False in Resampler methods ~~
• Removed deprecated methods ExcelWriter.write_cells(), ExcelWriter.save(), ExcelWriter.cur_sheet(), ExcelWriter.handles(), ExcelWriter.path()
• The ExcelWriter attribute book can no longer be set
• Removed unused *args and **kwargs in Rolling, Expanding, and ExponentialMovingWindow ops
• Removed the deprecated argument line_terminator from DataFrame.to_csv()
• Removed the deprecated argument label from lreshape()
• Arguments after expr in DataFrame.eval() and DataFrame.query() are keyword-only
• Removed Index._get_attributes_dict()
• Removed Series.array_wrap()