How to do matching in table format?
2 次查看(过去 30 天)
显示 更早的评论
Hi,
I have some data, putting in a matrix A:-
Col1 = [1;4;0];
Col2 = [2;5;2];
Col3 = [3;6;4];
A = [Col1,Col2,Col3]
I want to extract the rows where column 2 have the value 2 (i.e. c), and also have another output with those values being updated from 2 to 200 (i.e. d).
b=(A(:,2)==2);
c=A(b,:)
d=A;
d(b,2)=200
However, now the data I obtained is a table, instead of a matrix:-
A2 = table(Col1,Col2,Col3)
I tried to use A2 to replace A in the above codes and try to obtain c and d, but I failed.
How can I obtain c and d? Many thanks!
1 个评论
dpb
2018-8-18
If the operations on the data are more convenient as array rather than as separate variables, then create the table variable as an array instead --
A2=table(A);
If there are specific reasons for keeping separate columns because most is column/variable related but there's the occasional array operation, you can retrieve the desired columns as array--
A2=table(Col1,Col2,Col3);
a=A{:,1:3};
and a is the array equivalent to A above to operate on and then put result back into the table.
采纳的回答
Peter Perkins
2018-8-24
b = (A2.col2 == 2); % or A2{:,2) == 2
c = A(b,:) % leave this as a table
d = A2;
d.Col2(b) = 200; % or d{b,2} = 200
There's quite a lot of documentation about table subscripting that will explain all this.
0 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!