I have 4 Perl Scripts that I need translated into Python3. The scripts are quite simple, but undocumented (no comments in the code either).
They take a large (+-50.000 rows) excel file containing product data as input (the source file is the same for all 4 scripts) and the output for each script is a file with the excel data formatted in a different way, with certain columns removed, renamed, etc.... They use perl-libraries 'ParseXLSX' and 'WriteExcel'
I need the python scripts to have the same output as the perl scripts, and there needs to be clear comments in the code in English so that later adjustments are easy.
I have added one of the perl scripts as an example, the others are similar in complexity and size.