deleting numbers in cell array

Question

sam van Bohemen 2020-2-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/507172-deleting-numbers-in-cell-array

评论： sam van Bohemen 2020-3-4

采纳的回答： Robert U

I have a 32x5 cell array.

I want to delete all numbers (+/- 3 either side of each number) that do not appear in every column.

Is there a function that can help me?

Thanks

Sam

6 个评论
显示 4更早的评论隐藏 4更早的评论

Walter Roberson 2020-2-24

Cell arrays generally contain a different size of array for every entry, and might easily contain different data types.

You posted a numeric array, rather than a cell array.

There is no value that appears in every column of your array. The entries 9, 11, 41, 57, 59, 67 each appear only once in the array and so clearly do not appear in every column.

You did not answer my question about the +/-3. You thought you did, but you failed to add any more information than the original. So I have to ask again whether you are referring to horizontal position, or to vertical position, or to range of values. For example because 9 does not appear in every column, does that mean that entries with value 6, 7, 8, 9, 10, 11, 12 should all be deleted?

When values are deleted, what should replace them? Should the adjacent entries "fall down" to fill the hole?

You mentioned cell array before but I have to wonder whether it would be easier to use a numeric array and nan out what you do not want?

Perhaps you are trying to say that a values should be deleted if it is not the case that every column has some entry that is within the range value-3 to value+3? If you are, then I suspect that you think that after the deletions, that it will be the case that all entries of the resulting array will have the property of being within 3 of some entry from each column. However, that would not generally be the case: some of the values you delete for not having a match in every column, will be anchoring values in some columns, so after the deletion more values become unanchored.

Robert U 2020-2-25

在 MATLAB Online 中打开

The description of your problem is ambiguous. It is not clear how your algorithm should work neither the sequential order of commands is clear. I encourage you to describe the desired functionality step-by-step which might help you to write your own code quickly.

From what you wrote (but still not fitting your example values):

Compare the first element of input matrix within its row with all other values.
If all other values of said row are not within first element +/- 3, remove first element (by replacing it with NaN)
Repeat steps 1 & 2 with all other values within input matrix.
Move all remaining values (not NaN) as much rows up keeping the same column as possible without replacing or reordering numerical values.

Example:

dInput = [10  11  10  28  9;    ...
          39  40  41  40  39;   ...
          58  47  58  57  59;   ...
          68  58  68  69  70];
      
dInMin = dInput - 3;
dInMax = dInput + 3;
for numRow = 1:size(dInput,1)
    for numCol = 1:size(dInput,2)
        bRange = dInput(numRow,numCol) >= dInMin(numRow,:) & dInput(numRow,numCol) <= dInMax(numRow,:);
        bRange(numCol) = 0;
        if ~any(bRange)
            dInput(numRow,numCol) = NaN;
        end
    end
end

dInput = [10    11    10   NaN     9
          39    40    41    40    39
          58   NaN    58    57    59
          68   NaN    68    69    70]
      

Does it really make sense to move remaining values up?

Kind regards,

Robert

sam van Bohemen 2020-2-27

I want to find all values (value-3 to value+3) that are not present in every column and then delete these values.

I will try to describe it step-by-step:

Say the matrix is:

10 11 10 28 9

39 40 41 40 39

58 47 58 57 59

68 58 68 69 70

1) starting with the first element of the matrix (10). I want to search the other 4 columns to determine if they all contain a number between 7 and 13 (10-3 and 10+3).

2) column two contains 11, column three contains 10 and column five contains 9. However there is no number between 7 and 13 in column four.

3) therefore I would delete all of these numbers (10 11 10 9).

4) I would then move on to '28'. none of the other columns contain any number between 25 and 31 (28-3 and 28+3). therefore I would delete 28

5) I would then move on to '39'. all five columns contain a number between 36 and 42 (39-3 and 39+3). therefore I would keep all of these numbers (39 40 41 40 39).

6) moving on to '58' all five columns contain a number between 55 and 61 (58-3 and 58+3). therefore I would keep all of these numbers (58 58 58 57 59).

7) moving onto '47' none of the other columns contain a number between 43 and 50 (47-3 and 47+3). therefore I would delete 47.

8) moving onto '68' all columns except column two contain a number between 65 and 71 (68-3 and 68+3). therefore I would delete all of these numbers (68 68 69 70).

9) This would leave me with:

NaN NaN NaN NaN NaN

39 40 41 40 39

58 NaN 58 57 59

NaN 58 NaN NaN NaN

10) I want to make it so all numbers move up when the number above it is deleted so all numers -3 to +3 are in the same row, as below:

39 40 41 40 39

58 58 68 69 70

Hope this make is more clear. Sorry it is so wordy

请先登录，再进行评论。

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

Answer 1

Robert U 2020-3-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/507172-deleting-numbers-in-cell-array#answer_418035

在 MATLAB Online 中打开

Hi sam van Bohemen,

Thank you for your description. I guess the following code will do the trick:

dInput = [10  11  10  28  9;    ...
          39  40  41  40  39;   ...
          58  47  58  57  59;   ...
          68  58  68  69  70];
      
dInMin = dInput - 3;
dInMax = dInput + 3;
for numRow = 1:size(dInput,1)
    for numCol = 1:size(dInput,2)
        bRange = all(any(dInput(numRow,numCol) >= dInMin(:,[1:numCol-1,numCol+1:end]) & dInput(numRow,numCol) <= dInMax(:,[1:numCol-1,numCol+1:end]),1));
        if ~bRange
            dInput(numRow,numCol) = NaN;
        end
    end
end
bRowMoved = true;
while bRowMoved
    for numRow = 2:size(dInput,1)
        bRowMoved = false;
        for numCol = 1:size(dInput,2)
            if isnan(dInput(numRow-1,numCol))
                dInput(numRow-1,numCol) = dInput(numRow,numCol);
                dInput(numRow,numCol) = NaN;
                bRowMoved = true;
            end
        end
    end
    dInput(all(isnan(dInput),2),:) = [];
end

Kind regards,

Robert

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

sam van Bohemen 2020-3-4

Thanks so much Robert, your code worked!

请先登录，再进行评论。

deleting numbers in cell array

6 个评论
显示 4更早的评论隐藏 4更早的评论

采纳的回答

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

deleting numbers in cell array

6 个评论 显示 4更早的评论隐藏 4更早的评论

采纳的回答

1 个评论 显示 -1更早的评论隐藏 -1更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

6 个评论
显示 4更早的评论隐藏 4更早的评论

1 个评论
显示 -1更早的评论隐藏 -1更早的评论