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
采纳的回答
Mohammad Sami
2020-1-23
编辑：Mohammad Sami
2020-1-23
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
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
