data grouping (like pivot table in excel)
2 views (last 30 days)
Show older comments
Kazi Main Uddin Ahmed
on 22 Jan 2020
Edited: Mohammad Sami
on 23 Jan 2020
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
0 Comments
Accepted Answer
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
0 Comments
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!