Deleting certain rows with partially duplicate values

T = table( ...
    [1;1;3;6;2;2], ...
    ["March-1st";"March-1st";"March-5th";"March-8th";"April-3rd";"April-3rd"], ...
    [2;3;8;4;5;0], ...
    ["RED";"GREEN";"GREEN";"GREEN";"RED";"GREEN"], ...
    'VariableNames',["A","B","C","D"])
T = 6×4 table
    A         B         C       D   
    _    ___________    _    _______

    1    "March-1st"    2    "RED"  
    1    "March-1st"    3    "GREEN"
    3    "March-5th"    8    "GREEN"
    6    "March-8th"    4    "GREEN"
    2    "April-3rd"    5    "RED"  
    2    "April-3rd"    0    "GREEN"
[G,GID] = findgroups(T.A,T.B);
is_red = strcmp(T.D,"RED");
delete_row = false(size(T,1),1);
for ii = 1:numel(GID)
    idx = G == GID(ii);
    if nnz(idx) == 1
        continue
    end
    delete_row(idx & is_red) = true;
end
T(delete_row,:) = []
T = 4×4 table
    A         B         C       D   
    _    ___________    _    _______

    1    "March-1st"    3    "GREEN"
    3    "March-5th"    8    "GREEN"
    6    "March-8th"    4    "GREEN"
    2    "April-3rd"    0    "GREEN"

7 个评论
显示 5更早的评论隐藏 5更早的评论

Voss 2024-3-12

编辑：Voss 2024-3-12

在 MATLAB Online 中打开

One way you'd get that error is if the date column is a cell array (as opposed to a string array like I've used) and is the first argument passed to findgroups.

T = table( ...
    [1;1;3;6;2;2], ...
    cellstr(["March-1st";"March-1st";"March-5th";"March-8th";"April-3rd";"April-3rd"]), ...
    [2;3;8;4;5;0], ...
    ["RED";"GREEN";"GREEN";"GREEN";"RED";"GREEN"], ...
    'VariableNames',["A","B","C","D"])
T = 6×4 table
    A          B          C       D   
    _    _____________    _    _______

    1    {'March-1st'}    2    "RED"  
    1    {'March-1st'}    3    "GREEN"
    3    {'March-5th'}    8    "GREEN"
    6    {'March-8th'}    4    "GREEN"
    2    {'April-3rd'}    5    "RED"  
    2    {'April-3rd'}    0    "GREEN"
[G,GID] = findgroups(T.B,T.A); % B (cell array) first gives the error
is_red = strcmp(T.D,"RED");
delete_row = false(size(T,1),1);
for ii = 1:numel(GID)
    idx = G == GID(ii);
    if nnz(idx) == 1
        continue
    end
    delete_row(idx & is_red) = true;
end
Operator '==' is not supported for operands of type 'cell'.
T(delete_row,:) = []

In that case, make the numeric column be the first one passed to findgroups:

[G,GID] = findgroups(T.A,T.B); % numeric first

Charles 2024-3-13

编辑：Charles 2024-3-13

I can not upload my table, but it is read from Excel, and then I used the unique function to delete all exact duplicate rows. TUnique is >800 rows.

T = readtable('Table.xlsx');

TUnique = unique(T);

Voss 2024-3-13

You should be deleting rows from TUnique instead of T.

Can you upload the xlsx file? Without the data, I can only guess.

请先登录，再进行评论。

Deleting certain rows with partially duplicate values

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

回答（1 个）

7 个评论
显示 5更早的评论隐藏 5更早的评论

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

Deleting certain rows with partially duplicate values

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

回答（1 个）

7 个评论 显示 5更早的评论隐藏 5更早的评论

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

7 个评论
显示 5更早的评论隐藏 5更早的评论