Task Title

Task: Long term pandas==2.0 support: adapt unsupported pandas usages

Task Description

See #159 for the context on pandas 2.0 introduction causing issues.
#159 handles short term fix for that.
In this ticket, handle pandas 2.0 for the longer term.

See https://pandas.pydata.org/docs/dev/whatsnew/v2.0.0.html for the changes that we need to support, among others no longer inplace arguments for dataframe change operations.