BrandonFors/pandas-github-issues huggingface dataset:
DEPR: to_native_types, set_value, iteritems, union_many, to_perioddelta
State: closed

- [ ] closes #xxxx (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:
name: Deprecate
description: Functionality to remove in pandas

Comments:
IIUC the docbuild problem is 

```
/home/runner/work/pandas/pandas/doc/source/whatsnew/v2.0.0.rst:182: WARNING: Inline interpreted text or phrase reference start-string without end-string.
```

but line 182 in that file a) is not touched by this PR and b) looks fine to me.
Thanks @jbrockmendel
STYLE: fix pylint consider-using-dict-items warnings
State: closed

Related to https://github.com/pandas-dev/pandas/issues/48855
- [x] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [x] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [x] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.

`consider-using-dict-items` is also removed from the ignored warnings in `pyproject.toml`.


Labels:
name: Code Style
description: Code style, linting, code_checks

Comments:
Sweet! Thanks @Moisan
DEPR: Series(dt64_naive, dtype=dt64tz)
State: closed

- [ ] closes #xxxx (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:
name: Deprecate
description: Functionality to remove in pandas

Comments:
Thanks @jbrockmendel
DEPR: categorical.mode
State: closed

- [ ] closes #xxxx (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:
name: Deprecate
description: Functionality to remove in pandas

Comments:
thx @jbrockmendel (could you update the deprecations issue?)
Should there be a whatsnew entry here?
the whatsnew accidentally made it into #49220
STYLE: fix pylint no-else-break warnings
State: closed

Related to https://github.com/pandas-dev/pandas/issues/48855
- [x] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [x] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [x] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.

The `no-else-break` is also removed from the ignored warnings in `pyproject.toml`.


Labels:
name: Code Style
description: Code style, linting, code_checks

Comments:
Thanks @Moisan! Great to have all these pylint checks
DEPR: enforce DatetimeArray.astype deprecations
State: closed

- [ ] closes #xxxx (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:
name: Deprecate
description: Functionality to remove in pandas

Comments:
Thanks @jbrockmendel
DEPR: PeriodIndex.astype how keyword
State: closed

- [ ] closes #xxxx (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:
name: Deprecate
description: Functionality to remove in pandas

Comments:
Thanks @jbrockmendel
BUG: pandas.to_datetime() does not respect exact format string with ISO8601
State: closed

- [ ] closes #12649 (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.

I'm working on cleaning up / deduplicating the code

Labels:
name: Datetime
description: Datetime data dtype

Comments:
closing, will take this forward in https://github.com/pandas-dev/pandas/pull/49333, will add some commits there
Added a New Page in Cheatsheet with some extra functions.
State: closed

-Added a new page that includes:
- IO Tools
- Visualization
- Data transform functions
- Apply functions.




Labels:
name: Docs

Comments:
> Same feedback as in #49180, please open an issue to discuss what to add first, some of what you add doesn't seem to make sense.

We do have https://github.com/pandas-dev/pandas/issues/40680 that has a bunch of ideas.

But the PR also has to update the correct files!
Thanks for the pull request, but it appears to have gone stale. If interested in continuing, please merge in the main branch, address any review comments and/or failing tests, and we can reopen.
ADM/WEB: Update CoC committee members
State: closed

Updating members of the CoC committee.

CC: @regmibijay @WuraolaOyewusi @chakchurina

The list will appear in our [Team](https://pandas.pydata.org/about/team.html) page. We can also add to the config file the github usernames, and instead of just listing the names, we can list the names with links like the inactive maintainers list, or we can also have the github avatars like the active maintainers list. The reason I implemented it with the names is that I didn't know the github usersnames of the previous committee members. But I don't have a preference for any format. The list of members also appears in our [CoC](https://pandas.pydata.org/community/coc.html) page, and the same applies.

@TomAugspurger @jorisvandenbossche can you make the decision on who will be in the committee, so we can move forward with this please?


Labels:
name: Admin
description: Administrative tasks related to the pandas project
name: Web
description: pandas website

Comments:
@jorisvandenbossche do you have a preference on which of us does this. It's all yours if you want it.
I spoke with Joris and I'll be the one staying on the committee.
> I spoke with Joris and I'll be the one staying on the committee.

Excellent, updated the PR.
DEPR: Categorical, Index
State: closed

- [ ] closes #xxxx (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:
name: Deprecate
description: Functionality to remove in pandas

Comments:
Thanks @jbrockmendel
Fix code triggering superfluous-parens pylint messages
State: closed

- [ ] Contributes to #48855
- [X] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).

There were several locations where superfluous parentheses were being used to clarify the operator precedence in potentially ambiguous situations. Parentheses were removed and the code was refactored to add clarity where relevant. 

This code structure was a little confusing:
```
        assert not (left == right)
        assert left != right
```
I decided to remove the first line altogether, since it seems unnecessary. If it does serve a purpose, I can add it back. 

A duplicate `"too-many-locals"` was also removed from 'pyproject.toml'.

Labels:
name: Code Style
description: Code style, linting, code_checks

Comments:
Thanks @Leviob
STYLE: fix some consider-using-enumerate pylint warnings
State: closed

Related to https://github.com/pandas-dev/pandas/issues/48855
- [x] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [x] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [x] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.

This covers some `consider-using-enumerate` pylint warnings but not all them. The ones left are often using the index of the for-loop without accessing element of the list. Is that something we want to put an "ignore" tag on?


Labels:
name: Code Style
description: Code style, linting, code_checks

Comments:
> The ones left are often using the index of the for-loop without accessing element of the list. Is that something we want to put an "ignore" tag on?

These should be refactored if possible
STYLE fix: pylint "consider-using-in" warning
State: closed

- [x] Refers to one of the issues in https://github.com/pandas-dev/pandas/issues/48855

- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html)

I have enabled  "consider-using-in" in pylint and fixed the parts in the code corresponding to it. Let me know if I should change anything. 

Labels:
name: Code Style
description: Code style, linting, code_checks

Comments:
Thanks! Now all the pre-commit checks passed locally.
DEPR: remove Index.get_value
State: closed

- [ ] closes #xxxx (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:
name: Deprecate
description: Functionality to remove in pandas

Comments:
Thanks @jbrockmendel
PERF: Avoid call to list in isin
State: closed

- [ ] closes #xxxx (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.

Noticed this after #49162 was merged. Likely makes very little difference unless values is huge.

Labels:
name: Performance
description: Memory or execution speed performance
name: Algos
description: Non-arithmetic algos: value_counts, factorize, sorting, isin, clip, shift, diff

Comments:
thx @rhshadrach
ENH: Add sheet name to error message when reading Excel
State: closed

- [X] Closes #48706
- [X] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [x] ~Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.~
- [x] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.

---

**Description of changes**

When reading Excel files with `BaseExcelReader`, is possible that `TextParser` raises an `Exception` on different situations. As the reader works on a sheet basis, including the name of the sheet that caused the exception can be useful for debugging.

The implemented solution captures any `Exception` that gets raised while parsing and reading a sheet from an Excel file, then adds the name of the sheet to the exception message and "re-raises" the exception.


Labels:
name: Error Reporting
description: Incorrect or improved errors from pandas
name: IO Excel
description: read_excel, to_excel

Comments:
thx @aaossa
BUG: pandas.to_datetime() does not respect exact format string with ISO8601
State: closed

- [ ] closes #12649 (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.



Labels:
name: Datetime
description: Datetime data dtype

Comments:
closing as there's a simpler solution
BUG: CSV C engine raises an error on single line CSV with no header w…
State: closed

…hen passing extra names (#47566)

* Expect the provided number of columns when the names property is set

* Add tests to demonstrate handling of files with a single row with fewer columns.

- [x] closes #47566 (Replace xxxx with the GitHub issue number)
- [x] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [x] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [x] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:
name: IO CSV
description: read_csv, to_csv

Comments:
thx @joelsonoda 


As a side note: At some point this needs fixing in the actual parsing code.
Help Pint-Pandas pass tests when HAS_UNCERTAINTIES is enabled
State: closed

The Pint-Pandas testsuite relies on the Pandas test suite.  In the process of enabling support for uncertainties in Pint-Pandas, I discovered places where the base Pandas test suite needs to follow along.  I will extract the interesting test cases that triggered the need for these patches.

Signed-off-by: MichaelTiemann <72577720+MichaelTiemannOSC@users.noreply.github.com>

- [ ] closes #xxxx (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:

Comments:
thanks for your pr - closing as per the above

if there's a bug in pandas, please open an issue with a reproducible example and it can be addressed
Updated Cheatsheet with some extra functions added
State: closed

-Added a new page
- Added new functions related to IO tools, Data transform and Visualization.
- -Also applied some new functions like df.isin, df.sample, etc.

[Pandas_CheatSheet (1).pdf](https://github.com/pandas-dev/pandas/files/9836279/Pandas_CheatSheet.1.pdf)




Labels:
name: Docs

Comments:
 @phofl I have added a new page with functions like IO tools, Data transform, and visualization.
PERF: pd.concat EA-backed indexes and sort=True
State: closed

- [x] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [x] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [x] Added an entry in the latest `doc/source/whatsnew/v2.0.0.rst` file if fixing a bug or adding a new feature.

`algos.safe_sort` is currently converting EA-backed indexes to ndarrays which can cause a perf hit. It can be significant if the index contains pd.NA as `np.argsort` will raise which gets caught in the try-catch. This PR avoids the numpy conversion for EA-backed indexes. 

Note: One test which relied on the numpy conversion was updated.

```
import numpy as np
import pandas as pd
from pandas.core.indexes.api import safe_sort_index

vals = [pd.NA] + list(np.arange(100_000))
idx = pd.Index(vals, dtype="Int64")

%timeit safe_sort_index(idx)

# 81.6 ms ± 5.29 ms per loop (mean ± std. dev. of 7 runs, 10 loops each)   <- main
# 2.73 ms ± 24.4 µs per loop (mean ± std. dev. of 7 runs, 100 loops each)  <- PR
```

I updated an existing ASV that was just added yesterday to cover this case as well:

```
       before           after         ratio
     [8b503a8c]       [2e2a02fa]
                      <safe-sort-index>
-        27.1±1ms       22.2±0.4ms     0.82  join_merge.ConcatIndexDtype.time_concat_series('string[pyarrow]', 'non_monotonic', 1, True)
-      15.9±0.2ms       12.3±0.1ms     0.78  join_merge.ConcatIndexDtype.time_concat_series('string[python]', 'has_na', 1, True)
-      31.4±0.7ms       24.1±0.7ms     0.77  join_merge.ConcatIndexDtype.time_concat_series('string[pyarrow]', 'has_na', 1, True)
-      22.8±0.2ms       16.4±0.3ms     0.72  join_merge.ConcatIndexDtype.time_concat_series('Int64', 'has_na', 1, True)
-      13.8±0.4ms       9.26±0.1ms     0.67  join_merge.ConcatIndexDtype.time_concat_series('Int64', 'non_monotonic', 1, True)
```

Labels:
name: Performance
description: Memory or execution speed performance
name: Reshaping
description: Concat, Merge/Join, Stack/Unstack, Explode
name: ExtensionArray
description: Extending pandas with custom dtypes or arrays.
name: Index
description: Related to the Index class or subclasses

Comments:
Just a merge conflict otherwise LGTM
API: stop special-casing dt64/td64 in .unique
State: closed

- [ ] closes #xxxx (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:
name: Datetime
description: Datetime data dtype
name: Timedelta
description: Timedelta data type

Comments:
Thanks @jbrockmendel
TST: ArrowExtensionArray with string and binary types
State: closed

- [x] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).


Labels:
name: Testing
description: pandas testing functions or related to the test suite
name: Strings
description: String extension data type and string data
name: Arrow
description: pyarrow functionality

Comments:
thx @mroeschke
API: stop silent conversion of object-Index to DatetimeIndex
State: closed

- [x] closes #39307 (Replace xxxx with the GitHub issue number)
- [x] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [x] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


Labels:
name: Datetime
description: Datetime data dtype
name: Index
description: Related to the Index class or subclasses
name: Constructors
description: Series/DataFrame/Index/pd.array Constructors

Comments:
Thanks @jbrockmendel