HOW TO SORT DATA IN CELL ARRAY

1 次查看（过去 30 天）

显示更早的评论

Akshay Sahu 2020-3-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/510139-how-to-sort-data-in-cell-array

评论： Akshay Sahu 2020-3-14

采纳的回答： Ameer Hamza

在 MATLAB Online 中打开

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Luna 2020-3-10

编辑：Luna 2020-3-10

why are you using cell arrays inside cell arrays? What makes you understand which part belongs to B and which belongs to C?

请先登录，再进行评论。

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

采纳的回答

Ameer Hamza 2020-3-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/510139-how-to-sort-data-in-cell-array#answer_419498

在 MATLAB Online 中打开

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 个评论
显示 11更早的评论隐藏 11更早的评论

Ameer Hamza 2020-3-14

在 MATLAB Online 中打开

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