BUG: Bug fix for implicit upcast to float64 for large series (more than 1000000 rows)

[allecole]

PR Requirements

• closes BUG: Implicit upcast to float64 for large series (more than 1000000 rows) #61951
• Tests added and passed if fixing a bug or adding a new feature
• All code checks passed.
• Added type annotations to new arguments/methods/functions.
• Added an entry in the latest doc/source/whatsnew/v3.0.0.rst file if fixing a bug or adding a new feature.

Issue Description

Performing binary operations on larger Series with dtype == 'float32' leads to unexpected upcasts to float64.
Above example prints float32 float64.
Using to_numpy() on the series before addition inhibits the implicit upcast.

Expected Behavior

I expect above snippet to print float32 float32.

Bug Fix

Changed scalar conversion logic for NumPy floating scalars to avoid automatic conversion to Python float. Now returns a scalar of the original NumPy dtype to preserve type and prevent unintended dtype upcasts.

[allecole]

pre-commit.ci autofix

[github-actions]

This pull request is stale because it has been open for thirty days with no activity. Please update and respond to this comment if you're still interested in working on this.

[mroeschke]

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.