Create Count Table of Multiple Variables in R (Example Code)
This tutorial explains how to make a frequency table for multiple columns in the R programming language.
Example Data
data(iris) # Example data head(iris) # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 1 5.1 3.5 1.4 0.2 setosa # 2 4.9 3.0 1.4 0.2 setosa # 3 4.7 3.2 1.3 0.2 setosa # 4 4.6 3.1 1.5 0.2 setosa # 5 5.0 3.6 1.4 0.2 setosa # 6 5.4 3.9 1.7 0.4 setosa |
data(iris) # Example data head(iris) # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 1 5.1 3.5 1.4 0.2 setosa # 2 4.9 3.0 1.4 0.2 setosa # 3 4.7 3.2 1.3 0.2 setosa # 4 4.6 3.1 1.5 0.2 setosa # 5 5.0 3.6 1.4 0.2 setosa # 6 5.4 3.9 1.7 0.4 setosa
Example: Create Count Table of Multiple Columns
iris_count <- t(sapply(iris[ , 1:4], # Create table with counts function(x) tapply(x, iris[ , 5], sum))) iris_count # Display count table # setosa versicolor virginica # Sepal.Length 250.3 296.8 329.4 # Sepal.Width 171.4 138.5 148.7 # Petal.Length 73.1 213.0 277.6 # Petal.Width 12.3 66.3 101.3 |
iris_count <- t(sapply(iris[ , 1:4], # Create table with counts function(x) tapply(x, iris[ , 5], sum))) iris_count # Display count table # setosa versicolor virginica # Sepal.Length 250.3 296.8 329.4 # Sepal.Width 171.4 138.5 148.7 # Petal.Length 73.1 213.0 277.6 # Petal.Width 12.3 66.3 101.3