* Move CSS expansion lookup to dictionary

* Implement simple CSSToExcelConverter cache

* Eliminate list -> str -> list in CSSResolver

* Allow for resolution of duplicate properties

* Add performance benchmark for styled Excel

* CLN: Clean up PEP8 issues

* DOC: Update PR documentation

* CLN: Clean up PEP8 issues

* Fixes from pre-commit [automated commit]

* Make Excel CSS case-insensitive

* Test for ordering and caching

* Pre-commit fixes

* Remove built-in filter

* Increase maxsize of Excel cache

Co-authored-by: Thomas Hunter <Thomas.Hunter@ibm.com>

* BUG: PeriodArray.__sub__(Period) overflows

* GH refs

…yfirst (#47528)

* try improving

* WARN: clarify warning message from to_datetime when dayfirst cant be respected

* add test to count number of warnings emitted

* fix whatsnew note

* fixup test to use set

* update tests

* inconsistently-parsed -> inconsistently parsed

* remove date_string from .format call

* fixup other tests

* ENH: TimedeltaArray add/sub with NaT preserve reso

* mypy fixup

* use datetime_data

* TYP: misc

* Update pandas/core/generic.py

Co-authored-by: Matthew Roeschke <emailformattr@gmail.com>

* None errors

Co-authored-by: Matthew Roeschke <emailformattr@gmail.com>

* TYP: more return annotations for io/*

* import future

* added link to advanced indexing guide in .loc docstring

* changed refernce style for .loc docstring

…7351)

* Bug: GroupBy raising error with None in first level of MultiIndex

* Add test

* Change whatsnew

…th lxml parser (#47504)

BUG: read_xml iterparse doesn't handle multiple toplevel elements with lxml parser

* TYP: Return annotations for io/{formats,json}

* flake8

* explicitly check whether width is None

* ENH: TDA.total_seconds support non-nano

* fix doctest

* mypy fixup

* Cache Conda env

* python-version -> extra-specs

* python-version -> extra-specs

* Remove old broken conda caching

* Add cache-downloads: true

* Undo debug change

* TYP: Missing return annotations in util/tseries/plotting

* the more tricky parts

* typ: _item_cache and _ixs

* fixup docstring

* linting

Fix typo

datavlaues => datavalues

…ngine (#47434)

* Fix vertical align failure on xlsxwriter

* CLN: linter

* Add what's new entry

* Add typing to test

* CLN: isort

* Update _xlsxwriter.py

* Remove unused xfail check

* Remove unnecessary imports

…ised_with_correct_stacklevel doesn't fail (#47387)

* fix stacklevel of read_csv warning

* :doc: add whatsnewnote

* move whatsnew entry to v1.4.4

#47491)

* ENH: Move PyperclipException and PyperclipWindowsException to error/__init__.py per GH27656

* ENH: add docstring to fixture

* ENH: apply feedback

* TYP: ndim is consistently a property

* unused import

* fix test

* nicer fix

* Fix reading SAS7BDAT files with zero rows (#47116)

* Fix reading SAS7BDAT files with zero rows

* Add missing file

* Update test_sas7bdat.py

* Review feedback

* Add back untested .rstrip

* Fix lint

* Add tests

* Fix rebase

* DEPR: na_sentinel in factorize

* WIP

* DEPR: na_sentinel in factorize

* Fixups

* Fixups

* black

* fixup

* docs

* newline

* Warn on class construction, rework pd.factorize warnings

* FutureWarning -> DeprecationWarning

* Remove old comment

* backticks in warnings, revert datetimelike, avoid catch_warnings

* fixup for warnings

* mypy fixups

* Move resolve_na_sentinel

* Remove underscores

Co-authored-by: Jeff Reback <jeff@reback.net>

* TYP: read_sas

* make __next__ compatibel with empty datafram

* df -> da

* whatsnew

* BUG: DataFrame.setitem raising when rhs is ea dtype Series

* Add gh ref

…7493)

* BUG: read_csv ignoring non existing header rows for python engine

* Rename variable

* DOC: Minor fixes in whatsnew 1.5.0

* revert

…7468)

…ovided (#47451)

* Fixed error message

* Update v1.4.3.rst

* Update v1.4.3.rst

* Added test case

* Added test

* Fix rst file

* Fix black issues

* Fixed error msg and corresponding test

* improved changelog

* Also fix python docstring for :func:to_dict

* Fix failing test