How to rearrange a column by a specific order?

3 vues (au cours des 30 derniers jours)
MKM
MKM le 11 Oct 2021
Commenté : KSSV le 11 Oct 2021
Lets say i have a table:
IDname | IDnumber | version | status
x1 | 1 | v1 | backlog
x2 | 1 | v1 | Done
x3 | 1 | v1 | verify
x4 | 1 | v1 | Done
x5 | 1 | v1 | backlog
x6 | 1 | v1 | verify
x7 | 1 | v1 | verify
I want to be able to group and reorder column "Status" like this:
IDname | IDnumber | version | status
x1 | 1 | v1 | backlog
x5 | 1 | v1 | backlog
x3 | 1 | v1 | verify
x6 | 1 | v1 | verify
x7 | 1 | v1 | verify
x2 | 1 | v1 | Done
x4 | 1 | v1 | Done
I thought you would categorical the column and try sort it using some like this
datanew = categorical(data.Status, {'backlog', 'verify', 'done'}
but this doesnt seem to work..
Cheers!

Réponses (1)

KSSV
KSSV le 11 Oct 2021
How about using sort?
s = [{'Done' }
{'verify' }
{'Done' }
{'backlog' }
{'verify' }
{'verify' }] ;
s = sort(s)
You can access that column using T.status, where T is your table and status is your column.
  2 commentaires
MKM
MKM le 11 Oct 2021
Modifié(e) : MKM le 11 Oct 2021
doesnt this only sort the data by alphabetical roder? I am looking for a specific pattern, not alphabetical.

Connectez-vous pour commenter.

Catégories

En savoir plus sur Shifting and Sorting Matrices dans Help Center et File Exchange

Produits


Version

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by