Remove cells in table if a specific value is an outlier
1 view (last 30 days)
Show older comments
I want to remove the complete rows of a table if the outlier in the second column which is named 'Close' is an Outlier. I used the following code but no outliers have been removed from the table.
MovingAverage = movmean(NoMV.Close,30)
threshold = 3 * std(MovingAverage);
lowerC = NoMV.Close - threshold;
upperC = NoMV.Close + threshold;
NoMV(NoMV.Close(:)<lowerC, :)=[]
NoMV(NoMV.Close(:)>upperC,:)=[]
0 Comments
Answers (0)
See Also
Categories
Find more on Hypothesis Tests in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!