How do i find repeating sample with different value in data and replace the value with its average?
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Samson David Puthenpeedika
le 12 Fév 2022
Commenté : Samson David Puthenpeedika
le 12 Fév 2022
In the file "air.mat" , contains a matrix named data, in which the first column is the energy (MeV) and the second column
represents the connected mass attenuation coefficient.
There is two same energy values with different mass attenuation coefficient. How do i find those same energy values and replace it with the average of the mass attenuation coefficient of both energies.
I tried using unique() but it doesnt give the output that i need i need
x=load("air.mat");
c=unique(x.data(:,1))
This is just removing the repeating energy value from data.
0 commentaires
Réponse acceptée
Simon Chan
le 12 Fév 2022
Try this:
T = table(data(:,1),data(:,2),'VariableNames',{'Energy','mass_attentuation_coefficient'});
G = groupsummary(T,"Energy","mean");
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Solver Outputs and Iterative Display 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!