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!