unstack
unstack(t,vars,ivar) returns the unstacked table corresponding to the table t.
- vars (string): column that will be used to fill the output table
- ivar (string): the index column. Its (unique) values will define the output column names
Examples
>> t = table({'1-11';'2-11';'1-11';'2-11'}, {'A';'B';'B';'A'}, [5;10;15;7], 'VariableNames', {'date', 'id', 'price'})# date id price 1-11 A 5 2-11 B 10 1-11 B 15 2-11 A 7 >> U = unstack(t,'price','id')# date A B 1-11 5 15 2-11 7 10
>> ticker = {'x1';'x1';'x2';'x2';'x3';'x3';'x3';'x3'} date = {'20160731';'20160730';'20160731';'20160730';'20160731';'20160730';'20160729'; '20160729'} value = [10;12;9;5;-2;17;-3;20] t = table(ticker,date,value) unstack(t,'value','ticker',[], @mean)# date x1 x2 x3 20160729 NaN NaN 8.5 20160730 12 5 17 20160731 10 9 -2