How to remove 5&95 percent outliers by column independently
1 次查看(过去 30 天)
显示 更早的评论
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)
2 个评论
Walter Roberson
2017-9-20
Do you want to leave "holes" in the array, or do you want to replace the outliers with 0 or with NaN ?
回答(1 个)
Walter Roberson
2017-9-20
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
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Statistics and Machine Learning Toolbox 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!