BrandonFors/pandas-github-issues huggingface dataset:
BLD: Pin numpy to < 2
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: Build
description: Library building on various platforms
name: CI
description: Continuous Integration
name: Compat
description: pandas objects compatability with Numpy or Python functions

Comments:
Thanks @lithomas1 
When NumPy 2.0 does come out, I think doing `pip install pandas~=x` where `x` is say 1.3-2.0 will result in invalid installations. Do we want to release patch versions to handle this? 
That would probably be a good idea, but I'll let @lithomas1 comment if he has bandwidth to tackle that
> When NumPy 2.0 does come out, I think doing `pip install pandas~=x` where `x` is say 1.3-2.0 will result in invalid installations. Do we want to release patch versions to handle this?

I don't think this is such a good idea. Rebuilding those older versions is likely going to be a PITA, and the gain isn't likely to be worth it.

As you might know, this is only going to be an issue for pip (conda has some special mechanism to retroactively apply the pins), so I'm happy telling people to either switch to conda, or follow CI best practices in freezing your package versions.
> so I'm happy telling people to either switch to conda

From [JetBrains 2021 survey](https://lp.jetbrains.com/python-developers-survey-2021/?_ga=2.29557308.244764463.1697284691-730495734.1673185276&_gl=1*mqp81y*_ga*NzMwNDk1NzM0LjE2NzMxODUyNzY.*_ga_9J976DJZ68*MTY5NzI4NDY5MC42LjEuMTY5NzI4NDc0NS41LjAuMA), only 21% report using conda. I do not believe it is our role to tell people how they should manage their dependencies.

> or follow CI best practices in freezing your package versions

I don't think there is any data here, but I'd guess from my experience we can't rely on this.

Once NumPy 2.0 comes out, users can always specify `numpy < 2.0` themselves with pip. It might bit a bit of an issue at first, but once the first set of error messages is answered on Stack Overflow, it should be easy to solve :laughing:. So since it's any harder than just putting up a small PR to add the pin, I'm good with not doing so.
Yeah, I'm totally happy to pin an issue about this.
I opened #55519.

I'll also post something via the pandas Twitter/Mastodon, if I have time, later today.
BUG: categorical dtype equality for level in different type
State: closed

- [x] closes #xxxx (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: Categorical
description: Categorical Data Type

Comments:
Thanks @gupta-paras
DEPR:  ‘AS’, ‘BA’ and ‘BAS’ in favour of ‘YS’, ‘BY’ and ‘BYS’
State: closed

xref #55252
- deprecated strings ‘AS’, ‘BA’ and ‘BAS’ in favour of ‘YS’, ‘BY’ and ‘BYS’.
-  deprecated annual frequencies with various fiscal business year ends: “BA-DEC", “BA-JAN", etc. in favour of “BY-DEC", “BY-JAN", etc.
- deprecated annual frequencies with various fiscal year begin: “AS-DEC", “AS-JAN", etc. in favour of “YS-DEC", “YS-JAN", etc.


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

Comments:
> Nice!
> 
> I think this is just missing a 2.2.0 whatsnew note?
> 
> OK to add it in the next PR though, happy to get this in before conflicts creep in 😄

yes, it would be great if we can get it in. I will add the note to 2.2.0 whatsnew in my next PR.
ENH: EA._get_repr_footer
State: closed

- [x] closes #24278 (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: Output-Formatting
description: __repr__ of pandas objects, to_string
name: ExtensionArray
description: Extending pandas with custom dtypes or arrays.

Comments:
Thanks @jbrockmendel
DOC: Add Hail to the out-of-core community list
State: closed

- [x] closes #55476
- [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~~ irrelevant
- [x] ~~All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).~~ irrelevant
- [x] ~~Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.~~ irrelevant
- [x] ~~Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.~~ irrelevant


Labels:
name: Docs

Comments:
Thanks @danking
CI: Add normal testing for Python 3.12
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: CI
description: Continuous Integration
name: Python 3.12

Comments:
Ref: https://github.com/pandas-dev/pandas/issues/53665

Thanks for doing this @lithomas1 - shout if you want any help.

```
DeprecationWarning: Bitwise inversion '~' on bool is deprecated. This returns the bitwise inversion of the underlying int object and is usually not what you expect from negating a bool. Use the 'not' operator for boolean negation or ~int(x) if you really want the bitwise inversion of the underlying int.
```
^ Saw this in a few places in the test failures.

Sorry for the lack of updates. Closing in favor of #56174.
REGR: sort index with sliced MultiIndex
State: closed

- [x] closes #55379
- [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.1.2.rst` file if fixing a bug or adding a new feature.

test and whatsnew added in #55473. Probably makes sense to merge and backport #55473 before merging this to ensure the test runs with this fix. 

Labels:
name: Regression
description: Functionality that used to work in a prior pandas version
name: MultiIndex

Comments:
@mroeschke - gentle ping. 

https://github.com/pandas-dev/pandas/pull/55482 backports the test associated with this fix.
Thanks @lukemanley
TST: sort index with sliced MultiIndex
State: closed

xref #55379 

will open a separate PR for the targeted fix on 2.1.x

This test can be back-ported though.


Labels:
name: Regression
description: Functionality that used to work in a prior pandas version
name: MultiIndex

Comments:
Thanks @lukemanley 
Owee, I'm MrMeeseeks, Look at me.

There seem to be a conflict, please backport manually. Here are approximate instructions:

1. Checkout backport branch and update it.

```
git checkout 2.1.x
git pull
```

2. Cherry pick the first parent branch of the this PR on top of the older branch:
```
git cherry-pick -x -m1 f7b49d8eac88f9db365def1cd2babe03b84dadf4
```

3. You will likely have some merge/cherry-pick conflict here, fix them and commit:

```
git commit -am 'Backport PR #55473: TST: sort index with sliced MultiIndex'
```

4. Push to a named branch:

```
git push YOURFORK 2.1.x:auto-backport-of-pr-55473-on-2.1.x
```

5. Create a PR against branch 2.1.x, I would have named this PR:

> "Backport PR #55473 on branch 2.1.x (TST: sort index with sliced MultiIndex)"

And apply the correct labels and milestones.

Congratulations — you did some good work! Hopefully your backport PR will be tested by the continuous integration and merged soon!

Remember to remove the `Still Needs Manual Backport` label once the PR gets merged.

If these instructions are inaccurate, feel free to [suggest an improvement](https://github.com/MeeseeksBox/MeeseeksDev).
EHN: read_spss stores the metadata in df.attrs
State: closed

- [x] closes #54264
- [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 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 Data
description: IO issues that don't fit into a more specific label

Comments:
Thanks @yuanx749
REF: de-duplicate IntervalArray formatting functions
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: Output-Formatting
description: __repr__ of pandas objects, to_string
name: Interval
description: Interval data type

Comments:
Thanks @jbrockmendel
REF: avoid circular imports in formats
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: Output-Formatting
description: __repr__ of pandas objects, to_string

Comments:
Thanks @jbrockmendel
DEPR: Series constructor fastpath keyword
State: closed

- [ ] closes #xxxx (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: Deprecate
description: Functionality to remove in pandas
name: Series
description: Series data structure

Comments:
Thanks @jbrockmendel 
This patch may have induced a performance regression. If it was a necessary behavior change, this may have been expected and everything is okay.

Please check the links below. If any ASVs are parameterized, the combinations of parameters that a regression has been detected appear as subbullets.

 - [indexing.NumericSeriesIndexing.time_iloc_slice](https://asv-runner.github.io/asv-collection/pandas/#indexing.NumericSeriesIndexing.time_iloc_slice)
   - [dtype=<class 'numpy.float64'>; index_structure='unique_monotonic_inc'](https://asv-runner.github.io/asv-collection/pandas/#indexing.NumericSeriesIndexing.time_iloc_slice?p-dtype=%3Cclass%20%27numpy.float64%27%3E&p-index_structure=%27unique_monotonic_inc%27)

Subsequent benchmarks may have skipped some commits. See the link below to see which commits are between the two benchmark runs where the regression was identified.

https://github.com/pandas-dev/pandas/compare/e22bfb3e1721d602086c0ca0b3af311cbe84cd9b...66a54a37d843cb641bfd4f694946e63a49124b3d

@jbrockmendel 

Is there an alternative for avoiding name validation now that fastpath is gone? I think this might be what's causing the regressions.
set `result._name = name` instead of passing it to the constructor
COMPAT: Update old numpy aliases
State: closed

- [x] closes #55454 (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



Labels:
name: Compat
description: pandas objects compatability with Numpy or Python functions

Comments:
@lithomas1 do you think we should backport this to 2.1.2? It appears that Numpy 2.0 is going to remove the `np.dtype("a")` alias https://github.com/numpy/numpy/pull/24854
~~We'd need the minimum version of Cython to be 3.0 to be fully compatible with numpy 2.0 and I'm not sure if that's going to happen before we release 2.2.
It might be better to just focus on making main(2.2) work with numpy 2.0 isntead, given we will release that in a month or two anyways.~~

EDIT: I changed my mind. Even if 2.1.x doesn't end up fully compatible with numpy 2.0, it'd still be good to have this in, to not have red CI there, and this is harmless enough.
thanks @mroeschke.
@meeseeksdev backport 2.1.x.
@meeseeksdev backport 2.1.x.
Backport PR #55077 on branch 2.1.x (Revert "BUG: Timestamp origin takes no effect in resample for 'MS' frequency (#53938)")
State: closed

Backport PR #55077: Revert "BUG: Timestamp origin takes no effect in resample for 'MS' frequency (#53938)"

Labels:
name: Regression
description: Functionality that used to work in a prior pandas version
name: Frequency
description: DateOffsets

Comments:
Mind fixing up the failures here @MarcoGorelli?
yup, thanks for the ping!
🤔 I'm confused, if I look at https://github.com/meeseeksmachine/pandas/tree/auto-backport-of-pr-55077-on-2.1.x I can see a commit I've added, but here I can't see it

might just be github playing up, will check again later
thanks @lithomas1 for fixing up
TST: fix tests for mixed int string index
State: closed

- [x] closes #54072
Added in conftest's `indices_dict` an entry:
```
"mixed-int-string": Index([0, "a", 1, "b", 2, "c"])
```
Adding "mixed-int-string" causes some tests to fail, fixed these tests.


Labels:
name: Testing
description: pandas testing functions or related to the test suite

Comments:
@jbrockmendel, I corrected my PR, could you please take a look at the update?
This pull request is stale because it has been open for thirty days with no activity. Please [update](https://pandas.pydata.org/pandas-docs/stable/development/contributing.html#updating-your-pull-request) and respond to this comment if you're still interested in working on this.
> This pull request is stale because it has been open for thirty days with no activity. Please [update](https://pandas.pydata.org/pandas-docs/stable/development/contributing.html#updating-your-pull-request) and respond to this comment if you're still interested in working on this.

Yes, this PR is still actual.
@jbrockmendel, I updated my PR, could you please take a look at the update?
I added an entry: `"mixed-int-string"` in conftest's `indices_dict` and corrected tests, ci - green. @MarcoGorelli could you please take a look at this PR?
gentle ping @jbrockmendel 
Looks like this PR has gone stale and has conflicts now. Closing to clear the queue but if interested in contributing please resolve the conflicts and we can reopen
DEPR: Previous implementation of DataFrame.stack
State: closed

- [x] closes #53515 (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: Reshaping
description: Concat, Merge/Join, Stack/Unstack, Explode
name: Deprecate
description: Functionality to remove in pandas

Comments:
Thanks @rhshadrach
REF: Use alt=None for no fallback in GroupBy._cython_agg_general
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.

Callers pass `alt=None` for fallback to not be used rather than hard coding method names.

Labels:
name: Refactor
description: Internal refactoring of code
name: Groupby

Comments:
Never mind - because of the SparseArray logic in _cython_agg_general this doesn't work.
> because of the SparseArray logic

it would be great to get rid of that!
REF: avoid accessing internals in io.formats.csv
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: Output-Formatting
description: __repr__ of pandas objects, to_string
name: Internals
description: Related to non-user accessible pandas implementation

Comments:
Thanks @jbrockmendel
Reorganize whatsnew 2.2.0 bug fixes into appropriate subsections
State: closed

- [x] closes #55436
- [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: Docs

Comments:
Thanks @issamarabi!
Improved notes and added per class examples for accessor extensions
State: closed

- [ ] closes #49202 
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).



Labels:

Comments:
Thanks for the pull request, but it appears to have gone stale and the checks are not all passing. If interested in continuing, please merge in the main branch, address any review comments and/or failing tests, and we can reopen.
WEB: Fix rendering of PDEP-12 
State: closed

Rendering of some bullet list is not correct -> I use markdownlint analysis to enforce standards and consistency.

- [ ] 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: Web
description: pandas website

Comments:
Thanks @loco-philippe 
Thanks to you @mroeschke for this consideration
TST: Fix some plotting xfails
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: Testing
description: pandas testing functions or related to the test suite
name: Visualization
description: plotting
name: Stale

Comments:
This pull request is stale because it has been open for thirty days with no activity. Please [update](https://pandas.pydata.org/pandas-docs/stable/development/contributing.html#updating-your-pull-request) and respond to this comment if you're still interested in working on this.
Still planning on working on this?
Yes - I would like to get back to this, but not in the next few weeks at least. Taking it off the queue.