remove missing entries from cell array

19 views (last 30 days)
Davindra Usov
Davindra Usov on 7 Jul 2022
Commented: Jon on 7 Jul 2022
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

Answers (1)

Jon on 7 Jul 2022
I think you are close, just use
new_cell_array= cellfun(@rmmissing,old_cell_array,'UniformOutput',false)
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.

Sign in to comment.





Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!