Consider the following Objects:
// Example 1
{
gradeA: 100,
gradeB: 'No-Data',
gradeC: 'No-Data'
}
// Example 2
{
gradeA: 50,
gradeB: 40,
gradeC: 'No-Data'
}
// Example 3
{
gradeA: 75,
gradeB: 'No-Data',
gradeC: 'No-Data'
}
They represent a percentage, i.e. the sum of all three grades will be exactly 100. How can we interpolate the keys with 'No-Data' whenever their values can be calculated?
Expected Results:
// Example 1
{
gradeA: 100,
gradeB: 0,
gradeC: 0
}
// Example 2
{
gradeA: 50,
gradeB: 40,
gradeC: 10
}
// Example 3
{
gradeA: 75,
gradeB: 'No-Data',
gradeC: 'No-Data'
}
// Note: This one can't be figured out so we leave it as is.
My solution in pseudo-code:
function interpolate(obj) {
// If only one key is a number:
// The value is 100:
// Set the other two keys to 0 and return the obj.
// The value is less than 100:
// return obj unchanged.
// If only one key is not a number:
// set that key to the sum of the two numbers minus 100 and return the obj.
}
There are two main questions here:
'No-Data'.In reality, these Objects are inside an Array, but I'm sure I can figure that stuff out myself.
Using the same logic you've described:
function interpolate(obj) {
var noData = 0;
Object.keys(obj).forEach(key => {
if (isNaN(obj[key])) {
noData++;
}
});
var sum = 0;
var missingKey;
if (noData == 1) {
Object.keys(obj).forEach(key => {
if (!isNaN(obj[key])) {
sum += obj[key];
} else {
missingKey = key;
}
});
obj[missingKey] = 100 - sum;
return obj
}
return obj;
}
var objects = [{
gradeA: 100,
gradeB: 'No-Data',
gradeC: 'No-Data'
}, {
gradeA: 50,
gradeB: 40,
gradeC: 'No-Data'
}, {
gradeA: 75,
gradeB: 'No-Data',
gradeC: 'No-Data'
}]
objects.forEach(o => console.log(interpolate(o)));No-Data).let keys = Object.keys(obj).filter(k=>obj[k]===value);
Just count the number of items in the array to see how many you have.
No-Data. Tip: If you are trying to be as efficient as possible, you don't need to keep finding occurrences of No-Data after you find 2 :)Ps. There are a few issues with the other code that was posted that will probably stop you from getting full points if you turn it in :)
In my solution I analyze each object for the combined sum of the grades and the number of No-Data values. Then I proceed to replace the No-Data values in each property of each object if conditions match. Works with any number of grades.
const objects = [{
gradeA: 100,
gradeB: 'No-Data',
gradeC: 'No-Data'
}, {
gradeA: 50,
gradeB: 40,
gradeC: 'No-Data'
}, {
gradeA: 75,
gradeB: 'No-Data',
gradeC: 'No-Data'
}];
const analysis = objects
.map( o => Object.values(o)
.reduce( ([o, sum, nodatacount], v) =>
v==='No-Data'
? [o, sum, nodatacount+1]
: [o, sum+v, nodatacount],
[o, 0, 0] ) );
for(const [o, sum, nodatacount] of analysis) {
if(sum === 100 || nodatacount === 1) {
for(const [key, _] of Object.entries(o)
.filter(([_, value]) => value==='No-Data')
) {
o[key] = 100-sum;
}
}
}
console.log( objects );.as-console-wrapper {top:0; max-height: 100% !important}