Reshape data the first row becomes the different columns

Question

Luca 2023-10-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2037321-reshape-data-the-first-row-becomes-the-different-columns

评论： Luca 2023-10-23

Hi, I would like to reshape my data set, that includes different stocks i a year and is in the form of a table. Currently it look like this:

ID Date return

1 01.01.2015 0

1 02.01.2015 0.5

1 03.01.2015 -0.3

. . .

2 01.01.2015 0

2 02.01.2015 0.2

2 03.01.2015 0.5

. . .

The goal would be to have date colum as fist colum and every ID is a separate column. where every row shows returns for every stock in a specific day.

Date ID1 ID2 ID3 ...

01.01.2015 0 0 0

.

31.12.2015 0.2 0.1 0.5

Thank you for your help.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Stephen23 2023-10-23

4
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2037321-reshape-data-the-first-row-becomes-the-different-columns#answer_1338981

在 MATLAB Online 中打开

ID = [1;1;1;2;2;2];
Date = datetime(2015,1,[1;2;3;1;2;3]);
vals = [0;0.5;-0.3;0;0.2;0.5];
T = table(ID,Date,vals)
T = 6×3 table
    ID       Date        vals
    __    ___________    ____

    1     01-Jan-2015       0
    1     02-Jan-2015     0.5
    1     03-Jan-2015    -0.3
    2     01-Jan-2015       0
    2     02-Jan-2015     0.2
    2     03-Jan-2015     0.5
U = unstack(T,'vals','ID', 'VariableNamingRule','preserve')
U = 3×3 table
       Date         1       2 
    ___________    ____    ___

    01-Jan-2015       0      0
    02-Jan-2015     0.5    0.2
    03-Jan-2015    -0.3    0.5