MATLAB: Replacing individual Values in Data column based on a condition

columnMATLABtable

Hello!
I am new to matlab and programming in generall. I have been working with a large data table. I have a few outliers in one o the columns and would like to replace them with the value 1.
However, I keep getting the error "Right hand side of an assignment into a table must be another table or a cell array."
Here is my code. Any help is appreciated!
myData=db_data.dataTable;
myData(myData.fluid_p_rel<0.9,:)=[1];
myData(myData.fluid_p_rel>1.2,:)=[1];

Best Answer

  • idx = myData.fluid_p_rel<0.9 | myData.fluid_p_rel>1.2;
    myData.fluid_p_rel(idx) = 1