Number of assigned hh electricity profiles to census cell may exceed population

[nesnoj]

Electricity profiles are assigned to census cells based on number of households from census (code). Each profile represents one household with >=1 people (hh types are described in table 1 of this paper). In some cells the number of profiles exceed the population.

Example (left cell has grid_id = 100mN34334E43715):
Cells show population (pop 2011), apartments (apa), households (hh) and number of assigned profiles.

The data is correct as I checked the census atlas (2022) and it shows a similar ratio:

According to the official dataset description also secondary residences (Nebenwohnsitz) are counted as households which explain those differences (the example above is located by the sea).

As a simple approach, the number of HH could be scaled down while keeping the ratios.

PS:This has been reported before in eGon-data: openego#435 (comment)