Sort a table by two conditions when one column is not unique
4 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
I need to sort this table by two conditions. I need the maximum F_H_max per POSITION. However the POSITION column is not unique. I also need to retain the vertical coordinate for each max value.
0 Commenti
Risposte (1)
Steven Lord
il 22 Lug 2021
Do you need to sort the table or do you need the maximum value of F_H_max for each value of POSITION? Those are two different things. For the former use sortrows, specifically the "Sort Rows of Table by Variables" example on the documentation page. For the latter use groupsummary, as per the "Summary Statistics" example on the documentation page.
2 Commenti
Vedere anche
Categorie
Scopri di più su Shifting and Sorting Matrices in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!