Rowfun without changing the order
4 views (last 30 days)
Show older comments
I want to use rowfun but I don't want the resulting outcome to be sorted according to the grouping variables that I specify. I want them to stay in their original ordering.
Or alternatively, reordering the resulting outcome as I want could also solve my problem. But as I lose the variable that I want to order my table accordingly after I get results from rowfun, I can't do that either.
2 Comments
dpb
on 17 Jan 2021
You can use a function with multiple outputs and pass through the other variable as an additional input/output.
You can't do that with an anonymous function in rowfun however, will have to write the m-file code.
dpb
on 17 Jan 2021
I didn't catch it was you asking the same question altho recognized the same issue...
The above works only for another auxiliary variable and cannot work uniquely if the auxiliary variable is not unique across the group.
Other than you could save the elements of the group in a cell array of the proper height, but there's still no ordering the output itself; just a collection of which of the auxiliary variable values are contained in the collection of the group.
Answers (1)
Roee Ronkin
on 18 Jul 2024
How about adding another variable which is the original line number? Then u can always sort back to this order
0 Comments
See Also
Categories
Find more on Shifting and Sorting Matrices in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!