Binning Continuous Data into Categories with R | CodeSignal Learn

Binning Continuous Data into Categories with R | CodeSignal Learn

Skip to main content

Introduction and Overview

Hello! Today's lesson is about Data Binning in R. This process involves grouping numerous continuous data values into a smaller number of categories or "bins." For instance, ages can be binned into categories like "Child," "Teen," and "Adult." We'll utilize R's built-in functions, particularly the cut function, for data binning. Ready to explore? Let's get started! Binning is a widely utilized data simplification technique. It facilitates interpretation by mitigating the complexities of continuous values. For example, grouping student grades into categories such as "A," "B," "C," "D," "F" better highlights performance patterns than do individual scores.

Basic Binning in R

R provides cut, a function to perform binning. To group ages into categories such as "Young," "Middle-aged," and "Old," for example, we use: age <- c(5, 15, 18, 24, 38, 62, 77) # Define a numerical vector `age` age_category <- cut(age, breaks = 3, labels = c("Young", "Middle-aged", "Old")) # Apply the `cut` function print(age_category) # Print the output # Young Young Young Young Middle-aged Old Old The cut function in R determines the break points based on the breaks argument. If breaks is specified as a single number, the range of the data is divided into that number of equal-width intervals. For example, breaks = 4 splits the data into four intervals with equal widths. In the provided example, the cut function classifies the range of age into three bins, as breaks = 3 .

Working with Categories

Advanced Binning Techniques

Custom bin sizes allow for better control over the categories. Custom binning involves adjusting the breaks argument in the cut function. age <- c(20, 19, 30, 70, 0) # Define a numerical vector `age` age_category <- cut(age, breaks = c(0, 20, 30, 40, Inf), labels = c("<=20", "20-30", "30-40", ">=40")) print(age_category) # [1] <=20 <=20 20-30 >=40 <NA> - The assigned bins categories for the vector values # Levels: <=20 20-30 30-40 >=40 In this example, custom bin borders are defined using the breaks argument. It is assigned a vector containing bin borders. Let's break it down. For breaks = c(0, 20, 30, 40, Inf), the bin borders are: (0, 20] (20, 30] (30, 40] (40, inf) Note that the left border of each bin is not inclusive. For example, the first bin is (0, 20] . 0 is not included in this bin, and 20 is.

Sign up

Join the 1M+ learners on CodeSignal

Be a part of our community of 1M+ users who develop and demonstrate their skills on CodeSignal

R

age <- c(5, 15, 18, 24, 38, 62, 77)   # Define a numerical vector `age`
age_category <- cut(age, breaks = 3, labels = c("Young", "Middle-aged", "Old"))   # Apply the `cut` function
print(age_category)   # Print the output
# Young       Young       Young       Young       Middle-aged Old        Old

When the binning is done, we can work with categories separately.

R

# Combine the age and its corresponding category
age_data <- data.frame(age, age_category)

# Calculate the mean age for the "Young" bin
young_mean <- mean(age_data$age[age_data$age_category == "Young"])

print(paste("Mean age for 'Young' category:", young_mean))
# Output: [1] "Mean age for 'Young' category: 15.5"

In this snippet:

data.frame(age, age_category) creates a new dataframe combining age with its corresponding category.
age_data$age[age_data$age_category == "Young"] selects the ages in the "Young" bin.
mean(...) calculates the mean of these ages.

R

age <- c(20, 19, 30, 70, 0)   # Define a numerical vector `age`
age_category <- cut(age, breaks = c(0, 20, 30, 40, Inf), labels = c("<=20", "20-30", "30-40", ">=40"))
print(age_category)
# [1] <=20   <=20   20-30 >=40  <NA>   – The assigned bins categories for the vector values
# Levels: <=20 20-30 30-40 >=40

Applying Binning in Data Analysis

In data analysis, the use of binning provides crucial insights. Rather than observing individual data points, binning gives a broader picture by grouping together relevant data. library(dplyr) age <- c(5, 15, 18, 24, 38, 62, 77) # Define a numerical vector `age` age_category <- cut(age, breaks = 3, labels = c("Young", "Middle-aged", "Old")) # Apply the `cut` function age_data <- data.frame(age = age, category = age_category) age_summary <- age_data %>% count(category) print(age_summary) Here, we count the number of people in each bin to get an overview of the age distribution, enabling an easier interpretation of the data. The output is: category n 1 Young 4 2 Middle-aged 1 3 Old 2

R

library(dplyr)

age <- c(5, 15, 18, 24, 38, 62, 77)   # Define a numerical vector `age`
age_category <- cut(age, breaks = 3, labels = c("Young", "Middle-aged", "Old"))   # Apply the `cut` function

age_data <- data.frame(age = age, category = age_category)
age_summary <- age_data %>% count(category)
print(age_summary)