Summarizing and Grouping Data

Welcome back! In our previous lesson, we learned how to select and filter data using the dplyr package in R. Now that you have the foundational skills to manage and clean your data, it's time to move on to summarizing and grouping. This lesson will enhance your ability to derive meaningful insights from your datasets by grouping and summarizing information efficiently.

In this lesson, you'll discover how to:

1. Group data by one or more variables using the group_by function.
2. Summarize data to calculate aggregate statistics like the mean, median, or sum using the summarize function.

We'll continue using simple data frame examples to illustrate these concepts. Here’s a step-by-step guide:

First, let's create a simple data frame that we'll use for grouping and summarizing:

# Example data frame
data <- data.frame(
  Group = c("A", "A", "B", "B"),
  Score = c(85, 95, 78, 92)
)

# Print the example data frame
print(data)

# Output:
#   Group Score
# 1     A    85
# 2     A    95
# 3     B    78
# 4     B    92

In this data frame, we have two columns: Group and Score. The Group column specifies the group to which each observation belongs, while the Score column provides the scores.

Now, let's use the group_by function to group our data by the Group column:

# Example data frame
data <- data.frame(
  Group = c("A", "A", "B", "B"),
  Score = c(85, 95, 78, 92)
)
# Group data by Group
grouped_data <- data %>%
  group_by(Group)
  
# Printed the grouped data
print(grouped_data)

# Output of grouped_data:
#   A tibble: 4 × 2
#   Groups:   Group [2]
#   Group Score
#   <chr> <dbl>
# 1 A        85
# 2 A        95
# 3 B        78
# 4 B        92

The %>% symbol is the pipe operator, which allows you to chain multiple functions together seamlessly. The group_by function is used to specify the column(s) to group by. In this case, we group by the Group column.

Next, let's summarize the data to calculate the mean score for each group using the summarize function:

# Example data frame
data <- data.frame(
  Group = c("A", "A", "B", "B"),
  Score = c(85, 95, 78, 92)
)
# Group data by Group
grouped_data <- data %>%
  group_by(Group)

# Summarize the data by mean score
summary <- grouped_data %>%
  summarize(mean_score = mean(Score))

# Print the summarized data
print(summary)

# Output of summary:
#   A tibble: 2 × 2
#   Group mean_score
#   <chr>      <dbl>
# 1 A             90
# 2 B             85

The summarize function allows us to calculate aggregate statistics. Here, we calculate the mean score for each group and store it in a new column named mean_score.