Matlab: organize a great number of data based on month, day and hourly intervals

Question

elisa ewin 2016-6-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/290264-matlab-organize-a-great-number-of-data-based-on-month-day-and-hourly-intervals

评论： elisa ewin 2016-6-16

SetOfDataset.mat

Hi! I have a problem and I'm not able to find a smart solution. I explain it in short: I have a great number of user's sequence of location records and I have clustered them with cluster alghoritm optics. After find the cluster, I find the sequences of location records in every cluster. They are included in SetOfDataset (attached) end that is a struct 1x50, where 50 is the number of the cluster. Every sequence of locations has = [userId year month day hour minutes seconds latitude longitude locationID]

I want to divide this sequences based on month, day and, after identified the days, I want to divide them in intervals of 2 hours.

I have try to use nested struct but the code is terrible: slow, not clear the results... I want to do something of easy but I can't find smart ideas: can you help me?

2 个评论
显示无隐藏无

Guillaume 2016-6-16

编辑：Guillaume 2016-6-16

"I want to divide this sequences based on month, day and, after identified the days, I want to divide them in intervals of 2 hours."

So what sort of output are you looking for for a given cluster?

elisa ewin 2016-6-16

I want like output a struct (not nested) that have all the sequences with same day and month divided in interval of 2 hours

请先登录，再进行评论。

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

Answer 1

Guillaume 2016-6-16

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/290264-matlab-organize-a-great-number-of-data-based-on-month-day-and-hourly-intervals#answer_225702

在 MATLAB Online 中打开

It's not clear what final output you're looking for. Something like this:?

for setidx = 1 : numel(SetOfDataset)
   points = SetOfDataset(setidx).points;
   %divide date/hour in groups of two hours:
   [~, ~, dateid] = unique([points(:, 2:4), floor(points(:, 5)/2)], 'rows', 'stable'); %'stable' optional 
   %use that to split the point array into cell arrays
   SetOfDataset(setidx).splitpoints = arrayfun(@(did) points(did == dateid, :), [1:max(dateid)]', 'UniformOutput', false);
 end