Table, delete columns with zero

Question

newbie9 2019-8-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/477817-table-delete-columns-with-zero

回答： Walter Roberson 2021-7-19

I have a table with many rows and columns. How can I delete a column if any row contains zero? (I found a million ways to delete rows, but not columns, when dealing with tables.)

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

请先登录，再进行评论。

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

Answer 1

newbie9 2019-8-27

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/477817-table-delete-columns-with-zero#answer_389332

编辑：newbie9 2019-8-27

在 MATLAB Online 中打开

Got it; it takes two steps. First repalce zeros with NaN, then can clean it up:

table2 = standardizeMissing(table1, 0); % the 0 is the value to be replaced with NaN
table2 = rmmissing(table2, 2); % the 2 is for deleting rows; use 1 to delete columns

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

seema rehman 2021-7-19

It delete all columns if there is any zero

请先登录，再进行评论。

Answer 2

Walter Roberson 2021-7-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/477817-table-delete-columns-with-zero#answer_749458

在 MATLAB Online 中打开

N = T.Properties.VariableNames;
nvar = length(N);
mask = true(1,nvar);
for K = 1 : nvar
   if isnumeric(T.(N{K})) && any(T.(N{K}) == 0, 'all')
      mask(K) = false;
   end
end
newT = T(:,mask);