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!