replace NaN with zeros for several variables in a dataset

Question

Vasquez 2014-7-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/143387-replace-nan-with-zeros-for-several-variables-in-a-dataset

评论： Vasquez 2014-7-26

I have a large dataset with many variables containing NaN. I want to change all the NAN to 0 at once but I've not been able to do so. For instance, for A < 1000000 x 50 dataset> I've tried the following: >> x=find(isnan(A)); which does not work b/c 'isnan' is not defined for datasets

The following works but I have to do it variable by variable >> x=find(isnan(A.VarName)); >> A.VarName(x)=0; I also try to use a loop but have not succeeded.

Any suggestion on how to changes NAN for all dataset at once or for a set of numeric variables at once. Thanks Vasquez

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Azzi Abdelmalek 2014-7-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/143387-replace-nan-with-zeros-for-several-variables-in-a-dataset#answer_146474

编辑：Azzi Abdelmalek 2014-7-26

在 MATLAB Online 中打开

If A is your dataset

B=double(A);
B(isnan(B))=0;
replacedata(A,B)

Or

B=dataset2cell(A)
B(cellfun(@isnan,B))={0}
replacedata(A,B(2:end,:))

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Vasquez 2014-7-26

Thnks Azzi, your first option worked perfectly.

请先登录，再进行评论。

Answer 2

Star Strider 2014-7-25

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/143387-replace-nan-with-zeros-for-several-variables-in-a-dataset#answer_146471

Use datasetfun.

2 个评论
显示无隐藏无

Vasquez 2014-7-26

Using datasetfun still does not work, I’ve used as follow: B=datasetfun(@isnan,A) where A is my dataset. Error message said that isnan for type cell is not defined. Probably does not work because some of my variables are cell string. Thanks for the answer Star

Star Strider 2014-7-26

My pleasure!

You can also use dataset2cell and then cellfun. Changing the NaN values to zero can produce problems in statistical analyses, since zero can be considered valid data while NaN cannot, although I am certain you have considered this.

请先登录，再进行评论。

Answer 3

Ahmet Cecen 2014-7-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/143387-replace-nan-with-zeros-for-several-variables-in-a-dataset#answer_146472

It is surprising that the isnan function is not working, I have been able to use it in similar situation without any problems. How about starting with a zeros matrix B (1000000x50) and pulling isfinite(A) into it, or ischar, or an applicable is function for your dataset. Quite memory intensive and a lazy way to do it. If you elaborate on what exactly your dataset contains, we might be able to suggest better alternatives.

B=zeros(1000000x50); B(isfinite(A))=A(isfinite(A));

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Vasquez 2014-7-26

Thanks for the suggestion Ahmet. Just a background I want to mention that my dataset A has been produced after changing my original dataset from long to wide, that is why several variables are full with NaNs. In the new wide data set, some variables are ‘cell strings’ with no NaNs, other variables are ‘nominal arrays, and the rest are ‘double’ containing large number of NaNs.

请先登录，再进行评论。