HOW TO SORT DATA IN CELL ARRAY
1 view (last 30 days)
Show older comments
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 Comment
Accepted Answer
Ameer Hamza
on 10 Mar 2020
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 Comments
Ameer Hamza
on 14 Mar 2020
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
More Answers (0)
See Also
Categories
Find more on Shifting and Sorting Matrices in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!