region_data = {
let region_data = {};
for (let i = 0; i < cleaned_data.length; i++) {
let obj = cleaned_data[i];
let region = obj['Region'];
if (!region_data[region]) {
region_data[region] = { Region: region, count: 0 };
for (let j = 0; j < yearColumns.length; j++) {
region_data[region][yearColumns[j]] = 0;
}
}
region_data[region].count += 1;
for (let j = 0; j < yearColumns.length; j++) {
region_data[region][yearColumns[j]] += obj[yearColumns[j]];
}
}
return Object.values(region_data).map(obj => {
for (let j = 0; j < yearColumns.length; j++) {
obj[yearColumns[j]] = obj[yearColumns[j]] / obj.count;
}
return obj;
});
}