Fix test failures with pandas 2.3

[rwedge]

Error Description

Several test cases are failing when run with pandas 2.3.0 installed. The test were expecting specific error messages from pandas and the error message has changed with the new release.

Steps to reproduce

1. Upgrade pandas to 2.3.0
2. Run the unit or integration tests