MATLAB Answers

data grouping (like pivot table in excel)

3 views (last 30 days)
I have a Table with 10 attributes (a screenshot is attached).
I need to count the 'event_type' on each day (from 1 to 30) like the pivot table in excel.
Is there any way to do that in matlab
NOTE: i can not use excel with this dataset because of the total row number and also try to use 'pivotable.m' from file exchange but can not use becuase if I convert table to cell header dissappeared.
Thanks in advance.


Sign in to comment.

Accepted Answer

Mohammad Sami
Mohammad Sami on 23 Jan 2020
Edited: Mohammad Sami on 23 Jan 2020
You can use the groupsummary function to summarize your data.
%data = yourdata
out = groupsummary(data,{'Date' 'event_type'});
% this will summarise the counts for all combinations of event_type and 'Date'
% out = groupsummary(data,{'Year' 'Month' 'Date' 'event_type'});
% above will summarise for every day of the year


Sign in to comment.

More Answers (0)

Sign in to answer this question.