Development of a Python script for automatic processing of financial Excel reports.
Functionality:
• data cleaning and normalization
• calculation of payments and debts
• grouping by settlements
• formation of summary rows (all / debtors)
• automatic Excel formatting (column widths, styles, highlighting, freeze panes)
• generation of final report with one click
The project works with closed and personal data, therefore:
— the source code is published partially
— examples of final files are not provided
A screenshot of the code execution process is added to the portfolio.
Functionality:
• data cleaning and normalization
• calculation of payments and debts
• grouping by settlements
• formation of summary rows (all / debtors)
• automatic Excel formatting (column widths, styles, highlighting, freeze panes)
• generation of final report with one click
The project works with closed and personal data, therefore:
— the source code is published partially
— examples of final files are not provided
A screenshot of the code execution process is added to the portfolio.