How to modify selected rows of one variable in table
조회 수: 16 (최근 30일)
이전 댓글 표시
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일
fun=@(c) interp1(IzeroAugInCell(:,1),IzeroAugInCell(:,2), c);
ListNexafs.uhvI0(tmpMatch) = cellfun(fun, ListNexafs.xRayEkin_eV(tmpMatch) ,'uni' , 0);
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Logical에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!