Replace NaN with zeros in cell array in MATLAB

Question

I have a 50x25 cell array in the variable raw_data. Each cell contains a 200x150 matrix. I have a few NaN values scattered between all those values and I want to set them to zeros to make sure they do not interfere at later stages.

I have tried the following:

raw_data(cellfun(@(x) any(isnan(x), raw_data, 'UniformOutput', false)) = 0

When running the script, I get "Function 'subindex' is not defined for values of class 'cell'". Can anyone help me, please?

Thanks in advance!

Probably the best way is to use a for loop

Luis Mendo
– Luis Mendo

2015-01-15 10:06:18 +00:00
Commented Jan 15, 2015 at 10:06 — Luis Mendo
– Luis Mendo, Commented Jan 15, 2015 at 10:06

Dan · Accepted Answer · 2015-01-15 10:19:18Z

4

How about this:

cellfun(@(x) nansum(x,ndims(x)+1), raw_data, 'UniformOutput', false)

Note if you're certain you'll only have 2D matrices in raw_data you can replace the ndims(x)+1 with 3.

The idea is to use nansum to sum along the 3rd dimension as this will preserve the shape of the first 2 dimensions and luckily nansum seems to convert NaN to 0 when all the elements being summed are NaN

answered Jan 15, 2015 at 10:19

Dan

45.8k20 gold badges98 silver badges169 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dan Over a year ago

Also you can shorten 'UniformOutput', false to 'uni',0 if you like. In fact I think you can even do 'u',0

Collectives™ on Stack Overflow

Replace NaN with zeros in cell array in MATLAB

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related