How do I determine which row my value change significantly

4 views (last 30 days)
I'm looking to automate the process of finding where my column data changes from 375 (about the first 7 rows right now), as it starts decreasing constantly after that. Depending on the data loaded in, the change from a constant 375 can start anywhere from row 3 to row 8, so I'd like to detect where it begins. Thanks!

Accepted Answer

Turlough Hughes
Turlough Hughes on 26 Nov 2019
Edited: Turlough Hughes on 26 Nov 2019
You could find where data is not equal to 375 and then take the first index where this condition is true:
rowstart=min(find(data~=375))
Then your new data would be:
data2=data(rowstart:end);

More Answers (1)

TADA
TADA on 26 Nov 2019
Im assuming its roughly 375 and not exactly that value, otherwise go with Turlough Hughes' solution which is simpler.
The easiest method is to compare the values with tolerance to changes. You can define a threshold value that you would concider as significant reduction
% for the sake of this example I'm using 5% of the initial value (should be ~5% of 375)
threshold = 0.05*data(1);
sigDecMask = data < (data(1) - threshold);
startDecIdx = find(sigDecMask, 1, 'first');

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!