def process_xls()

in src/utils/data.py [0:0]

• 24 lines of code
• 9 McCabe index (conditional complexity)

def process_xls(xls: bytes):
    workbook = open_workbook_xls(file_contents=xls)
    worksheet = workbook.sheet_by_index(0)
    first_row = [worksheet.cell_value(0, col) for col in range(worksheet.ncols)]

    account_info_list = []
    for row in range(1, worksheet.nrows):
        account_info = dict({})
        for col in range(worksheet.ncols):
            key = first_row[col]
            value = worksheet.cell_value(row, col)
            if type(value) is float:
                value = str(int(value))
            elif type(value) is not str:
                value = str(value)

            if key == 'AccountId':
                value = value.zfill(12)

            if key == 'Migrate':
                if value.lower() in ['true', '1']:
                    value = True
                else:
                    value = False

            account_info[key] = value
        account_info_list.append(account_info)

    return account_info_list