Fix nightly CI with split case for pandas (around 3.0.0 version)

[loicdiridollou]

• [x] Closes #973
• [x] Tests added: Please use assert_type() to assert the type of any return value

[loicdiridollou]

@Dr-Irv I tried to clean up the test but the context is dependent on pandas<3.0 and numpy>=2.0 so that makes the logic a little crooked. I improved it but there is no way to have all the show_versions at once (since in one case it will raise a UserWarning and not in another). Let me know if you find a better way to write those, I was not overly familiar with the logic at first so did not want to break it all.

[loicdiridollou]

thanks @loicdiridollou . Let's see what happens after I merge

Fingers crossed!

[Dr-Irv]

thanks @loicdiridollou . Let's see what happens after I merge

Fingers crossed!

It succeeded. Thanks for looking into this