data grouping (like pivot table in excel)

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.

\Kazi

Answer 1

[Mohammad Sami]

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