MATLAB: Replacing in categoricals or defining a default value

categoricalsMATLABreplaceundefined

I have a table with serveral columns one ot them contains categorical values called parttype. Initially the column ist empty resulting in <undefined> in every cell. After user input some of the cells might get filled. Which leads to the situation in the picture below:

I now want to compare the the new table with the old one to find the rows that have been changed. But since compareing <undefined> with each other will always say they are different this is not an option.

Therfore I wanted to replace all <undefined> values with a value like '-empty-' or make this the default value. But I can't figure it out.

Best Answer

YourTable.parttype = fillmissing(YourTable.parttype, 'constant', '-empty-');

Related Solutions

MATLAB: Replace specific values in one column with value from the same row of another column

Pretty simple, yes...first rebuild the table as described...

s=["NaN" "" "" "NaN" "D" "NaN" "NaN" "E"].';
c=categorical(cellstr({'A', 'A', 'B', 'C', 'Other', 'C', 'B', 'Other'})).';
t=table(c,s);
ix=t.c=='Other';              % find the wanted rows
t.c(ix)=categorical(t.s(ix)); % fill in the column

Convert to string class..

>> string(t.c)
ans = 
8×1 string array
  "A"
  "A"
  "B"
  "C"
  "D"
  "C"
  "B"
  "E"
>>

Or, can convert the table in place if desired or bring outside the table if don't want to alter original or add a new variable column or whatever, depending the precise end result desired.

MATLAB: Delete nan values and the corresponding value in another array

nanIdx = find( isnan(A) | isnan(B) | isnan(C) );
A(idx) = NaN; B(idx) = NaN; C(idx) = NaN

Best Answer

Related Solutions

MATLAB: Replace specific values in one column with value from the same row of another column

MATLAB: Delete nan values and the corresponding value in another array

Related Question