Delete rows with "-" in categorial colum

Question

Max1234 2023-1-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1888807-delete-rows-with-in-categorial-colum

评论： Voss 2023-1-6

Hey guys,

I have two questions, maybe someone can help me. Thanks in advance.

I have a table with four columns: String, String, Datum, Categorial. I would like to remove all rows where there is a "-" in the categorial column.

There are only three words in the column: "Autumn", "Summer" and "Winter". I would like to display how many cells are filled with each word.

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

请先登录，再进行评论。

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

Answer 1

Voss 2023-1-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1888807-delete-rows-with-in-categorial-colum#answer_1141892

编辑：Voss 2023-1-5

在 MATLAB Online 中打开

t = table(["some";"strings";"in";"this";"column"],categorical(["Autumn";"Summer";"Winter";"-";"Winter"]))
t = 5×2 table
      Var1        Var2 
    _________    ______

    "some"       Autumn
    "strings"    Summer
    "in"         Winter
    "this"       -     
    "column"     Winter
idx = t{:,end} == "-";
t(idx,:) = []
t = 4×2 table
      Var1        Var2 
    _________    ______

    "some"       Autumn
    "strings"    Summer
    "in"         Winter
    "column"     Winter
counts = groupsummary(t,'Var2')
counts = 3×2 table
     Var2     GroupCount
    ______    __________

    Autumn        1     
    Summer        1     
    Winter        2     

2 个评论
显示无隐藏无

Siddharth Bhutiya 2023-1-6

在 MATLAB Online 中打开

Using dot indexing would be faster since you dont really need the brace there.

t(t.Var2 == "-",:) = [];

Voss 2023-1-6

Thanks! I used brace indexing in that case so that the OP could run the code without having to know they need to change the Var2 variable name to whatever their table's categorical variable name is.

请先登录，再进行评论。