BrandonFors/pandas-github-issues huggingface dataset:
BUG: Fixed merge between int64 uint64 and wrote test
State: closed

- [x] closes #56367
- [x] [Tests added and passed]: test_merge.py
- [x] All [code checks passed]

When you have two DataFrames, left and right, where left's key is of dtype int64 while right's key is of dtype uint64, and both of their values are >= 2**53, what used to happen was that calling left.merge(right) will cause a non empty result to be returned. However, we want the merge function to return nothing since we shouldn't be allowing the merge between DataFrames with different key dtypes.

The issue was that when you are working with values >= 2**53 and you have keys that are of dtype int64 and uint64, the "common dtype" gets resolved to float64 for both, so a (2**53) int64 and (2**53 + 1) uint64 is represented as the same float64 value. 

Labels:
name: Reshaping
description: Concat, Merge/Join, Stack/Unstack, Explode

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: removing SA01 errors for DateTimeIndex: hour, minute, and second.
State: closed

- [ ] xref #58066 
- [ ] [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 @KeiOshima
DOC: Fix SA01 errors for DatetimeIndex.month and DatetimeIndex.year
State: closed

- [ ] xref #58066 
- [ ] [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 @KeiOshima
DOC: Fix SA01 errors for DatetimeIndex methods
State: closed

- [x] xref #58066 
- [ ] [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 @shriyakalakata
DOC: Update DataFrame.sparse methods' docstring to pass docstring validation
State: closed

- [ ] xref #58065

Fixed docstring errors for:

`pandas.DataFrame.sparse`
`pandas.DataFrame.sparse.density`
`pandas.DataFrame.sparse.from_spmatrix`
`pandas.DataFrame.sparse.to_coo`
`pandas.DataFrame.sparse.to_dense`

Fixed functions also removed from code_checks.sh

Labels:
name: Docs

Comments:
Thanks @gboeker
BUG:  `df.plot` with a `PeriodIndex` causes a shift to the right when the frequency multiplier is greater than one
State: closed

- [x] #57587
- [x] #57594 

fixed a bug in `DataFrame.plot` that causes a shift to the right when the frequency multiplier is greater than one and index is `PeriodIndex`.


Labels:
name: Bug
name: Visualization
description: plotting

Comments:
Thanks @natmokval
DEPR: concat ignoring all-NA entries
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: Clean

Comments:
```bash
mypy.....................................................................Failed
- hook id: mypy
- duration: 83.98s
- exit code: 1

pandas/core/internals/concat.py:443: error: Incompatible return value type (got "tuple[dtype[Any] | ExtensionDtype, dtype[Any] | ExtensionDtype]", expected "dtype[Any] | ExtensionDtype")  [return-value]
Found 1 error in 1 file (checked 1443 source files)
```
Thanks @jbrockmendel
BUG: fixes data table alignment when emojis are present
State: closed

- [x] closes #58098
- [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.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.

Data tables were misaligned when there were emojis present. This was because the "display.unicode.east_asian_width" setting that already exists was not being set to true when emojis were present. Added code in format.py -> _make_fixed_width() to check whether or not an emoji is present, then set the above display setting to true accordingly.

Labels:

Comments:
Thanks for this PR but I think an appropriate solution needs iterating on the original issue first so closing this PR
Fix merge error logging order
State: closed

The logged messages have inconsistent key ordering and can lead to confusion, updating error message to keep left -> right order consistent.

Compare to: https://github.com/pandas-dev/pandas/blob/main/pandas/core/reshape/merge.py#L2107

- [ ] 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: Error Reporting
description: Incorrect or improved errors from pandas

Comments:
Sure. Thanks @Georgehe4
DOC: Enforce Numpy Docstring Validation for pandas.HDFStore.append
State: closed

- [ ] xref #58067 
- [ ] [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 @tuhinsharma121
BUG: Setting values on DataFrame with multi-index .loc(axis=0) access adds columns
State: closed

- [x] closes #58116 
- [x] [Tests added and passed]
- [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.

Setting values on a Multi-Index DataFrame with axis=0 passed into loc caused columns to be added when they shouldn't be.

This occurred because when setting items(s) with loc, the axis argument was ignored; _ensure_listlike_indexer(self, key, axis=None, value=None) never has self.axis passed in, and always sets axis to 1.

To solve this, we passed self.axis in as an argument when calling the function, and added an if statement to only set axis to 1 if none is specified. 

coauthored with @regieleki !

Labels:
name: Indexing
description: Related to indexing on series/frames, not to indexes themselves

Comments:
Thanks @eshaready 
Thanks @eshaready!
DOC: Remove deprecated methods w/ SA01 errors from code_checks.sh
State: closed

- [x] xref #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:
Thanks @shriyakalakata
DOC: Remove deprecated methods from code_checks.sh 
State: closed

- [x] xref #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:
Thanks @shriyakalakata
CLN: Enforce the deprecation of `delim_whitespace` kwd in `read_csv`
State: closed

removed kwd `delim_whitespace` from `read_table`, `read_csv`


Labels:
name: IO CSV
description: read_csv, to_csv
name: Clean

Comments:
Sorry I just realized I opened and merged a PR related to this https://github.com/pandas-dev/pandas/pull/58668. Going to close since this was handled
Avoid unnecessary re-opening of HDF5 files (Closes: #58248)
State: closed

- [X] closes #58248 (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.
- [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: Performance
description: Memory or execution speed performance
name: IO HDF5
description: read_hdf, HDFStore

Comments:
Thanks @avalentino
DOC: Enforce Numpy Docstring Validation for pandas.Grouper
State: closed

- [ ] xref #58067 
- [ ] [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:
/preview
Website preview of this PR available at: https://pandas.pydata.org/preview/pandas-dev/pandas/58273/
Thanks @tuhinsharma121
CLN: enforce deprecation of the Series[categorical].replace special-casing
State: closed

xref #56385

enforced deprecation of the behavior of `DataFrame.replace` and `Series.replace` with `CategoricalDtype`

Labels:
name: Categorical
description: Categorical Data Type
name: Clean
name: replace
description: replace method

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 starting this @natmokval
DOC: Enforce Numpy Docstring Validation for pandas.Float32Dtype and pandas.Float64Dtype
State: closed

- [ ] xref #58067 
- [ ] [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:
@mroeschke I am confused with this `Unit Tests / Pyarrow Nightly (pull_request) ` failure . Can you guide me here. My code changes should not break any checks.
Merging branch `main` into `numpy-docstring-floatdtype`. Lets see if that resolves the issue. 
Thanks @tuhinsharma121 (that failure is unrelated)
DOC: Reference Excel reader installation in the read and write tabular data tutorial
State: closed

Created a link to the Excel file recommended installation section and referenced it in the `How do I read and write tabular data?` tutorial.

- [x] closes #58246 

The below are not applicable because I am just updating documentation. 

- [ ] [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
name: IO Excel
description: read_excel, to_excel

Comments:
Thanks @jmbenson
BUG 58031 -- groupby aggregate dtype consistency 
State: closed

- [ ] closes #58031  
- [ ] [Tests added and passed](https://github.com/pandas-dev/pandas/blob/main/pandas/tests/groupby/aggregate/test_other.py) tests added in this directory --> test_groupby_agg_boolean_dtype().
- [ ] All [code checks passed]YES (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. N/A
- [ ] Added an entry in the latest `doc/source/whatsnew/v3.0.0.rst` file.


Labels:
name: Groupby
name: Dtype Conversions
description: Unexpected or buggy dtype conversions
name: Apply
description: Apply, Aggregate, Transform, Map
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: replace deprecated frequency alias
State: closed

replace 'S' with 's'

Dreprecated since version 2.2.0 https://pandas.pydata.org/docs/whatsnew/v2.2.0.html#other-deprecations. 

See https://github.com/pandas-dev/pandas/issues/52536

- ~~[ ] 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:
Dreprecated since version 2.2.0 https://pandas.pydata.org/docs/whatsnew/v2.2.0.html#other-deprecations. 

Reference issue https://github.com/pandas-dev/pandas/issues/52536
Thanks @abonte
BUG: Series.plot(kind="pie") does not respect ylabel argument
State: closed

- [x] closes #58239
- [x] [Tests added and passed]
- [x] All [code checks passed]
- [x] Added [type annotations]
- [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:
Thanks @abeltavares
Prevent conversion to bytes with error message
State: closed

- [x] closes #58205
- [x] BUG Fix (pop up a error message when dytpe is byte because If conversion to bytes is  supported it may lead to data loss such as truncation of the \00.
.


Labels:

Comments:
I'm not sure based on the discussion in https://github.com/pandas-dev/pandas/issues/58205 if this is the appropriate solution so closing this PR
Modified the function to handle invalid boolean casting by returning …
State: closed

…None instead of raising a ValueError. This improves robustness and avoids unexpected interruptions in the flow of the program

- [x] closes 58159(Replace xxxx with the GitHub issue number)
- [x] Bug Fix (Modified the function to handle invalid)


Labels:

Comments:
Thanks for the contribution! This doesn't address the problem, the returned value should be a boolean but you are returning `None` instead, and in the case where the value isn't a boolean then we want to raise a `ValueError`.
> Thanks for the contribution! This doesn't address the problem, the returned value should be a boolean but you are returning `None` instead, and in the case where the value isn't a boolean then we want to raise a `ValueError`.

> HI @Aloqeely Thank you for your valuable feedback. I will make the necessary changes to address the issues you mentioned. Before I submit an updated pull request, I want to ensure that the code passes all relevant test cases locally.

Could you please provide some guidance on how to run the test cases locally? Any specific commands or instructions you could share would be very helpful.

Thank you again for your assistance.
Of course! https://pandas.pydata.org/docs/development/contributing_codebase.html#running-the-test-suite
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.
ENH: DtypeWarning message enhancement
State: closed

- [x] closes #58174
- [x] [Tests added and passed]
- [x] All [code checks passed]
- [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
name: Warnings
description: Warnings that appear or should be added to pandas

Comments:
Thanks @abeltavares
BUG: Implement fillna(..., limit=x) for EAs
State: closed

- [x] closes #58001 (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: Bug
name: Missing-data
description: np.nan, pd.NaT, pd.NA, dropna, isnull, interpolate
name: ExtensionArray
description: Extending pandas with custom dtypes or arrays.

Comments:
Thanks @rhshadrach
DOC: Add documentation on parquet categorical data handling
State: closed

- [x] closes #55776 
- [x] All [code checks passed]


Labels:
name: Docs
name: IO Parquet
description: parquet, feather

Comments:
This PR is ready for review. Thanks.


/preview
Website preview of this PR available at: https://pandas.pydata.org/preview/pandas-dev/pandas/58245/
Thanks @abeltavares
DEPR: logical ops with dtype-less sequences
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: Clean

Comments:
Thanks @jbrockmendel
DEPR: object casting in Series logical ops in non-bool cases
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: Clean

Comments:
Thanks @jbrockmendel