remove missing entries from cell array
29 views (last 30 days)
Show older comments
Hello,
I have a 4x20 cell array where each cell in the array is a 40x1 column vector. The data in this cell array is from Excel. I am trying to remove all of the '1x1 missing' entries in this cell array (i.e. from each of these column vector cells). I tried this but it doesn't work:
new_cell_array{1}= cellfun(@rmmissing,old_cell_array{1},'UniformOutput',false)
new_cell_array ends up being a 40x1 cell. I want new_cell_array to be a 4x20 cell array that is basically just old_cell_array but with the 'missing' entries removed. Any suggestions would be much appreciated
Thank you
0 Comments
Accepted Answer
Jon
on 7 Jul 2022
I think you are close, just use
new_cell_array= cellfun(@rmmissing,old_cell_array,'UniformOutput',false)
4 Comments
Jon
on 7 Jul 2022
The above works fine for the example I constructed, so your error must have to do either with exactly how you wrote the code, maybe even a typo, or something about the exact contents/types etc in your matrix. Without having access to either of those I can't really help you further. I understand that the data is confidential, but if you could just attach an example cell array that demonstrates the problem, but has random values (non-confidential) and attach a small, generic (non-confidential) piece of code that reproduces the problem I might be able to help.
More Answers (0)
See Also
Categories
Find more on Data Type Conversion in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!