Calculate mean values of specific (but dynamic) intervals

10 次查看（过去 30 天）

显示更早的评论

NB 2019-8-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/474441-calculate-mean-values-of-specific-but-dynamic-intervals

评论： NB 2019-8-2

采纳的回答： Jos (10584)

Example.xlsx

Hello everyone,

I want to calculate mean values of specific (but dynamic) intervals across several result files. I know how I get more than one results file into MATLAB and the other basics.

But what I dont know is the following: an interval should be defined/ starting when a value is between -0.05 and 0.05 in a specific column. It is dynamic, because it sometimes lasts for 8 seconds, sometimes for 10 seconds. So the interval should be ended when the value is <-0.05 or >0.05.

Then i want to calculate the mean value of data from another column according to the defined intervals in the other column.

I hope u understand what I want to do.

Thanks in advance

7 个评论
显示 5更早的评论隐藏 5更早的评论

NB 2019-8-1

well it will cross it several times (roughly 20-25 times) so there are 20-25 intervals that are of interest and which has to be defined. so unfortunately u cant truncate something

dpb 2019-8-1

Ah! That's a key piece, then...

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Jos (10584) 2019-8-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/474441-calculate-mean-values-of-specific-but-dynamic-intervals#answer_385804

在 MATLAB Online 中打开

% interval and value are the relevant columns of your data matrix
interval = data(:,3)
value = data(:,2)
% find the sections 
q = ~(interval < -.05 | interval > .05) 
dq = diff([false q false])
ix1 = find(dq==1)
ix2 = find(dq == -1) - 1 
% function to apply to each section
myfun = @(k) mean(value(ix1(k):ix2(k))) 
R = arrayfun(myfun, 1:numel(ix1)) % mean of each section