How to modify selected rows of one variable in table

Question

ThorBarra 2021-4-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/802951-how-to-modify-selected-rows-of-one-variable-in-table

评论： ThorBarra 2021-4-15

采纳的回答： Matt J

在 MATLAB Online 中打开

Hi there,

Is there a way to code the following more elegantly? What this loop does is to

select rows from a table based on some criteria
then does some calculation on data in each row of that selection
writes the result into a new variable in that table (in that specific row)

% ListNexafs is a table and here I select a set of rows that meet these
% criteria. tmpMatch is a logical array:
tmpMatch  = (month(ListNexafs.lastModifiedDatenum) == 8) &...
        (year(ListNexafs.lastModifiedDatenum) == 2020);
% for each line of the tabe
for ii = 1:size(ListNexafs,1) 
%     if that line meets the criteria above (logical is 1)
    if tmpMatch(ii)
%         I do some calculations. IzeroAugInCell(:,1) and (:,2) are doubles
%         array. 
        ListNexafs.uhvI0{ii} = interp1(IzeroAugInCell(:,1),IzeroAugInCell(:,2),ListNexafs.xRayEkin_eV{ii});
    end
end

This works. But its not so elegant. Could this be done with cellfun (even though, IzeroAugInCell are not cells)? Or is there another way to get rid of the nested for and if ? Thanks for any help, Thorsten

2 个评论
显示无隐藏无

Matt J 2021-4-15

编辑：Matt J 2021-4-15

Is each cell ListNexafs.uhvI0{ii} vector-valued? And are the vectors contained in each cell of different lengths?

ThorBarra 2021-4-15

Yes, these fields are part of a larger table with cells containing vectors of different length.

请先登录，再进行评论。

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

Answer 1

Matt J 2021-4-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/802951-how-to-modify-selected-rows-of-one-variable-in-table#answer_675921

在 MATLAB Online 中打开

fun=@(c) interp1(IzeroAugInCell(:,1),IzeroAugInCell(:,2), c);
ListNexafs.uhvI0(tmpMatch) = cellfun(fun, ListNexafs.xRayEkin_eV(tmpMatch)  ,'uni' , 0);