# How to modify selected rows of one variable in table

10 ビュー (過去 30 日間)
ThorBarra 2021 年 4 月 15 日 11:42
コメント済み: ThorBarra 2021 年 4 月 15 日 16:10
Hi there,
Is there a way to code the following more elegantly? What this loop does is to
1. select rows from a table based on some criteria
2. then does some calculation on data in each row of that selection
3. 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 件のコメント表示非表示 1 件の古いコメント
ThorBarra 2021 年 4 月 15 日 16:10
Yes, these fields are part of a larger table with cells containing vectors of different length.

サインインしてコメントする。

### 採用された回答

Matt J 2021 年 4 月 15 日 12:02
fun=@(c) interp1(IzeroAugInCell(:,1),IzeroAugInCell(:,2), c);
ListNexafs.uhvI0(tmpMatch) = cellfun(fun, ListNexafs.xRayEkin_eV(tmpMatch) ,'uni' , 0);
##### 1 件のコメント表示非表示 なし
ThorBarra 2021 年 4 月 15 日 16:10
Works like a charme. Again, something learned! Merci.

サインインしてコメントする。

R2020b

### Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by