HOW TO SORT DATA IN CELL ARRAY
조회 수: 1 (최근 30일)
이전 댓글 표시
A {1x4}
Such that
A = {A{1,1},A{1,2},A{1,3},A{1,4}}
A{1,1}={}
A{1,2}={0.5 0.2
1 2
3 4
NaN NaN
5 6
7 8
9 10
NaN NaN}
A{1,3}={0.5 0.8
5 6
7 8
9 10
NaN NaN
11 12
13 14
15 16
17 18
NaN NaN}
A {1,4} = {0.7 0.9
19 20
NaN NaN
25 26
27 28
29 30
31 32
NaN NaN}
I want to separate data when there is NaN NaN in the matrix, want to store values before first NaN NaN in one cell array and after NaN NaN in another cell array.
B1 = {A{1, 2}(1:3,:))}
B2 = {A{1, 3}(1:4,:))}
B3 = {A{1, 4}(1:2,:))}
C1 = {A{1, 2}(5:7,:)}
C2 = {A{1, 3}(6:9,:)}
C3 = {A{1, 4}(4:7,:)}
B = {{B1},{B2},{B}}
C = {{C1},{C2},{C3}}
댓글 수: 1
채택된 답변
Ameer Hamza
2020년 3월 10일
Are you looking for something like this code? Note that I have made some modifications to the datatypes and removed A{1,1} = {}, since it makes the code simpler. This code will work as long as there are two nan rows in the matrix.
A{1,1}=[0.5 0.2
1 2
3 4
NaN NaN
5 6
7 8
9 10
NaN NaN];
A{1,2}=[0.5 0.8
5 6
7 8
9 10
NaN NaN
11 12
13 14
15 16
17 18
NaN NaN];
A{1,3} = [0.7 0.9
19 20
NaN NaN
25 26
27 28
29 30
31 32
NaN NaN];
nan_rows = cellfun(@(x) find(isnan(x), 2), A, 'UniformOutput', 0);
B = cellfun(@(x, y) x(1:y(1)-1, :), A, nan_rows, 'UniformOutput', 0);
C = cellfun(@(x, y) x(y(1)+1:y(2)-1, :), A, nan_rows, 'UniformOutput', 0);
댓글 수: 13
Ameer Hamza
2020년 3월 14일
Try this. B is a cell array of cell arrays. See the result with indexing like this: B{1}{1}, B{1}{2}, B{2}{1}, ....
A{1,1}=[0.5 0.2
1 2
3 4
NaN NaN
5 6
7 8
9 10
NaN NaN
0.5 0.2
1 2
3 4
NaN NaN];
A{1,2}=[0.5 0.8
5 6
7 8
9 10
NaN NaN
11 12
13 14
15 16
17 18
NaN NaN
0.5 0.8
5 6
7 8
9 10
NaN NaN];
A{1,3} = [0.7 0.9
19 20
NaN NaN
25 26
27 28
29 30
31 32
NaN NaN
0.7 0.9
19 20
NaN NaN];
total_nan_rows = sum(isnan(A{1}(:,1)));
nan_rows = cellfun(@(x) find(isnan(x), total_nan_rows), A, 'UniformOutput', 0);
for i=1:total_nan_rows
if i==1
B{i} = cellfun(@(x, y) x(1:y(i)-1, :), A, nan_rows, 'UniformOutput', 0);
elseif i==total_nan_rows
B{i} = cellfun(@(x, y) x(y(i-1)+1:end-1, :), A, nan_rows, 'UniformOutput', 0);
else
B{i} = cellfun(@(x, y) x(y(i-1)+1:y(i)-1, :), A, nan_rows, 'UniformOutput', 0);
end
end
추가 답변 (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!