BUG (string dtype): comparison of string column to mixed object column fails #60228 (fixed) - Githubissues

pandas-dev / pandas

Flexible and powerful data analysis / manipulation library for Python, providing labeled data structures similar to R data.frame objects, statistical functions, and much more

https://pandas.pydata.org

BSD 3-Clause "New" or "Revised" License

43.83k stars 18k forks source link

BUG (string dtype): comparison of string column to mixed object column fails #60228 (fixed) #60392

Open TEARFEAR opened 9 hours ago

TEARFEAR commented 9 hours ago

Changes :

Updated comparison_op function in pandas/core/ops/array_ops.py:
- Added handling for comparisons between string and object dtypes.
- Ensured string and object types are casted to a common type (string) before comparison.
Added a test case to validate the fix:
- Verified comparison works for string vs object with homogeneous and mixed types.
- Verified behavior with PyArrow-based strings enabled (pd.options.future.infer_string = True).
[x] closes #60228 (Replace xxxx with the GitHub issue number)
[x] Tests added and passed if fixing a bug or adding a new feature
[x] All code checks passed.
[x] Added type annotations 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.