How to modify selected rows of one variable in table
5 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
Matt J
le 15 Avr 2021
fun=@(c) interp1(IzeroAugInCell(:,1),IzeroAugInCell(:,2), c);
ListNexafs.uhvI0(tmpMatch) = cellfun(fun, ListNexafs.xRayEkin_eV(tmpMatch) ,'uni' , 0);
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!