Groupcount function sort data in alphabetical order

15 次查看(过去 30 天)
Dear MatLab users,
I have a cell array (attached) containing the IDs of my events. I used the groupcount function to see how many instances and how many events I had, and everything seemed to work fine. However, I just found out that the resulting variable containing the events sorted the data in alphabetical order. Thus, the counting also refers to the modified order, which is something I do not want. I managed to find the instances manually, but I also need the list in the original order. Is there a way to do using the groupcount function?
[ N , EVENTS ] = groupcounts(event_id); % EVENTS are in alphabetical order

采纳的回答

Jan
Jan 2022-6-8
编辑:Jan 2022-6-8
% groupcounts sorts the input:
C = {'C', 'C', 'C', 'A', 'A', 'E', 'E', 'E', 'E', 'B'}.';
[N, EVENTS] = groupcounts(C)
N = 4×1
2 1 3 4
EVENTS = 4×1 cell array
{'A'} {'B'} {'C'} {'E'}
% Let N and EVENTS have the same order as in C:
[~, iC] = unique(C); % [EDITED, bug fixed]
[~, q] = sort(iC);
[sN, sEVENTS] = groupcounts(C);
N = sN(q)
N = 4×1
3 2 4 1
EVENTS = sEVENTS(q)
EVENTS = 4×1 cell array
{'C'} {'A'} {'E'} {'B'}
If the equal keys are guaranteed to be neighboring:
% Call this instead of GROUPCOUNTS to keep the order
function [n, b] = RunLength_CStr(x)
x = x(:);
nx = numel(x);
d = [true; ~strcmp(x(1:nx-1), x(2:nx))]; % TRUE if values change
b = x(d); % Elements without repetitions
n = diff(find([d.', true])); % Number of repetitions
end
  4 个评论
Gianluca Regina
Gianluca Regina 2022-6-8
I apologize, as I was writing that it didn't work (the old code gave the same results of groupcounts, so still no alphabetical order) you edited the answer and added the function, which at first glance is not immediate to understand (at least for me). Nonetheless, your code works perfectly now, thank you very much!
Jan
Jan 2022-6-9
There is no need for apologies. You are the only person who needs this function and I spend my time voluntarily to find solutions. Questions for clarifications are a standard part of solving problems.
I'm happy, if it is working now :-)

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Time Series Events 的更多信息

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by