Condense Column Values of a Data Frame in R Programming - summarise() Function
Last Updated :
19 Jun, 2020
Improve
summarise()
function in R Language is used to condense various values of column of a data frame to one value.
Syntax: summarise(x, expr) Parameters: x: Data Frame expr: Operation to condense dataExample 1:
# R program to condense data
# of a data frame
# Loading library
library(dplyr)
# Create a data frame
d <- data.frame( name = c("Abhi", "Bhavesh", "Chaman", "Dimri"),
age = c(7, 5, 9, 16),
ht = c(46, NA, NA, 69),
school = c("yes", "yes", "no", "no") )
# Calculating min age
summarise(d, min_age = min(age))
# Calculating max age
summarise(d, max_age = max(age))
min_age 1 5 max_age 1 16Example 2:
# R program to condense data
# of a data frame
# Loading library
library(dplyr)
# Create a data frame
d <- data.frame( name = c("Abhi", "Bhavesh", "Chaman", "Dimri"),
age = c(7, 5, 9, 16),
ht = c(46, NA, NA, 69),
school = c("yes", "yes", "no", "no") )
# Calculating mean of age
summarise(d, mean = mean(age))
# Calculating median of age
summarise(d, med = median(age))
mean 1 9.25 med 1 8