Delete rows with "-" in categorial colum
5 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
採用された回答
Voss
2023 年 1 月 5 日
編集済み: Voss
2023 年 1 月 5 日
t = table(["some";"strings";"in";"this";"column"],categorical(["Autumn";"Summer";"Winter";"-";"Winter"]))
idx = t{:,end} == "-";
t(idx,:) = []
counts = groupsummary(t,'Var2')
2 件のコメント
Siddharth Bhutiya
2023 年 1 月 6 日
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.
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Tables についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!