Place blank entries by zeros
1 回表示 (過去 30 日間)
古いコメントを表示
I have a cell type variable with 5000 rows and 8 cells. For example:
a={182 1999 63,8 229 [] 30 [] 1
185 1999 44,5 123 19,7 51 [] []
194 1999 50,7 273 [] 44 [] 1
195 1999 53,2 [] [] [] [] []}
And I would like to substitute the blank entries in the last column only by zero so I would get:
a={182 1999 63,8 229 [] 30 [] 1
185 1999 44,5 123 19,7 51 [] 0
194 1999 50,7 273 [] 44 [] 1
195 1999 53,2 [] [] [] [] 0}
I tried something like this, but is not working:
a(cellfun(@isempty,a(:,8))) = {0};
Can someone help me? Thank you
1 件のコメント
dpb
2014 年 8 月 14 日
Ahhh....my old eyes missed the missing column addressing index...couldn't see the difference at first.
採用された回答
その他の回答 (1 件)
dpb
2014 年 8 月 14 日
a(cellfun(@isempty,a(:,end)),end)={0}
worked here...had to convert the ',' decimal points to '.' to enter the array, however...
0 件のコメント
参考
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!