Diagnostic failures due to latest version of pandas

[remi-kazeroni]

Describe the bug
In the recipe testing with esmvalcore2.8.1rc1, it was found that several recipes fail with diagnostic issues relates to the pandas package. See ESMValGroup/ESMValCore#2069
This package was at version 1.5.3 at the time of the v2.8.0 release and is now at 2.0.1.

Failing recipes due to issues with pandas:

• recipe_ecs_constraints.yml
• recipe_meehl20sciadv
• recipe_schlund20esd
• recipe_schlund20jgr_gpp_abs_rcp85
• recipe_schlund20jgr_gpp_change_rcp85

These 5 recipes share the same maintainer: @schlunma 😅
Could you please have a look at these issues and tell us if it would be possible to fix these diagnostics or if we should rather pin pandas?

Please attach

• The recipe that you are trying to run, you can find a copy in the run directory in the output directory
• The main_log_debug.txt file, this can also be found in the run directory in the output directory

See https://esmvaltool.dkrz.de/shared/esmvaltool/v2.8.1rc1/

[schlunma]

Thanks for doing all those tests @remi-kazeroni !!

It looks like its almost always the same issue, which I think is pretty easy to fix. I try to address this is time for v2.9.0.

[valeriupredoi]

🐼 =2.0.2 is now out, would that be fixing the issue, possibly?

[bouweandela]

recipe_impact.yml appears to be affected too, running it with pandas 2.0.2 it fails with the error:

Traceback (most recent call last):
  File "/home/b/b381141/src/esmvalgroup/esmvaltool/esmvaltool/diag_scripts/impact/bias_and_change.py", line 266, in <module>
    main(config)
  File "/home/b/b381141/src/esmvalgroup/esmvaltool/esmvaltool/diag_scripts/impact/bias_and_change.py", line 259, in main
    plot_htmltable(tidy_df, ancestors, cfg)
  File "/home/b/b381141/src/esmvalgroup/esmvaltool/esmvaltool/diag_scripts/impact/bias_and_change.py", line 172, in plot_htmltable
    .render()
     ^^^^^^
AttributeError: 'Styler' object has no attribute 'render'. Did you mean: '_render'?