Clearing rows in dataset arrays

Question

Adam Clark 2012-5-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/39766-clearing-rows-in-dataset-arrays

I am working with nx5 heterogeneous dataset arrays imported from Excel which has some rows containing empty cells. Normally when I work with cell arrays I can eliminate these excess rows by using:

A(strcmp(A, '' ))=[];

When I try this and other variants I get an error stating 'Dataset array subscripts must be two-dimensional'. I have tried other variations using functions such as datasetfun() with no luck. If any one has any thoughts or suggestions I would really appreciate it.

Thanks, Adam

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

请先登录，再进行评论。

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

Answer 1

Tom Lane 2012-5-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/39766-clearing-rows-in-dataset-arrays#answer_49434

在 MATLAB Online 中打开

That's because you can't delete individual "cells" from a dataset array. You need to delete entire rows. (Besides that, strcmp won't work as you want on a dataset.) For example, you could do this to delete rows where Var1 is an empty string:

A(strcmp(A.Var1,''),:) = [];

I can't think of a simple way to do this for all columns except by looping over them.