how to remove all the value zero in column 2?

Question

RACHEL LYN JAHIRIN 2023-11-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2048087-how-to-remove-all-the-value-zero-in-column-2

评论： Dyuman Joshi 2024-2-25

MTLv2.m

hi, i am new in matlab. can someone help me on how to remove of the zero value in column 2 of database as shown above? can see the coding attach. thankyou so much!

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

请先登录，再进行评论。

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

Answer 1

Dyuman Joshi 2023-11-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2048087-how-to-remove-all-the-value-zero-in-column-2#answer_1353867

编辑：Dyuman Joshi 2023-11-16

在 MATLAB Online 中打开

%Example
A = num2cell([0;rand(10,1);0;0;rand(5,1);0;0;0;1]);
B = num2cell(char(randi([30 50], numel(A), 1)));
C = [B A]
C = 22×2 cell array
    {'('}    {[     0]}
    {'.'}    {[0.7471]}
    {'#'}    {[0.2366]}
    {'"'}    {[0.2619]}
    {'□'}    {[0.6682]}
    {'&'}    {[0.3394]}
    {'"'}    {[0.4581]}
    {'('}    {[0.4928]}
    {'''}    {[0.1664]}
    {'+'}    {[0.4145]}
    {','}    {[0.6213]}
    {'#'}    {[     0]}
    {'/'}    {[     0]}
    {'*'}    {[0.9919]}
    {'2'}    {[0.4193]}
    {','}    {[0.4106]}
%Find zeros in the 2nd column of the cell array
idx = cellfun(@(x) ~x, C(:,2));
%Remove them
C(idx, 2) = {[]}
C = 22×2 cell array
    {'('}    {0×0 double}
    {'.'}    {[  0.7471]}
    {'#'}    {[  0.2366]}
    {'"'}    {[  0.2619]}
    {'□'}    {[  0.6682]}
    {'&'}    {[  0.3394]}
    {'"'}    {[  0.4581]}
    {'('}    {[  0.4928]}
    {'''}    {[  0.1664]}
    {'+'}    {[  0.4145]}
    {','}    {[  0.6213]}
    {'#'}    {0×0 double}
    {'/'}    {0×0 double}
    {'*'}    {[  0.9919]}
    {'2'}    {[  0.4193]}
    {','}    {[  0.4106]}

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

Dyuman Joshi 2023-11-16

编辑：Dyuman Joshi 2023-11-17

在 MATLAB Online 中打开

"how if i want to remove all the row that has zero value in column 2?"

@RACHEL LYN JAHIRIN, In that case try this -

%Example
A = num2cell([0;rand(10,1);0;0;rand(5,1);0;0;0;1]);
B = num2cell(char(randi([30 50], numel(A), 1)));
C = [B A]
C = 22×2 cell array
    {'*'}    {[     0]}
    {'/'}    {[0.9376]}
    {'&'}    {[0.3174]}
    {','}    {[0.2807]}
    {'$'}    {[0.7568]}
    {')'}    {[0.3109]}
    {'#'}    {[0.0463]}
    {')'}    {[0.1515]}
    {'□'}    {[0.2197]}
    {' '}    {[0.6444]}
    {'0'}    {[0.5528]}
    {'*'}    {[     0]}
    {'0'}    {[     0]}
    {'&'}    {[0.4588]}
    {'2'}    {[0.9759]}
    {'$'}    {[0.3307]}
%Find zeros in the 2nd column of the cell array
idx = cellfun(@(x) ~x, C(:,2));
%Remove them
C(idx, :) = []
C = 16×2 cell array
    {'/'}    {[0.9376]}
    {'&'}    {[0.3174]}
    {','}    {[0.2807]}
    {'$'}    {[0.7568]}
    {')'}    {[0.3109]}
    {'#'}    {[0.0463]}
    {')'}    {[0.1515]}
    {'□'}    {[0.2197]}
    {' '}    {[0.6444]}
    {'0'}    {[0.5528]}
    {'&'}    {[0.4588]}
    {'2'}    {[0.9759]}
    {'$'}    {[0.3307]}
    {'+'}    {[0.7091]}
    {'0'}    {[0.4961]}
    {','}    {[     1]}