How to modify selected rows of one variable in table

3 views (last 30 days)
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 Comments
Matt J
Matt J on 15 Apr 2021
Edited: Matt J on 15 Apr 2021
Is each cell ListNexafs.uhvI0{ii} vector-valued? And are the vectors contained in each cell of different lengths?
ThorBarra
ThorBarra on 15 Apr 2021
Yes, these fields are part of a larger table with cells containing vectors of different length.

Sign in to comment.

Accepted Answer

Matt J
Matt J on 15 Apr 2021
fun=@(c) interp1(IzeroAugInCell(:,1),IzeroAugInCell(:,2), c);
ListNexafs.uhvI0(tmpMatch) = cellfun(fun, ListNexafs.xRayEkin_eV(tmpMatch) ,'uni' , 0);

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Tags

Products


Release

R2020b

Community Treasure Hunt

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

Start Hunting!