Grouping the data of two variables by sum
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Chinmai Sai
le 11 Nov 2023
Réponse apportée : the cyclist
le 11 Nov 2023
I have a data with 3 columns R, Z, E. E is a function of R and Z. I would like to add the E coulmn for the same value of R and Z. For example, from the data below, I want to add all the E values for R=1 and Z= 3. Can I get some suggestion?
R Z E
1 3 0.5
3 2 0.4
4 1 0.3
1 3 0.1
1 2 0.5
3 2 0.4
3 commentaires
Réponse acceptée
the cyclist
le 11 Nov 2023
R = [1; 3; 4; 1; 1; 3];
Z = [3; 2; 1; 3; 2; 2];
E = [0.5; 0.4; 0.3; 0.1; 0.5; 0.4];
tbl = table(R,Z,E)
groupsummary(tbl,["R","Z"],"sum","E")
0 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Get Started with MATLAB 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!