Making a plot to find out when, during a 24 hour period, two rows in excel has the same value.
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
回答(1 个)
Bob Thompson
2019-2-6
编辑: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.
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!