Hello.
I have discovered a performance degradation in the .to_json function of pandas version below 1.4. And I notice the repository depends on pandas 1.2.5 in requirements.txt. I am not sure whether this performance problem in pandas will affect this repository. I found some discussions on pandas GitHub related to this issue, including #43877 and #45489.
I also found that siuba/ops/support/base.py and siuba/experimental/pivot/sql_pivot_long.py used the influenced api. There may be more files using the influenced api.
Suggestion
I would recommend considering an upgrade to a different version of pandas >= 1.4 or exploring other solutions to optimize the performance of .to_json.
Any other workarounds or solutions would be greatly appreciated.
Thank you!
Issue Description:
Hello. I have discovered a performance degradation in the
.to_jsonfunction of pandas version below 1.4. And I notice the repository depends on pandas 1.2.5 inrequirements.txt. I am not sure whether this performance problem in pandas will affect this repository. I found some discussions on pandas GitHub related to this issue, including #43877 and #45489. I also found thatsiuba/ops/support/base.pyandsiuba/experimental/pivot/sql_pivot_long.pyused the influenced api. There may be more files using the influenced api.Suggestion
I would recommend considering an upgrade to a different version of pandas >= 1.4 or exploring other solutions to optimize the performance of
.to_json. Any other workarounds or solutions would be greatly appreciated. Thank you!