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!