Read a data set and bin it to different groups.

Question

anton fernando 2014-7-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/142308-read-a-data-set-and-bin-it-to-different-groups

评论： anton fernando 2014-7-18

2004017     2004018     2004018   2006019     2004019   2004017    2004018     2004018     2005019     2004019   2004017     2004018   2004018    2008019     2004019

The first four numbers of each data give the year. I want to bin the data according to their years. How should I do that? if the year is 2004 assign it to an array T1. if the year is 2005 assign it to an array T2. So on.

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

请先登录，再进行评论。

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

Answer 1

Rick Rosson 2014-7-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/142308-read-a-data-set-and-bin-it-to-different-groups#answer_145529

在 MATLAB Online 中打开

   A = [   List of numbers    ];
   x = floor(A/1000);
   T1 = A( x == 2004 );
   T2 = ...
   ...

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

anton fernando 2014-7-18

Thank you very much. Similarly how can I do that for the last 3 digits in the numbers. I want to read last 3 digits and bin them to intervals. If last 3 digits in between 0-5, 5-10, 10-15 so on.

请先登录，再进行评论。

Answer 2

Azzi Abdelmalek 2014-7-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/142308-read-a-data-set-and-bin-it-to-different-groups#answer_145531

在 MATLAB Online 中打开

a=[2004017 2004018 2004018 2006019 2004019 2004017 2004018 2004018 2005019 2004019 2004017     2004018 2004018 20084019 2004019]
b=arrayfun(@num2str,a,'un',0)
c=cellfun(@(x) str2num(x(1:4)),b)
[ii,jj,kk]=unique(c)
idx=arrayfun(@(x) find(ismember(c,x)),ii,'un',0)
out=cellfun(@(x) a(x),idx,'un',0)
celldisp(out)