can not extract rows which match a string
Hello,
You have to use is.na to get the NA values.
t1 <- data.frame(sex_chromosome_aneuploidy_f22019_0_0 = c(NA, "Yes"),
other = 1:2)
i <- t1$sex_chromosome_aneuploidy_f22019_0_0 == "Yes" &
!is.na(t1$sex_chromosome_aneuploidy_f22019_0_0)
i
t1[i, ]
Hope this helps,
Rui Barradas
?s 19:58 de 03/10/19, Ana Marija escreveu:
Hello, I have a dataframe (t1) with many columns, but the one I care about it this:
unique(t1$sex_chromosome_aneuploidy_f22019_0_0)
[1] NA "Yes" it has these two values. I would like to remove from my dataframe t1 all rows which have "Yes" in t1$sex_chromosome_aneuploidy_f22019_0_0 I tried selecting those rows with "Yes" via: t11=t1[t1$sex_chromosome_aneuploidy_f22019_0_0=="Yes",] but I got t11 which has the exact same number of rows as t1. If I do:
table(t1$sex_chromosome_aneuploidy_f22019_0_0)
Yes 620 So there is for sure 620 rows which have "Yes". How to remove those from my t1 data frame? Thanks Ana
______________________________________________ R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.