Replace NaN values with values based on same group and other group?

Question

Kyle Campbell 2016-9-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/302838-replace-nan-values-with-values-based-on-same-group-and-other-group

评论： Kyle Campbell 2016-9-13

table (650,000x20)
customerID group
cost group (NaN values throughout)

The table contains 5-7 data lines for each customerID that have the same cost except for one or two NaN cost values. It is obvious to replace the NaN values with the same other given cost values associated with the ID. But I am having trouble.

I was thinking:

Table.cost(isnan(Table.cost)) = Table.customerID(mode(Train.cost));

But this would apply to the entire rather than correct customerID?

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

请先登录，再进行评论。

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

Answer 1

Teja Muppirala 2016-9-13

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/302838-replace-nan-values-with-values-based-on-same-group-and-other-group#answer_234597

在 MATLAB Online 中打开

I think this should work.

 % Sample data
 T = cell2table({'ID1' 100 'aaa';  
                  'ID1' nan 'bbb';
                  'ID1' nan 'ccc';
                  'ID2' 200 'ddd';
                  'ID2' nan 'eee';},'VariableNames',{'customerID','cost','otherStuff'})
% Replace the NaNs with the mode of that group          
G = findgroups(T.customerID);
val = splitapply(@(x){mode(x)*ones(size(x))},T.cost,G);
T.cost = cat(1,val{:}) % <----- Fixed now