COMPAT: numpy test warnings
Fixes #30334.

Some of the warnings are coming from within pandas (like the FutureWarning on truediv), some are numpy warnings (like the nan-warning on sign). All in all changes are minor.

Tests are passing with `-Werror` for me now.