Selecting rows in R with “Yes” in one column of a set of columns, and NOT “Yes” in all columns of another set of columns

by

as long as you have the dataframe organized the way you do now i.e., comp1type1,comp1type2,comp1type3,comp2type1,…,comp[I]type[J]. I am sure you can use the following method.

    ncomp <- 20
    ntype <- 3
    vecone <- df[,seq(1,ncomp*ntype,ntype)]
    vectwo <- df[,seq(2,ncomp*ntype,ntype)]
    vecthree <- df[,seq(3,ncomp*ntype,ntype)]

    # now that we have the vectors of types seperated into data.frame's
    # it'll be easier to do what we want
    # this first condition will find which rows type1/2 have No or NA for all
    condition1 <- rowSums(vecone=="No" | is.na(vecone)) == ncol(vecone)
    condition2 <- rowSums(vectwo=="No" | is.na(vectwo)) == ncol(vectwo)
    # this third condition will find which rows type3 have atleast one Yes
    condition3 <- rowSums(vecthree =="Yes",na.rm=T) >= 1

Now you may use these conditions to figure out how many rows include a Yes for any type3 and a No/NA for all type1/2

sum(condition1 & condition2 & condition3)

More Related Contents:

  1. How to save a plot as image on the disk?
  2. Shading a kernel density plot between two points.
  3. R Reshape data frame from long to wide format? [duplicate]
  4. Categorize numeric variable into group/ bins/ breaks
  5. Operator “[
  6. How do you order the fill-colours within ggplot2 geom_bar
  7. Does R have quote-like operators like Perl’s qw()?
  8. Simplest way to get rbind to ignore column names
  9. Growing a data.frame in a memory-efficient manner
  10. Force character vector encoding from “unknown” to “UTF-8” in R
  11. Difference between passing options in aes() and outside of it in ggplot2
  12. How to make gradient color filled timeseries plot in R
  13. Setting document title in Rmarkdown from parameters
  14. passing several arguments to FUN of lapply (and others *apply)
  15. Convert data frame with date column to timeseries
  16. ggplot2 multiple scales/legends per aesthetic, revisited [duplicate]
  17. Tidyr how to spread into count of occurrence [duplicate]
  18. Apply several summary functions (sum, mean, etc.) on several variables by group in one call
  19. Order of operator precedence when using “:” (the colon)
  20. What methods can we use to reshape VERY large data sets?
  21. Using lapply to apply a function over list of data frames and saving output to files with different names
  22. Determining UTM zone (to convert) from longitude/latitude
  23. Output a vector in R in the same format used for inputting it into R
  24. Using R to download zipped data file, extract, and import .csv
  25. Downloading png from Shiny (R)
  26. Create binary column (0/1) based on condition in another column
  27. Layered axes in ggplot?
  28. Remove unused factor levels from a ggplot bar plot
  29. How to display emojis in ggplot2 using emo package in R?
  30. Split a string column into several dummy variables

Leave a Comment