What is the best way to filter by row number in R?, The slice function from the dplyr package can be used to filter a data frame by row number using the following methods.
How to Count Distinct Values in R – Data Science Tutorials
Method 1: Filter by Specific Row Numbers
df %>% slice(2, 3, 8)
Rows 2, 3, and 8 will be returned as a result of this.
Method 2: Filter by Range of Row Numbers
df %>% slice(2:5)
Rows 2 through 5 will be returned as a result of this.
With the following data frame in R, the following examples explain how to utilize each method in practice.
How to perform the MANOVA test in R? – Data Science Tutorials
Let’s create a data frame
df <- data.frame(team=c('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H'),
points=c(110, 120, 80, 16, 105, 185, 112, 112),
rebounds=c(18, 18, 14, 13, 12, 15, 17, 12))Now we can view the data frame
df
team points rebounds 1 A 110 18 2 B 120 18 3 C 80 14 4 D 16 13 5 E 105 12 6 F 185 15 7 G 112 17 8 H 112 12
Example 1: Filter by Specific Row Numbers
To filter for rows 2, 3, and 8, we may use the following code.
Statistical test assumptions and requirements – Data Science Tutorials
library(dplyr)
Let’s filter for only rows 2, 3, and 8
df %>% slice(2, 3, 8)
team points rebounds 1 B 120 18 2 C 80 14 3 H 112 12
From the original data frame, only rows 2, 3, and 8 are returned.
Example 2: Filter by a row number range
To filter for rows between 2 and 5, we can use the following code.
Sorting in r: sort, order & rank R Functions – Data Science Tutorials
library(dplyr)
Now filter for rows between 2 and 5
df %>% slice(2:5)
team points rebounds 1 B 120 18 2 C 80 14 3 D 16 13 4 E 105 12
Only rows 2 to 5 from the original data frame are returned.
Hi,
Why not simply use R’s way of indexing with brackets, such as
df[rows,columns] ?
you can achieve your first example with a simple
df[c(2,3,8),]
and the second
df[c(2:5),]