na.rm in dataframe
We have to use apply function to apply the function on the dataframe with na.rm function
Syntax: apply(dataframe, 2, function, na.rm )
where
- dataframe is the input dataframe
- function is to perform some operations like mean,min ,max etc
- 2 represents column
- na.rm is to remove NA values
Example 1: In this example, we are calculating the mean, sum, minimum, maximum, and standard deviation without NA in all columns
R
# create a dataframe with 3 columns data = data.frame (column1 = c (1,2, NA ,34), column2 = c ( NA ,34,56, NA ), column3 = c ( NA , NA ,32,56)) # display print (data) # calculate mean including NA values apply (data, 2, mean , na.rm = FALSE ) # calculate sum including NA values apply (data, 2, sum , na.rm = FALSE ) # calculate min including NA values apply (data, 2, min, na.rm = FALSE ) # calculate max including NA values apply (data, 2, max , na.rm = FALSE ) # calculate standard deviation including # NA values apply (data, 2, sd, na.rm = FALSE ) |
Output:
Example 2: Excluding NA values
R
# create a dataframe with 3 columns data = data.frame (column1 = c (1,2, NA ,34), column2 = c ( NA ,34,56, NA ), column3 = c ( NA , NA ,32,56)) # display print (data) # calculate mean excluding NA values apply (data, 2, mean , na.rm = TRUE ) # calculate sum excluding NA values apply (data, 2, sum , na.rm = TRUE ) # calculate min excluding NA values apply (data, 2, min, na.rm = TRUE ) # calculate max excluding NA values apply (data, 2, max , na.rm = TRUE ) # calculate standard deviation excluding # NA values apply (data, 2, sd, na.rm = TRUE ) |
Output:
How to Use na.rm in R?
In this article, we will discuss how to use na.rm in R Programming Language. na.rm in R is used to remove the NA values.