How to Easily Create Grouped Frequency Tables in R

You can use the following functions from the dplyr package to create a frequency table by group in R:

library(dplyr)

df %>%
  group_by(var1, var2) %>%
  summarize(Freq=n())

The following practical example shows how to apply this syntax to a sample dataset.

Setting Up the R Environment and Initial Data Frame

Before executing any data manipulation using dplyr, it is necessary to ensure the package is loaded into the R session using the library() function. Once loaded, we can proceed to define our sample data. For this demonstration, we will create a simple data frame that simulates a roster of players, detailing their team assignment and position. This data frame serves as the input for our frequency analysis.

The structure of the data frame, containing categorical variables like team and position, is ideal for demonstrating grouped frequency counts. We are interested in finding out how many players occupy each position, but segmented by their respective teams (A and B). This requires grouping by both variables simultaneously.

#create data frame
df <- data.frame(team=c('A', 'A', 'A', 'A', 'B', 'B', 'B', 'B'),
                 position=c('G', 'G', 'G', 'F', 'G', 'F', 'F', 'C'))

#view data frame
df

  team position
1    A        G
2    A        G
3    A        G
4    A        F
5    B        G
6    B        F
7    B        F
8    B        C

Our objective is to create a frequency table that shows the count of each unique position, categorized by the corresponding team.

Example: Creating the Grouped Frequency Table

To execute the grouped frequency analysis, we initiate the pipeline by feeding the data frame df into the pipe operator. Next, we call group_by(), specifying both team and position as the grouping variables. This instructs R to treat every unique combination of team and position (e.g., Team A, Position G; Team B, Position F) as a distinct unit for calculation. Finally, we apply summarize(), creating a new column named Freq which holds the count of observations (rows) in each group, calculated using n().

This single, cohesive command structure is highly efficient. It avoids the manual sorting and counting that older methods might require. The output produced by summarize() will be a new tibble (a modern data frame structure) that lists every unique group combination and its corresponding frequency count.

library(dplyr)

#calculate frequency of position, grouped by team
df %>%
  group_by(team, position) %>%
  summarize(Freq=n())

# A tibble: 5 x 3
# Groups:   team [2]
  team  position  Freq
       
1 A     F            1
2 A     G            3
3 B     C            1
4 B     F            2
5 B     G            1

Interpreting the Grouped Frequency Output

The result is a tibble showing five unique combinations of team and position, along with the calculated frequency (count). Note that there are only five rows, even though the original data frame had eight, because the summarize() function aggregated identical rows. Analyzing this output allows us to derive specific insights about the composition of each team. The Groups: team [2] line indicates that the resulting tibble is still grouped by team, which is important if further grouped operations were planned.

The interpretation of each row is straightforward, quantifying exactly how many players in a given team hold a specific position. This clear and concise representation is the primary benefit of using grouped summarization for frequency analysis.

Here’s how to interpret the output:

• 1 player on team A has position ‘F’ (Forward)
• 3 players on team A have position ‘G’ (Guard)
• 1 player on team B has position ‘C’ (Center)
• 2 players on team B have position ‘F’ (Forward)
• 1 player on team B has position ‘G’ (Guard)

Customizing the Output: Renaming the Frequency Column

It is important to use descriptive column names in any analytical output to ensure clarity for others viewing the results. Although Freq is commonly understood, renaming the count column can improve overall project readability, especially when combining multiple summary statistics. We rename the column simply by changing the variable name assigned within the summarize() function call.

For example, if the frequency represents a count of total individuals, using count or Total_Players might be more expressive than Freq. This small adjustment is performed directly within the argument list of summarize(), demonstrating the flexibility and ease of customization provided by dplyr.

For example, we could rename the column to be named ‘count’ instead:

library(dplyr)

#calculate frequency of position, grouped by team
df %>%
  group_by(team, position) %>%
  summarize(count=n())

# A tibble: 5 x 3
# Groups:   team [2]
  team  position count
       
1 A     F            1
2 A     G            3
3 B     C            1
4 B     F            2
5 B     G            1

Further Applications and Conclusion

Generating grouped frequency tables is often just the initial step in a larger analytical workflow. Once the counts are calculated, analysts might proceed to convert these counts into relative frequencies (percentages) by further manipulating the summarized table. This involves applying window functions or additional mutate() operations, typically grouped by the higher-level variable (e.g., team) to calculate the percentage contribution of each position within its respective team total.

The methods demonstrated here, utilizing group_by() and summarize(), represent the most robust and standard approach for conducting segmented frequency analysis in R. Mastering these core dplyr concepts ensures that your data wrangling processes are clean, efficient, and easily scalable for handling complex, large-scale datasets.

Related Data Wrangling Tutorials

The following tutorials explain how to perform other common data manipulation functions using dplyr, building upon the foundational knowledge presented here: