How to assign NaN for empty cells in an array?

Question

Natasya Kamarudin 2019-4-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/457341-how-to-assign-nan-for-empty-cells-in-an-array

评论： Natasya Kamarudin 2019-4-23

I need to produce a logical array from two sets of array. The first array (I named here as Icnum) is a 5x1 cell, while the second array (named moga) is a 3x1 cell. How do I make moga into a 5x1 cell and also assigning NaN for the empty cells? Below is the code I have so far:

T=readtable('todaylist.xlsx');
%T.Icnum = {'960521106352';'000202105002';'980719434321';'961212107564';'960116431234'}
moga =  {'960521106352';'961212107564';'950321109876'};
A=size(T.Icnum,1);
D = num2cell((zeros(1,A))) ;
for i = 1:A
    D(i) = moga(i); %error: index exceeds array bounds
    i=i+1;
end
for idx = 1:numel(D)
    D{idx}(cellfun(@isempty, D{idx})) = {nan};
end
Finalanswer=ismember(T.Icnum,D);
T.hadir=(Finalanswer);
writetable(T, 'todaylist.xlsx')

2 个评论
显示无隐藏无

Walter Roberson 2019-4-19

在 MATLAB Online 中打开

moga(end+1:A) = {nan};

Natasya Kamarudin 2019-4-23

Sorry for the late reply. Your code works perfectly. Thank you so much!

请先登录，再进行评论。

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

Answer 1

Andrei Bobrov 2019-4-19

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/457341-how-to-assign-nan-for-empty-cells-in-an-array#answer_371337

Finalanswer = ismember(T.Icnum,moga);

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

Natasya Kamarudin 2019-4-23

在 MATLAB Online 中打开

Not really what I was looking for but thank you for your input. Though I do use this line in the final working code, since I got rid of the variable D:

T=readtable('todaylist.xlsx');
%T.Icnum = {'960521106352';'000202105002';'980719434321';'961212107564';'960116431234'}
moga =  {'960521106352';'961212107564';'950321109876'};
A=size(T.Icnum,1);
moga(end+1:A) = {''};
Finalanswer=ismember(T.Icnum,moga);
T.hadir=(Finalanswer);
writetable(T, 'todaylist.xlsx')