Delete rows with "-" in categorial colum
8 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
Voss
le 5 Jan 2023
Modifié(e) : Voss
le 5 Jan 2023
t = table(["some";"strings";"in";"this";"column"],categorical(["Autumn";"Summer";"Winter";"-";"Winter"]))
idx = t{:,end} == "-";
t(idx,:) = []
counts = groupsummary(t,'Var2')
2 commentaires
Siddharth Bhutiya
le 6 Jan 2023
Using dot indexing would be faster since you dont really need the brace there.
t(t.Var2 == "-",:) = [];
Voss
le 6 Jan 2023
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.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!