BrandonFors/pandas-github-issues huggingface dataset:
ENH: pd.cut() supports str for "bin" argument 
State: closed

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

Comments:
> I am not fully convinced that this feature needs to be included in pandas as is given its straightforward implementation.
> 
> I would support documenting how to use `histogram_bin_edges` along with `cut`

Right, I understand your point. However, since there were efforts in the past to get this feature in pandas https://github.com/pandas-dev/pandas/pull/23567 (but weren’t successful due to some dependency versioning issues) and there’s been another request for this feature recently (https://github.com/pandas-dev/pandas/issues/59165), I’d say its worth reconsidering. The implementation is simple, less likely to break things hence easier to support. I feel it would improve user experience - still just a suggestion, happy to discard this work and open a new PR with documentation changes if you’re still not convinced.
clean: simplify lite-rule-alias and dont-uppercase
State: closed

work in progress, trying to clean this confusing code

- [ ] 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: Frequency
description: DateOffsets
name: Clean

Comments:
@MarcoGorelli, these changes look good to me.
When we merge this PR, I can close https://github.com/pandas-dev/pandas/pull/56516.
Thanks @MarcoGorelli
ENH: DataFrame.plot.scatter argument `c` now accepts a column of strings, where rows with the same string are colored identically
State: closed

- [x] Closes #16827 
- [x] Closes #16485
- [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: Visualization
description: plotting

Comments:
```py
import pandas as pd
import random as rand

df = pd.DataFrame({
    'dataX': [rand.randint(0, 100) for _ in range(100)],
    'dataY': [rand.randint(0, 100) for _ in range(100)],
    'fav_fruit': [rand.choice(['Apples', 'Bananas', 'Grapes', 'Peaches']) for _ in range(100)],
})
df.plot.scatter('dataX', 'dataY', c='fav_fruit')
```
![image](https://github.com/user-attachments/assets/98089baa-fd49-4189-97fd-8a6521086184)

```py
df = pd.DataFrame({
    'dataX': [rand.randint(0, 100) for _ in range(100)],
    'dataY': [rand.randint(0, 100) for _ in range(100)],
    'fav_fruit': [rand.choice(['Grapes', 'Bananas', 'Apple', 'Peaches']) for _ in range(100)],
})

df.plot.scatter('dataX', 'dataY', c='fav_fruit')
```
<img width="566" alt="image" src="https://github.com/user-attachments/assets/43fff578-0ab2-4250-a775-c29082cc0861">

```py
df = pd.DataFrame({
    'dataX': [rand.randint(0, 100) for _ in range(100)],
    'dataY': [rand.randint(0, 100) for _ in range(100)],
    'fav_fruit': [rand.choice(['Grapes', 'Bananas', 'Apple', 'Peaches']) for _ in range(100)],
})

df.plot.scatter('dataX', 'dataY', c='fav_fruit', cmap='rainbow')
```
<img width="573" alt="image" src="https://github.com/user-attachments/assets/0021007a-1d36-4147-ac4e-d2d6f70ee09e">

Not sure if I need to add this as part of this PR, but there is some documentation (and maybe more) about using the `c` arg in `df.plot.scatter` found in: https://github.com/pandas-dev/pandas/blob/main/doc/source/user_guide/visualization.rst?plain=1#L636-L637

Should I update this to include this new feature?
Thanks @michaelmannino - very impressive work! Thanks for all the efforts on the refactors / feedback
Add column_offset to explode
State: closed

- [x] closes #59163  (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: 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.
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.
BUG/TST: non-numeric EA reductions
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/v3.0.0.rst` file if fixing a bug or adding a new feature.

Fixes a few bugs related to non-numeric EA reductions and expands testing by un-skipping a number of existing tests.

```
> pytest -k test_reduce pandas/tests/extension/

# main branch
2160 passed, 1222 skipped, 154 xfailed

# PR
2507 passed, 886 skipped, 143 xfailed
```


BUG fix example:

```
In [1]: import pandas as pd

In [2]: arr = pd.array([None], dtype="duration[ms][pyarrow]")

In [3]: pd.DataFrame({"a": arr}).min().dtype

# main branch
Out[3]: int64[pyarrow]

# PR
Out[3]: duration[ms][pyarrow]
```

Labels:
name: Bug
name: ExtensionArray
description: Extending pandas with custom dtypes or arrays.
name: Reduction Operations
description: sum, mean, min, max, etc.

Comments:
Thanks @lukemanley
DOC: inline link
State: closed

avoid showing bare URL

Check my work please! I'm not very familiar with RST. I also feel like there's a simpler way to write this that I'm not aware of.

- ~~[ ] 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: Docs

Comments:
Thanks @wjandrea
modified the automatically generated docstring to include the return …
State: closed

- [ ] Fixes docstring errors for max/min/median/min methods in core.DataFrame ([Doc: Enforce numpy validation](https://github.com/pandas-dev/pandas/issues/58065))
- [ ] [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: Docs

Comments:
Looks like you can remove one more code

`Error: /home/runner/work/pandas/pandas/pandas/core/series.py:7059:RT03:pandas.Series.skew:EXPECTED TO FAIL, BUT NOT FAILING`
Thanks @BorjaElizalde
CLN: enforce the deprecation ofaccepting Manager objects in DataFrame/Series
State: closed

enforced the deprecation of accepting Manager objects in DataFrame/Series

Labels:
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.
Looks like this PR has gone stale so going to close, but feel free to reopen if you want to revisit
BUG: fix json_normalize with meta far different from record_path
State: closed

- fix of json_normalize when record_path long and meta path far different from record_path
- 1 test added and passed


Labels:
name: Stale

Comments:
Is there an associate GIthub issue for this PR? 
> Is there an associate GIthub issue for this PR?

no. Should i create one with minimal reproducible example?
`result = pd.json_normalize(data={'meta1':{'meta2':'meta_val'}, 'record1':{'record2':[{'rec1':'rec_val1'},{'rec1':'rec_val2'}]}}, meta=[['meta1','meta2']], record_path=['record1','record2'])` falls into exception `KeyError: "Key 'meta2' not found.`
> no. Should i create one with minimal reproducible example?

Yes, it would give more context why this fix is needed
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.
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.
BUG: Fix read_csv index dtype override
State: closed

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

Comments:
hey, thanks for the ping and the PR - I'm not really familiar with this part of the codebase. I can take a look but I'm afraid there are other priorities at the moment
@mroeschke Hi Matthew, can you help take a look at my pr for this?
Sorry I just merged https://github.com/pandas-dev/pandas/pull/59316 which overlaps with your fix here. Thanks for the contribution but going to close now that the issue is fixed
fix-issue-59196: add extra check for np arrays
State: closed

- [x] closes #59196 (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
- [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.
- [ ] 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 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.
DOC: add SA01 for pandas.api.types.is_int64_dtype
State: closed

part of https://github.com/pandas-dev/pandas/issues/58577

``` -i "pandas.api.types.is_int64_dtype SA01" \```

Labels:

Comments:
same as in the other pr
```
Error: /home/runner/work/pandas/pandas/pandas/core/dtypes/common.py:807:GL07:pandas.api.types.is_int64_dtype:Sections are in the wrong order. Correct order is: Parameters, Returns, See Also, Notes, Examples
Error: /home/runner/work/pandas/pandas/pandas/core/dtypes/common.py:807:SA05:pandas.api.types.is_int64_dtype:pandas.api.types.is_numeric_dtype in `See Also` section does not need `pandas` prefix, use api.types.is_numeric_dtype instead.
Validate Docstrings DONE
Error: Process completed with exit code 2.
```
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.
DOC: add SA01 for pandas.api.types.is_extension_array_dtype
State: closed

part of #58577

``` -i "pandas.api.types.is_extension_array_dtype SA01" \```

Labels:

Comments:
hi @tianyeeT - please check the ci error
```
Error: /home/runner/work/pandas/pandas/pandas/core/dtypes/common.py:1298:GL07:pandas.api.types.is_extension_array_dtype:Sections are in the wrong order. Correct order is: Parameters, Returns, See Also, Notes, Examples
Error: /home/runner/work/pandas/pandas/pandas/core/dtypes/common.py:1298:SA05:pandas.api.types.is_extension_array_dtype:pandas.api.types.is_integer_dtype in `See Also` section does not need `pandas` prefix, use api.types.is_integer_dtype instead.
```
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.
Add support for NumpyExtensionArray in pd.unique()
State: closed

- [x] closes #59213  (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.
- [ ] 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: Algos
description: Non-arithmetic algos: value_counts, factorize, sorting, isin, clip, shift, diff

Comments:
Thanks @ritwizsinha
Update read_html docs
State: closed

- [x] closes #59147 (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
- [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.
- [ ] 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
name: IO HTML
description: read_html, to_html, Styler.apply, Styler.applymap

Comments:
Thanks @ritwizsinha
DOC: Grammatically updated the tech docs "Package Overview"
State: closed

Small grammatical update to the Package Overview


**Location of the documentation**
https://pandas.pydata.org/docs/dev/getting_started/overview.html


![image](https://github.com/pandas-dev/pandas/assets/113131386/a9a5f092-677a-4fc4-b127-35f9daf51c0b)



Labels:
name: Docs

Comments:
Thanks @ViswaBonam
ENH: dt.day_of_week should return int8
State: closed

- [X] closes #58185
- [ ] [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.
- [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: 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.
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.
DOC: Add notes section to .isin() docs
State: closed

Add a Notes section to the .isin() method docs to clarify that we use __iter__ over __contains__ when checking each element in the `values` collection passed as argument. This clarification was requested because `values` can be a dict, which suggests that under the hood isin() uses __contains__ rather than __iter__, which is not the case and might confuse some users.

- [x] closes #59041 
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit)

Output of the docs checker script, same as before adding the doc change:
```
1 Errors found for `pandas.DataFrame.isin`:
	ES01	No extended summary found
```

![image](https://github.com/pandas-dev/pandas/assets/24620565/81d3d626-b2bf-4bee-b542-3c6147572d6d)


Labels:
name: Docs

Comments:
Thanks @AnaDenisa
DOC: fix the Return type for pandas.Timestamp.asm8
State: closed

- [x] closes #59184 (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
- [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.
- [ ] 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 @Anurag-Varma
DOC: added adbc connection in con parameter of to_sql and example of its usage
State: closed

- [ x] closes #59095 (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
- [ 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: Docs
name: IO SQL
description: to_sql, read_sql, read_sql_query

Comments:
Thanks @wooseogchoi
Pyarrow series .any() Error fixed
State: closed

- [ ] closes #59192  (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:
Sorry I missed this PR, but the issue has been solved with https://github.com/pandas-dev/pandas/pull/59211 so closing
REF: Add back attr passing in concat by attribute
State: closed

xref https://github.com/pandas-dev/pandas/pull/59141#issuecomment-2211690779

Labels:
name: Refactor
description: Internal refactoring of code
name: Reshaping
description: Concat, Merge/Join, Stack/Unstack, Explode
name: metadata
description: _metadata, .attrs

Comments:
Going to merge to fix geopandas CI downstream. Happy to follow up if needed
51500: Add test for unexpected behavior math operations using multiin…
State: closed

…dexes

- [ ] closes #51500(Replace 51500 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: Groupby

Comments:
@phofl please check
Thanks @LuckIlNe
DataFrameGroupBy.agg with nan results error Fixed
State: closed

- [#59106 ] closes #59106  (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 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.