Grouping Variables using rowfun Function Rearranging Order to Alphabetical

8 次查看（过去 30 天）

显示更早的评论

Jay 2019-7-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/473136-grouping-variables-using-rowfun-function-rearranging-order-to-alphabetical

评论： Jay 2019-7-25

采纳的回答： Walter Roberson

ML_Q_2.xlsx

How does one keep the original sequencing of variables used for matching in the rowfun?

% Guillaume's Code from Prior Question
data = readtable('ML_Q_3.xlsx', 'ReadVariableNames', false);
%optionally, give better name to the variables of the table
%data.Properties.VariableNames = {'???', '????'}
data = rmmissing(data);  %get rid of empty rows
sorted = rowfun(@(v) {v}, data, 'GroupingVariables', 1);  %group column 2 by column 1

The resulting sorted names are in alphabetical order (col 1) ['A','B','F','R','X'] .

Where I require it to be per the original ['B','F','R','X','A'] .

I can not find anything in the documentation rowfun how to specify to keep the original order.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Walter Roberson 2019-7-24

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/473136-grouping-variables-using-rowfun-function-rearranging-order-to-alphabetical#answer_384453

unique() with 'stable' option. Take the third output and use it as the grouping for splitapply()

8 个评论
显示 6更早的评论隐藏 6更早的评论

Walter Roberson 2019-7-24

Stephen's elaboration of what I wrote is correct. You need the third of the three possible outputs from unique() in order to use as the grouping variable for splitapply()

Jay 2019-7-25

data = readtable('ML_Q_2_2.xlsx', 'ReadVariableNames', false);
data = rmmissing(data);  %get rid of empty rows
[~,~,X] = unique(data,'stable')
output = splitapply(@sum,data, X) % Error returned