fix issue with timestamp comparing to Index and Series, with Timestamp coming first

* Add timedelta as possible freq parameter type to date_range() and bdate_range()

* Include p...

* stubtest inconsistencies

* remove deprecated

* fix some keyword-only arguments

* comm...

Allow sqlalchemy TextClause for sql select statements

Co-authored-by: Kevin Sheppard <kevin.s...

* ENH: IMprove Roling, Expanding and EWM

* ENH: Add generic

* TST: Add tests for rolling
...

* Fix IndexSlice

* Move IndexSliceTuple over to indexing.pyi

* fix for python 3.8

* add...

* Fix replace, fillna allowing pd.NA. Allow list of arguments for .loc

* add check and asser...

# Conflicts:
# pandas-stubs/core/frame.pyi
# pandas-stubs/core/generic.pyi
# pandas-stubs/cor...

* WIP: TimedeltaIndex accessors

* remove dtl to make mypy happy

* BUG: Generalize options

Generalize using specific classes for each level

* TST: Correct ...

* ENH: Add Selectable

closes #304

* TST: Use mocking to get around sqlalchemy typing

* Added more possible types to groupby on

* Added more tests

Co-authored-by: Amotz <amotz@...

* MAINT: Fix nightly

* MAINT: Add skips for problematic tests on nightly

Catch warnings af...

MAINT: Fix nightly

* ENH: Improve styler typing

* TYP: Add typing for StylerRenderer

* ENH: Improve Styler

...

* fix loc on mi with slice

* remove tuple and slice as first part of tuple for loc.getitem

* fix various index arithmetic

* add one test

* allow timestamp plus timedeltaseries

* ENH: Improve Resampler typing

* TST: Add tests for resampler

* TYP: Fix small typing iss...

The double-import of `pandas.testing` in `__init__.pyi` breaks detection of this module in pyrig...

* Add sqlalchemy

* Add testcases using sqlalchemy engine and connection

* Accept sqlalchem...

* ENH: Improve plotting types

Add types for many inputs
Clean out non-public functions

* ...

* [fix] No overload variant of "isna" matches argument type "NAType" [call-overload]

Update `...

* [fix]: pandas.Index.to_numpy() method's arguments not properly typed

After cloning a fresh ...

* ENH: Finish typing utility functions

* TST: Test remaining errors

* TYP: Import from sou...

* ENH: Improve api.types

Clean and improve the typing for api.types
Add tests

* TST: Add ...

* CLN: FrameOrSeries(Union)

* let nightly pass for now; clean _typing a tiny bit

* revert ...

Imrove types for options
Add tests

* ENH: Synchronize pickle with upstream

Align APIs
Add tests

* BUG: Correct ReadPickleBuf...

* remove append

* __getattr__ -> Series

* tests

* black

* and isort

* maybe fix w...

* Remove more deprecations

* merge cleanup

* ENH: Improve read_{csv/fwf/table}

* MAINT: Move parsers->readers

* ENH: Move complex typ...

* WIP: fix xs issue. Bump to 1.4.4

* Fix xs arguments and dtype return type

* Hide pandas implementation during type checking

* 3.8

* use py.typed

* enable reportI...

* ENH: IMprove typing for read_excel

* ENH: IMprove typing for Excel tools

* TST: Add test...

* ENH: Improve to_string typing

* BUG/TST: Corect types and add test

* MAINT: Remove dep o...

* optional pytest run against nightly

* full version for pre-commit

* wo shell

* Revert...

* CLN: Clean clipboard

* CLN: Remove deprecated functions and module

* CLN: Remove formats...

* ENH: Improve sql io api

* TYP: Finish typing sql

* TYP: Improve type accuracy

Add sql...

* ENH: Improve to_dict typing

* ENH: Improve to_records typing

* ENH: Improve xarray and d...

* Added __neg__ to Series, DataFrame and Index. Fixed bug in Index.difference

* Moved to NDFr...

* ENH: Correct typing for read/to_html

* TYP: Remove redundant and improve types

Co-author...

* pin poetry to 1.1.5

* change poetry version in test.yaml

* try poetry 1.1.5

* use 1.1...

* Cleaned uptyping on __new__ for Series and DataFrame

* Added tests

* Added checkoing to ...

* Typ columns setter as Hashable

* Add tests

* Change type and add tests

* Adjust

* fix various issues with offsets

* Add holidays.pyi

* remove Tick as it is subclass of Ba...

* Add AnyArrayLike for merge on arguments

* Add checks

* ENH: Clean JSON Api

Cleand and synchronize JSON api

* TST: Add tests for json

Add tes...

Synchronize and clean API

Co-authored-by: Kevin Sheppard <[email protected]>

* ENH: Update SAS API

Update SAS to contain required classes and functions
Add test

* CLN...

* ENH: Improve parquet io

Synchronize with upstream
Eliminate redundant code

* BUG: Remov...

* ENH: Synchronize HDF typing with main and api

Limit to API
Improve types

* TST: Add tes...

* ENH: Synchronie ORC with upstream

Synchronize the orc read and write functions with upstrea...

* ENH: Synchronize XML

Synchronize to and read XML to upstream

* TST: Add tests for read_x...

* ENH: Synchronize io/stata with pandas master

Sychronize and remvoe classes not part of the ...

* ENH: Improve clipboard

Synchronize clipboard with upstream pandas

* TST: Add a test for ...

* CI: check for some unused ignore comments

* pyright ignore

* close file handles

* add...

* WIP: DatetimeIndex accessors using generics

* fix Series.split with expand=True

* align ...

* TYP: avoid unions of literals and generic types

* use aliases

* replace

* Deprecated the level keyword for several Series/DataFrame methods

* Replaced level with gro...

* Added None option as axis for dataframe.all/any and fixed return type

* Deprecated the leve...

* ENH: Synchronize gpq with upstream

Align with actual API

* CLN: Refactor to_gbp

Move ...

* ENH: Add stub for ensure_clean

Add stub to allow usage in io testing

* MAINT: Use ensure...

* Allow strings to crosstab's normalize argument

* Add 0 and 1 literals

* Add test

* Im...

* fix Series.split with expand=True

* align asterisk in split params

* read_excel accepts PathLike, buffers

pandas.read_excel is documented to accept

> str, by...

* WIP: allow list of int in loc

* allow list of int and None in DataFrame.loc

* remove dup...

* allow dict_items in DataFrame constructor. Clean up _ListLike

* Use Iterable instead of It...

* Added missing groupby methods and made SeriesGroupBy generic

* Fixed some return types, mad...

* more cleanups

* second half of changes

* remove symbols that are clearly private

* re...

* Made all agg/aggregate/transform functions use same basic typing aliases AggFuncType

* Adde...

* BUG: groupby not accepting list[str] for by argument

* Test return values

* Test return ...

* some cleanups from stubtest

* remove io/common

* stubtest: option to not set ignore-missing-stub

* remove print