Skip to content

Bug in values reported for AggRegion if data from 'Aggregate_from_Single' in ODYM_RECC_Export_xlxs_Combine_Select.py #83

@chauenstein

Description

@chauenstein

When exporting data from RECC results, using the script data_export/ODYM_RECC_Export_xlxs_Combine_Select.py, values are not reported correctly if 'Aggregate_from_Single' is selected for 'Regional resolution (is given by RECC export routine for each indicator)'. For example,

  1. if the target region (AggRegion) is supposed to consist of RECC Region 1 and RECC Region 2 (two native RECC regions), and the selected indicator is 'Population', then the value reported for 'Population' for AggRegion is not the sum of 'Population' of RECC Region 1 and 2, but just the value of one of the regions (depending on the order the regions are read in).
  2. If the RECC Region is an aggregate region itself, from a model run with more than one RECC native region selected, it does not work either

This seems to stem, at least for the first example, from the 'except: break' part in the code snippet below (from the above script)

                            if rr[j] == 'Aggregate_from_Single': # use indicator for aggregate region label and add to results:
                                for sir in range(0,len(Dr[r])):
                                    try:
                                        idx = get_RECC_resfile_pos(ri[j],Dr[r][sir],RECC_RS) # position of that indicator for that region in the RECC result file
                                    except: # no such indicator for this region
                                        break
                                    for t in range(0,46): # read and add values
                                        Res[targetpos,t] += RECC_RS.cell(idx+offs[s],t+8).value * cf[j] # Value from Excel to array

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions