Remove NaN from doubles within a cell array

3 次查看(过去 30 天)
For example, how would I get this:
ab = {[1 2 NaN 3 4];[1 3 4 NaN 5 6 7 NaN]}
to output
ab = {[1 2 3 4];[1 3 4 5 6 7]}
I've tried
ab(cellfun(@(x) all(isnan(x)),ab)) = []
but it doesn't work

采纳的回答

Star Strider
Star Strider 2017-7-7
Try this:
ab = {[1 2 NaN 3 4];[1 3 4 NaN 5 6 7 NaN]};
Output = cellfun(@(x) x(isfinite(x)), ab, 'UniformOutput',false);
Out1 = Output{1} % Display Output (Delete)
Out2 = Output{2} % Display Output (Delete)
Out1 =
1 2 3 4
Out2 =
1 3 4 5 6 7

更多回答(3 个)

Geoff Hayes
Geoff Hayes 2017-7-7
Jonathan - remember that the output of cellfun will be a cell array, so the code that you have above will work i.e. using a cell array as the indices into ab. Try defining a function that will do this for you, creating a function named removeNaNs and saving it to a file named removeNaNs.m
function [ab] = removeNaNs(ab)
ab = cellfun(@(x)removeNaNsPriv(x), ab, 'UniformOutput', false);
function [z] = removeNaNsPriv(z)
z(isnan(z)) = [];
We use the second function (saved within the removeNaNs.m file) as a "helper" function to remove the NaNs from an array. From the command line, you would call this code as
>> ab = {[1 2 NaN 3 4];[1 3 4 NaN 5 6 7 NaN]};
>> removeNaNs(ab)

Walter Roberson
Walter Roberson 2017-7-7
编辑:Walter Roberson 2017-7-7
result = cellfun(@(M) M(~isnan(M)), ab, 'Uniform', 0)

Pruthvi G
Pruthvi G 2020-3-12
ab(cellfun(@(cell) any(isnan(cell(:))),ab))={''};

类别

Help CenterFile Exchange 中查找有关 Logical 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by