Potential performance issue: Unreliable performance of df.melt in pandas 2.2.2

[TendouArisu]

Issue Description:

Hello.
I have discovered a performance degradation in the df.melt function of pandas version 2.2.2. And I notice that requirements.txt, shows that it depends on pandas version 2.2.2. I am not sure whether this performance problem in pandas will affect this repository. I found some discussions on GitHub related to this issue, including #59657 and #60461.
I also found that notebooks/tide_modelling/Coastal_altimetry_comparison.ipynb used the influenced api. There may be more files used the influenced api.

Suggestion

I would recommend considering an upgrade to a different version of pandas > 2.2.2 or exploring other solutions to optimize the performance.
Any other workarounds or solutions would be greatly appreciated.
Thank you!