how to replace missing values from a double inside a cell array?

2 views (last 30 days)
I really thanks in advance anybody can tell me how can I replace THE missing values (100000) in the below cell array with NaN.
A = {[1,2,3,100000,4,5,100000],[6,100000,7,100000]};

Accepted Answer

JESUS DAVID ARIZA ROYETH
JESUS DAVID ARIZA ROYETH on 5 Feb 2020
newA=cellfun(@(x) x.*(x~=100000)./(x~=100000),A,'Uni',false)

More Answers (1)

BN
BN on 5 Feb 2020
Edited: BN on 5 Feb 2020
index=find(A==100000); %found 100000 in the A
A(index)=NaN; % Replace them by NaN

Tags

Community Treasure Hunt

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

Start Hunting!