[Python] NumPy 2.0 compat: remove usage of np.core #39533
Description
Sub-issue of #39532
We have to fix the following warning (from nightly build with numpy 2.0.0.dev, eg https://github.com/ursacomputing/crossbow/actions/runs/7454906275/job/20283098411):
opt/conda/envs/arrow/lib/python3.10/site-packages/pyarrow/pandas_compat.py:33
/opt/conda/envs/arrow/lib/python3.10/site-packages/pyarrow/pandas_compat.py:33: DeprecationWarning: numpy.core.numerictypes is deprecated and has been renamed to numpy._core.numerictypes. The numpy._core namespace contains private NumPy internals and its use is discouraged, as NumPy internals can change without warning in any release. In practice, most real-world usage of numpy.core is to access functionality in the public NumPy API. If that is the case, use the public NumPy API. If not, you are using NumPy internals. If you would still like to access an internal attribute, use numpy._core.numerictypes.sctypes.
from numpy.core.numerictypes import sctypes as _np_sctypes