How do I use the group summary/unstack function in this script?
1 view (last 30 days)
Show older comments
This is my script:
date1 = datetime(2020,10,12,'Format','yyyy/MM/dd');
date2 = datetime(2020,10,15,'Format','yyyy/MM/dd');
Date = [date1;date1;date1;date2];
Concept = ["Petrol";"Woolworths";"ALDI";"Opal Card"]; T
ype = ["Credit";"Savings";"Cash";"Credit"];
Category = ["Car";"Groceries";"Groceries";"Transportation"]
; Amount = [55;63;15;20];
T = table(Date,Concept,Type,Category,Amount)
It looks like this
I am trying to create another table to reflect these results:
I tried using groupsummary function but it would only allow me to use the variables of the columns and not the two dates I need.
Is anyone able to point me in the right direction?
0 Comments
Answers (1)
Seth Furman
on 16 Oct 2020
Take a look at the following documentation example for unstack, which closely resembles your problem.
0 Comments
See Also
Categories
Find more on Tables 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!