Loop to compare values from the table

8 次查看（过去 30 天）

Izabela Nowaczynska 2020-4-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/515154-loop-to-compare-values-from-the-table

评论： Izabela Nowaczynska 2020-4-24

I try to create to compare data. I have to tables and i need to compare dates (year, month and day). Each data type is in different column. I try to make a loops to compare first years, second month and for last day and if the dates in both tables are the same I want to have value from another column from one of the table (second one). The value that loop find I need in first Table (from table twl column 7). It could happens that in first table dates are repeated but I still need this values repeated.

Can you help me solve this problem?

My code :

for i = 1:nummel(t21) 
           for j = 1:nummel(twl)
    
                if  isequal(t21(i,15), twl(j,1))
                    
                    if  isequal(t21(i,16), twl(j,2))
                     
                     if  isequal(t21(i,17), twl(j,3))
                                    fprintf('Found! \n') 
                            for j
                                fprintf('\r\n %04d' twl(i,7))
                            end
                     end
                    end
                end
           end
          

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

dpb 2020-4-6

在 MATLAB Online 中打开

"I can't decipher what in the two variables is which variable..."

Well, going back to the first, I guess I've determined that the one time data are t21(:,15:17) and the other are twl(:,1:3).

So,

dtt21=datetime(t21(:,15:17));      % datetime array for the t21 data
dttwl=datetime(twl(:,1:3));        % ditto for twl

Now

[ia,ib]=ismember(dtt21,dttw1);     % find locations of matching times t21 in tw1
data=tw1(ib,7);                    % the matching locations column 7 data from the second