Making a plot to find out when, during a 24 hour period, two rows in excel has the same value.

Question

Karl-Axel Ruuth 2019-2-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/443570-making-a-plot-to-find-out-when-during-a-24-hour-period-two-rows-in-excel-has-the-same-value

编辑： Bob Thompson 2019-2-6

Hello

I have two rows of data in excel that was recorded on two seperate days with a sample time of 6 seconds, as seen in the image below. I was wondering if there's a way to plot a graph in matlab, with 24 hours and sample time of 6 seconds on the x-axis, so that I can see when the data from the two days intersects and have the same value.

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

请先登录，再进行评论。

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

Answer 1

Bob Thompson 2019-2-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/443570-making-a-plot-to-find-out-when-during-a-24-hour-period-two-rows-in-excel-has-the-same-value#answer_359838

编辑：Bob Thompson 2019-2-6

Do you specifically need to plot the results? Why not just use logic indexing?

t = data(:,ismember(data(:,2:3,1),data(:,2:3,2)),1); % Note that I assumed your
                                                     % data was put in a 3D array
                                                     % called 'data' which 
                                                     % contains your image as the
                                                     % first
                                                     % and second dimensions,
                                                     % with each day as the third
                                                     % dimension. 
                                                     % Modify as needed.