使用R语言操作数据表：选取数据框中第一个零与第二个零之间的所有行

Got it, let's work through this problem! You're right that subset() alone can't easily handle this specific range selection based on the positions of zeros—we need to first pinpoint where those zeros are, then slice the data frame accordingly. Here are a couple of straightforward approaches in R:

1. Base R Approach (Using which() for Indexing) #

First, let's recreate your sample data frame to test with:

df <- data.frame(
  X = 1:6,
  Y = c(-0.1, 0, -0.2, -0.4, 0, -0.2)
)

Next, we'll find the row indices where Y equals 0, then use those indices to slice the data frame from the first zero to the second zero (inclusive):

# Get indices of rows where Y is 0
zero_positions <- which(df$Y == 0)

# Slice the data frame between the first and second zero
result <- df[zero_positions[1]:zero_positions[2], ]

# View the output
result

This will give you exactly what you're looking for:

X    Y
2 2  0.0
3 3 -0.2
4 4 -0.4
5 5  0.0

This method is flexible too—if you ever need to select between the nth and mth zero, just adjust the indices in zero_positions[n]:zero_positions[m].

2. Tidyverse (dplyr) Approach #

If you prefer working with the tidyverse ecosystem, here's a pipe-friendly solution:

library(dplyr)

result <- df %>%
  # Flag rows where Y is 0
  mutate(is_zero = Y == 0) %>%
  # Create a cumulative counter for zeros (increments each time we hit a zero)
  mutate(zero_group = cumsum(is_zero)) %>%
  # Keep rows from the first zero group up to the second
  filter(zero_group >= 1 & zero_group <= 2) %>%
  # Remove the helper columns
  select(-is_zero, -zero_group)

result

This works by grouping rows based on how many zeros we've encountered so far. Rows between the first and second zero will fall into groups 1 and 2, which we filter for.

Why subset() Isn't Ideal Here #

The subset() function is great for filtering rows based on direct column values (like Y > 0), but it doesn't handle positional range selection based on the occurrence of specific values. We first need to identify the positions of the zeros, which which() (or the tidyverse's row number functions) handles perfectly.

内容的提问来源于stack exchange，提问作者Maik125