Filtering for Unique Values in R, Using the dplyr package in R, you may filter for unique values in a data frame using the following methods.
Method 1: In one column, filter for unique values.
df %>% distinct(var1)
Method 2: Filtering for Unique Values in Multiple Columns
df %>% distinct(var1, var2)
Method 3: In all columns, filter for unique values.
df %>% distinct()
With the following data frame in R, the following examples explain how to utilize each method in practice.
Arrange Data by Month in R with example – Data Science Tutorials
create a data frame
df <- data.frame(team=c('X', 'X', 'X', 'X', 'Y', 'Y', 'Y', 'Y'),
rebounds =c('8', '6', '5', '4', '3', '8', '9', '5'),
points=c(107, 207, 208, 211, 213, 215, 219, 313))
Now we can view the data frame
df
team rebounds points 1 X 8 107 2 X 6 207 3 X 5 208 4 X 4 211 5 Y 3 213 6 Y 8 215 7 Y 9 219 8 Y 5 313
Example 1: Column Filter for Unique Values
To filter for unique values in just the team column, we can use the following code.
Rejection Region in Hypothesis Testing – Data Science Tutorials
library(dplyr)
In the team column, only unique values should be selected.
df %>% distinct(team)
team 1 X 2 Y
It’s worth noting that just the team column’s unique values are returned.
Example 2: Find Unique Values in Multiple Columns Using a Filter
To filter for unique values in the team and points columns, we can use the following code:
library(dplyr)
in the team and points columns, select unique values
df %>% distinct(team, points)
team points 1 X 107 2 X 207 3 X 208 4 X 211 5 Y 213 6 Y 215 7 Y 219 8 Y 313
It’s worth noting that just the team and points columns’ unique values are returned.
Best Books to Learn R Programming – Data Science Tutorials
Example 3: Filter all columns for unique values
To filter for unique values across all columns in the data frame, we can use the following code.
library(dplyr)
choose unique values in all columns
df %>% distinct()
team rebounds points 1 X 8 107 2 X 6 207 3 X 5 208 4 X 4 211 5 Y 3 213 6 Y 8 215 7 Y 9 219 8 Y 5 313
It’s worth noting that the unique values from each of the three columns are returned.
