How to remove 5&95 percent outliers by column independently

Hi,

I have below data, and want to remove outliers by column independently,

vector:

0.2 2   5
1   4   6
2   0.3 17
2   4   9
40  5   36
3   0.3 54

I use the below function, but it can only be used for column array. How to use for the matrix?

percntiles = prctile(vector,[5 95]) 
outlierIndexes = vector < percntiles(1) | vector > percntiles(2);

outliers = vector(outlierIndexes)

nonOutliers = vector(~outlierIndexes)

[Walter Roberson]

Do you want to leave "holes" in the array, or do you want to replace the outliers with 0 or with NaN ?

[Mekala balaji]

replace outliers with NaN.

Answer 1

[Walter Roberson]

Take the per column low percentile which gets you a row of values. Replicate into as many rows as the original. Compare to the original, getting out a logical matrix. Do the same with the high percentile, getting a second logical matrix. Or the two. Now use that as a mask to assign nan to those locations