I am trying to isolate the userdata associated with a time within a table and create an new table from the rows the of enteries associated with the selected time from the original table

Question

Nichelle'Le Carrington 2016-4-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/280127-i-am-trying-to-isolate-the-userdata-associated-with-a-time-within-a-table-and-create-an-new-table-fr

回答： Nichelle'Le Carrington 2016-4-23

I am trying to store the if true % Create a sample table ID = [38;43;38;40;49]; Date = {'02/03/2005'; '02/04/2005'; '02/05/2005'; '02/06/2005'; '02/07/2005'}; Time = {'22:00:00-06:00' ; '23:00:00-06:00'; '21:00:00-06:00'; '23:00:00-06:00'; '20:00:00-06:00'}; UserData = [124; 109; 125; 117; 122]; T = table(ID,Date,Time,UserData); A = table; % Iterate through rows of table for i = 1:1:height(T) % Check if first two characters are 23 if strcmp(T.Time{i}(1:2), '23') % Return the rows with 23 to a new table ids1 = find(T.Time(:,1)==23) ; for iii = 1:numel(ids1) A = [A; Tk(ids1(iii),:)]; end disp(i); end end

end

The string comparison is unable to return the rows into the new table A.

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

请先登录，再进行评论。

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

Answer 1

Bharath Rangaswamy 2016-4-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/280127-i-am-trying-to-isolate-the-userdata-associated-with-a-time-within-a-table-and-create-an-new-table-fr#answer_219054

在 MATLAB Online 中打开

Hi Nichelle,

I understand that your what to copy the rows with time '23:00:00-06:00' to A.

you can do it in the following way:

ID = [38;43;38;40;49];
Date = {'02/03/2005'; '02/04/2005'; '02/05/2005'; '02/06/2005'; '02/07/2005'}; 
Time = {'22:00:00-06:00' ; '23:00:00-06:00'; '21:00:00-06:00'; '23:00:00-06:00'; '20:00:00-06:00'}; 
UserData = [124; 109; 125; 117; 122]; 
T = table(ID,Date,Time,UserData); 
ids1 = find(strcmp(T.Time(:,1),'23:00:00-06:00'));%finding all the rows with '23:00:00-06:00'
A = T(ids1,:);%Coppy those row in to A