Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created a mapping table as follows:
Grade Description
A: Great
B: Good
C: Bad
However, I also have Grades such as 'D' and 'E'. Using this mapping table returns NULLs when I create a table with the results. Is there a way in the script I can have non-mapped Grades to say 'n/a'? I'm thinking of an IF function but maybe there is a better way. Thanks!
There's an optional third parameter for applymap() that lets you specify a default value:
applymap('Grade Map',Grade,'n/a')