Sorting big data in matlab
조회 수: 4 (최근 30일)
이전 댓글 표시
I have energy data with more than 25 million rows and 3 columns, the data looks like
[meter Id Date+time Load
1000 19506 .5
1000 19501 .5
. . .
1001 19500 .6
. . .
. . .
1999 19509 .4
. . .
1999 73048 .4]
I require to sort this data such that for each meter ID i.e. 1000-1999 (all 1000 meters) i get load arranged in a time series. The first three digit of time code show the day whereas the last two digits range from 0-48 showing 24 hours every half hours. I can sort the data according to meter ID but this does not arrange it according to time series. I am struggling to find a solution to find a technique to auto arrange the data such that it presents something like this;
meter ID 1000 [19501 19502 .......................... 73048 .5 1.5............................ 2.5] and so on for all meter IDs. It is easy to solve in excel using filters, however given the amount of data, excel is not able to open this file. Any recommendation.
댓글 수: 0
채택된 답변
Walter Roberson
2017년 2월 2일
sortrow(YourData, [1 2])
댓글 수: 2
Walter Roberson
2017년 2월 2일
Ah, I was able to find a way to do it without any explicit loops:
[unique_ids, ~, uidx] = unique(sorted_rows(:,1));
grouped_rowidx = accumarray( uidx, (1:size(sorted_rows,1)), [], @(R) {R}, {});
grouped_rows = cellfun(@(R) sorted_rows(R,:), grouped_rowidx, 'Uniform', 0);
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Shifting and Sorting Matrices에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!