How to rearrange a column by a specific order?
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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!
0 Kommentare
Siehe auch
Kategorien
Mehr zu Model Compatibility finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!