change negative data to zero in one table in matlab

Question

Mounira 2023-11-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2052397-change-negative-data-to-zero-in-one-table-in-matlab

移动：Dyuman Joshi 2023-11-27

Hello,

so i have table with negative values and also with some values above zero but very small, for example: 0.00001 and i want these values to be zero in the table,

can i make some kind of a code or what?

thanks in advance

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

Dyuman Joshi 2023-11-27

移动：Dyuman Joshi 2023-11-27

Find Array Elements That Meet your Condition and assign them to be 0.

请先登录，再进行评论。

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

Answer 1

chicken vector 2023-11-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2052397-change-negative-data-to-zero-in-one-table-in-matlab#answer_1360392

编辑：chicken vector 2023-11-27

在 MATLAB Online 中打开

% Create fictitious set of data:
tableData = rand(1e1) - .5
tableData = 10×10
    0.0662   -0.0633    0.2803    0.0054   -0.2956   -0.0566    0.3033   -0.4808    0.2949   -0.0607
    0.0877    0.3334   -0.1441   -0.2860    0.3349    0.1437   -0.0236   -0.3013    0.1927    0.4607
   -0.0150   -0.4983    0.2688    0.3722   -0.1348   -0.1306   -0.3456    0.2598   -0.2027    0.2677
   -0.3230   -0.2413   -0.4798   -0.0514    0.0638   -0.3500    0.1517    0.2282    0.1698    0.0196
    0.1446   -0.4096   -0.1555   -0.4030   -0.4232   -0.3136   -0.2735    0.3195   -0.0417   -0.3340
    0.3680    0.1401   -0.0174    0.4503   -0.1601    0.3643   -0.1591   -0.3438    0.4963    0.1290
   -0.2027   -0.3589   -0.1596    0.2894    0.0880    0.1945    0.0019    0.4393    0.4007    0.4892
    0.0860   -0.0007    0.4789   -0.4084    0.2700   -0.3130   -0.0826    0.3044   -0.3948   -0.4283
   -0.3233   -0.0831   -0.0646   -0.1759   -0.2096    0.4733    0.2994    0.2015    0.3737   -0.2061
    0.0421    0.4272    0.2534    0.1170    0.3878   -0.1996   -0.3837   -0.1266    0.2738    0.3225
% Define tolerance under which data is set to zero:
tol = 1e-2;
% Udpate table:
tableData(tableData<=tol) = 0
tableData = 10×10
    0.0662         0    0.2803         0         0         0    0.3033         0    0.2949         0
    0.0877    0.3334         0         0    0.3349    0.1437         0         0    0.1927    0.4607
         0         0    0.2688    0.3722         0         0         0    0.2598         0    0.2677
         0         0         0         0    0.0638         0    0.1517    0.2282    0.1698    0.0196
    0.1446         0         0         0         0         0         0    0.3195         0         0
    0.3680    0.1401         0    0.4503         0    0.3643         0         0    0.4963    0.1290
         0         0         0    0.2894    0.0880    0.1945         0    0.4393    0.4007    0.4892
    0.0860         0    0.4789         0    0.2700         0         0    0.3044         0         0
         0         0         0         0         0    0.4733    0.2994    0.2015    0.3737         0
    0.0421    0.4272    0.2534    0.1170    0.3878         0         0         0    0.2738    0.3225