def save_solutions_hub_osci_change_report_view()

in osci/datalake/base.py [0:0]

• 18 lines of code
• 1 McCabe index (conditional complexity)

    def save_solutions_hub_osci_change_report_view(self, change_report: pd.DataFrame, report_dir_name: str,
                                                   old_date: datetime, new_date: datetime):
        writer, buffer = self.get_excel_writer()
        sheet_name = 'OSCI_Ranking'

        change_report.to_excel(writer, sheet_name=sheet_name, startrow=2, startcol=1)

        worksheet = writer.sheets[sheet_name]
        worksheet.write(0, 1, old_date.strftime('%Y (differences from %B, %d  ') + new_date.strftime('to %B, %d)'))
        worksheet.write(3, 9, '1 Active Contributors are those who authored 10 or more pushes in the time period')
        worksheet.write(4, 9, '2 Total Community counts those who authored 1 or more pushes in the time period')
        worksheet.write(5, 9, '* Changes are relative to the metrics at the end of the previous month')
        worksheet.write(6, 9, 'The top 100 is calculated using the Active Contributors metric')
        worksheet.write(7, 9, 'If two companies have equal Active Contributors, '
                              'their relative positions are determined by Total Community')
        writer.save()

        self.write_bytes_to_file(path=self.get_osci_change_excel_report_path(base_report_name=sheet_name,
                                                                             report_dir_name=report_dir_name,
                                                                             date=new_date),
                                 buffer=buffer)