How to extract data from two separate tabs

1 次查看（过去 30 天）
Sam
Sam 2021-1-21
编辑： Matt Gaidica 2021-1-22
I have heart rate and time in two columns. I am going to filter heart rates above 95 bpm. However, in another two columns I have certain "events" that occurred throughout the recording and the times the events occurred. The time of the events don't necessarily match up with the time of the heart rates I want to extract. Tips on creating a script to filter out the heart rates above 95 along with the event that precedes the high heart rate??

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

回答（1 个）

Matt Gaidica
Matt Gaidica 2021-1-22
The easiest way to think about this would be using a simple series find statements and the returned indexes to do time comparisons, as well as pull event type.
Post a sample of your actual data, I can imagine some caveats and best practices depending on how it's formatted.
  4 个评论
显示 2更早的评论
Sam
Sam 2021-1-22
编辑：Sam 2021-1-22
Thanks for the guidance. I attached the file below in case you have any more thoughts. My goal is to filter out heart rates above 95, just for this particular exampmle, and then the event codes/times that precede it. I appreciate the help! I tried the tutorials, but I wasn't sure how to get started. Anyway thanks
Matt Gaidica
Matt Gaidica 2021-1-22
编辑：Matt Gaidica 2021-1-22
Sure thing. Try this:
hrIds = find(Data{:,'Heart Rate'} > 95);
hrTimes = Data{hrIds,'Heart Rate Times'};
eventCodes = NaN(1,numel(hrTimes));
for ii = 1:numel(hrTimes)
precTimeId = find(Data{:,'Event Times'} < hrTimes(ii),1,'last');
if ~isempty(precTimeId)
eventCodes(ii) = Data{precTimeId,'Event Code'};
end
end
You have some heart rate times that come before the first event, so those are left as NaN.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Cardiology 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by