Count number of columns by a condition (>) for each row

by

This will give you the vector you are looking for:

rowSums(data > 30)

It will work whether data is a matrix or a data.frame. Also, it uses vectorized functions, hence is a preferred approach over using apply which is little more than a (slow) for loop.

If data is a data.frame, you can add the result as a column by doing:

data$yr.above <- rowSums(data > 30)

or if data is a matrix:

data <- cbind(data, yr.above = rowSums(data > 30))

You can also create a whole new data.frame:

data.frame(yr.above = rowSums(data > 30))

or a whole new matrix:

cbind(yr.above = rowSums(data > 30))

More Related Contents:

  1. Count number of rows per group and add result to original data frame
  2. Counting the number of elements with the values of x in a vector
  3. Add count of unique / distinct values by group to the original data
  4. Include levels of zero count in result of table()
  5. Convert row names into first column
  6. Count number of occurences for each unique value
  7. Create counter within consecutive runs of values
  8. How can I count runs in a sequence?
  9. Count non-NA values by group [duplicate]
  10. Count number of rows by group using dplyr
  11. How to count the frequency of a string for each row in R
  12. Extend contigency table with proportions (percentages)
  13. Find the n most common values in a vector [duplicate]
  14. Cumulative count of each value [duplicate]
  15. Find the most frequent value by row
  16. Tidyr how to spread into count of occurrence [duplicate]
  17. How can I convert row names into the first column?
  18. Count unique values for every column
  19. How can I count the number of NAs per group?
  20. Create a sequential number (counter) for rows within each group of a dataframe [duplicate]
  21. Extracting specific columns from a data frame
  22. Subset a dataframe between 2 dates
  23. How to move cells with a value row-wise to the left in a dataframe [duplicate]
  24. rep() with each equals a vector
  25. Memory Allocation “Error: cannot allocate vector of size 75.1 Mb” [duplicate]
  26. Remove rows in R matrix where all data is NA [duplicate]
  27. Using cbind on an arbitrarily long list of objects
  28. Rstudio is duplicating commands in the command line
  29. R data.table breaks in exported functions
  30. R, car package unable to load

Leave a Comment