How to Perform a COUNTIF Function in R?
In this article, we will discuss how to perform COUNTIF function in R programming language.
This is used to count the value present in the dataframe. We have to use sum() function to get the count.
Syntax:
sum(dataframe$column_name == value, na.rm=TRUE)
where,
- dataframe is the input dataframe
- column_name is the column in the dataframe
- na.rm is set to true to ignore NA values
Count Rows Equal to Some Value
To do that we simply equate the value and make it a count if the value is the given value.
Example: Count rows equal to some value
R
# create dataframe with four columns data = data.frame (col1= c (1, 34, 56, 32, 23), col2= c (21, 34, 56, 32, 34), col3= c ( "manoj" , "sai" , "sai" , "manoj" , "maghu" ), col4= c ( "java" , "php" , "jsp" , "php" , "html" )) # count manoj from col3 print ( sum (data$col3 == 'manoj' )) # count 34 from col2 print ( sum (data$col2 == 34)) |
Output:
[1] 2 [1] 2
Count Rows Greater or Equal to Some Value
In this, the condition is passed to the function simply. The count is incremented if the condition is satisfied.
Syntax:
sum(dataframe$column_name> value)
Example: Count rows greater or equal to some value
R
# create dataframe with four columns data = data.frame (col1= c (1, 34, 56, 32, 23), col2= c (21, 34, 56, 32, 34), col3= c ( "manoj" , "sai" , "sai" , "manoj" , "maghu" ), col4= c ( "java" , "php" , "jsp" , "php" , "html" )) # count value greater than or equal to 30 from col1 print ( sum (data$col1 >= 30)) # count value greater than or equal to 10 from col2 print ( sum (data$col2 >= 10)) |
Output:
[1] 3 [1] 5
Contact Us