Simon Mazenoux requested to merge SIGMON-509_adapt_codebase_for_pandas_newer_releases into dev Oct 18, 2023

Context

Pandas new major release 2.0.0 was released April 3, 2023. This new iteration removes a number of deprecated methods.
The SWAN environment is currently in version 1.2.2, but some of our users are using this project locally, meaning that they might have dependencies errors if they have the latest version of this package installed

What was done

Replace the deprecated append method with the concat function.
Refactor tests to make sure some files are closed
Use column name instead of absolute position to make the code more resilient to changes

TODO

Write acceptance tests (pipeline with pandas>=2.0.0?)

QA

Linked SIGMON JIRA ticket: https://its.cern.ch/jira/browse/SIGMON-509
code is already covered, therefore no further tests were required

Review objectives

assessment of code functionality
assessment of code quality