getPriceAverage = (rawDataset, newColumnName) => {
let res = rawDataset.map((d) => ({ ...d }));
const dateColumnNames = [];
for (const key of Object.keys(res[0])) {
if (moment(key, "MM/DD/YYYY", false).isValid()) {
dateColumnNames.push(key);
}
}
res.map((e) => {
let sumRent = 0;
let count = 0;
for (const date of dateColumnNames) {
console.log(date);
if (!isNaN(Number(e[date])) && Number(e[date] !== "")) {
count += 1;
sumRent += Number(e[date]);
}
delete e[date];
}
console.log("sum", sumRent);
let average = sumRent / count;
return (e[newColumnName] = average);
});
return res;
}