how to realize countifs function (excel) in R

by

Easy peasy. Your data frame will look like this:

df <- data.frame(sex=c('M','F','M'),
                 occupation=c('Student','Analyst','Analyst'))

You can then do the equivalent of a COUNTIF by first specifying the IF part, like so:

df$sex == 'M'

This will give you a boolean vector, i.e. a vector of TRUE and FALSE. What you want is to count the observations for which the condition is TRUE. Since in R TRUE and FALSE double as 1 and 0 you can simply sum() over the boolean vector. The equivalent of COUNTIF(sex='M') is therefore

sum(df$sex == 'M')

Should there be rows in which the sex is not specified the above will give back NA. In that case, if you just want to ignore the missing observations use

sum(df$sex == 'M', na.rm=TRUE)

More Related Contents:

  1. Is the “*apply” family really not vectorized?
  2. Force the origin to start at 0
  3. How to delete multiple values from a vector?
  4. Frequency count of two column in R
  5. Selecting multiple odd or even columns/rows for dataframe
  6. Format numbers with million (M) and billion (B) suffixes
  7. Rolling mean (moving average) by group/id with dplyr
  8. Generate a sequence of the last day of the month over two years
  9. Deleting reversed duplicates with R
  10. Efficient way to filter one data frame by ranges in another
  11. How to select a CRAN mirror in R
  12. Position of the sun given time of day, latitude and longitude
  13. Fill missing combinations in a dataframe
  14. Extreme numerical values in floating-point precision in R
  15. Insert elements into a vector at given indexes
  16. Count values separated by a comma in a character string
  17. How Do I connect two coordinates with a line using Leaflet in R
  18. linear regression “NA” estimate just for last coefficient
  19. Using gsub to extract character string before white space in R
  20. How convert decimal to POSIX time
  21. Convert character matrix into numeric matrix
  22. Selecting only unique values from a comma separated string [duplicate]
  23. What does the diff() function in R do? [closed]
  24. Convert hours:minutes:seconds to minutes
  25. R dplyr rowwise mean or min and other methods?
  26. Delete entries with only one observation in a group
  27. Submit form with no submit button in rvest
  28. Character POSIXct Conversion in R causes wrong timezone values on daylight saving time transition (CEST/CET))
  29. Sum object in a column between an interval defined by another column
  30. R shiny sliderInput with restricted range

Leave a Comment