How to identify the beginning of another hour and choose 3 rows per hour depending on the value of another metric in another column?

Question

Márcia Nunes 2020-8-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/585542-how-to-identify-the-beginning-of-another-hour-and-choose-3-rows-per-hour-depending-on-the-value-of-a

回答： Rishabh Mishra 2020-9-3

Hey everybody!

I want to analyse 24h ECG recordings (that are divided in several files) from several patients and I already have the metrics in struct files. The metrics are analysed each 5 minutes but I need to analyse statistically 10 min in each hour with an overlap of 50% (3 rows per hour). The rows need to be consecutive and depend on a threshold in column 3 (minimum of 50% in each row) so they don't always get chosen every N rows (attached picture). I need to find the mean, maximum and minimum of those 3 rows.

I also have a char event time with the time and date of the beginning of the file, the beginning and end of the intervals I am interested in (attached picture).

Could anyone help me with the easiest/efficient way to analyse all the data?

2 个评论
显示无隐藏无

Rishabh Mishra 2020-9-2

Hi,

Kindly attach the ECG readings file, it would enable me to come up with an efficient solution and help you in the best way possible.

Márcia Nunes 2020-9-2

Hi Rishabh, I am afraid I can't attach the file you are are requesting since the data is confidential. If there is some way to help me it would be great, if not I understand it is complicated to help without all the information

请先登录，再进行评论。

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

Answer 1

Rishabh Mishra 2020-9-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/585542-how-to-identify-the-beginning-of-another-hour-and-choose-3-rows-per-hour-depending-on-the-value-of-a#answer_489181

在 MATLAB Online 中打开

Hi,

Consider the code given below. Few assumptions that I have made while writing this code are:

The readings are taken starting 12 at Midnight.
The ECG readings & it’s columns are stored in ‘M’ matrix.
The readings consist of 24 x 12 rows.
The number of readings taken every hour is 12 (as readings are taken every 5 minutes on average)

The code:

% assuming that ECG rreadings are taken starting 12 Midnight
start = datetime(2020,1,1,0,0,0)
 
% assuming that data is stored in 'M' matrix
 
% time of reading
time = M(:,1)
% reading value
reading = M(:,2)
% threshold value
threshold = M(:,3)
 
% traverse each row of the data
for k = 1:numel(time)
    i = 0
    
    if (time(k) >= start & threshold(k) >= 50.0)
        i = i+1
    else
        i = 0
    end
    
    % if 3 consecutive rows with given requirements are found
    if (i == 3)
        disp(mean(reading(k-2:k))
        disp(min(reading(k-2:k))
        disp(max(reading(k-2:k))
        start = start + duration(1,0,0)
        i = 0
    end
end

Hope this helps.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

How to identify the beginning of another hour and choose 3 rows per hour depending on the value of another metric in another column?

2 个评论
显示无隐藏无

回答（1 个）

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

How to identify the beginning of another hour and choose 3 rows per hour depending on the value of another metric in another column?

2 个评论 显示 无隐藏 无

回答（1 个）

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

2 个评论
显示无隐藏无

0 个评论
显示 -2更早的评论隐藏 -2更早的评论