Automatically sorting years and quarters in a serial number

Question

Wesso 2023-1-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1902430-automatically-sorting-years-and-quarters-in-a-serial-number

回答： cdawg 2023-1-28

Hi,

I have alarge sample of quarterly data. I have years (example 1990....2022) and quarters (1,2,3,4). How can i generate a serial number that sorts the years and numbers where all firms with year 1990 and quarter 1 will have a value of 1 ; then 1990 quarter 2 will have a value of 2 ....1991,quarter 1 will have a value of 5 etc....

I appreciate your support

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

请先登录，再进行评论。

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

Answer 1

cdawg 2023-1-28

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1902430-automatically-sorting-years-and-quarters-in-a-serial-number#answer_1158605

在 MATLAB Online 中打开

If you know the year you want to start with, I think this could work-

years = [1990 1991 1990 1992 1993 1999 1996];
quarters = [3 1 1 2 1 2 4];
startYr = min(years);
serialNo = 4*(years-startYr)+quarters
serialNo = 1×7
     3     5     1    10    13    38    28
[srt ind] = sort(serialNo);
data = [srt' years(ind)' quarters(ind)']
data = 7×3
           1        1990           1
           3        1990           3
           5        1991           1
          10        1992           2
          13        1993           1
          28        1996           4
          38        1999           2

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

请先登录，再进行评论。

Answer 2

Sulaymon Eshkabilov 2023-1-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1902430-automatically-sorting-years-and-quarters-in-a-serial-number#answer_1158550

One of the easy solutions is to cretae a table array with variable names: Year (numerical) and Quarter (categorical array), e.g. categorical array, e.g. Q1, Q2, Q3, Q4 per year and then by the Q names, you can sort your data.