Python Pandas切片转R语言：取-0.010623及之前行的写法问询

Got it, let's break down how to replicate that Pandas slicing logic in R—this is a common task, and there are a couple of straightforward ways to do it depending on whether you prefer base R or tidyverse tools.

First, let's clarify the Pandas behavior you're referencing: if you have a DataFrame like df and want all rows up to and including the first occurrence of -0.010623 in a specific column, you might write something like:

# Pandas example
target_idx = df[df['your_column'] == -0.010623].index[0]
result = df[:target_idx + 1]

Here's how to do the same in R:

Option 1: Base R #

This approach uses base R functions to locate the target row and slice the data frame:

1. Find the target row number: Use which() to locate the first occurrence of your value. Critical note: since floating-point numbers can have precision issues, avoid direct == comparisons—instead check if the absolute difference is below a small tolerance (like 1e-6).
2. Slice the data frame: Use row indexing to grab all rows from the start up to the target row.

# Example data frame
df <- data.frame(
  values = c(0.001, -0.005, -0.010623, 0.02, -0.03)
)

# Locate first row with the target value (handling floating-point precision)
target_row <- which(abs(df$values - (-0.010623)) < 1e-6)[1]

# Slice to get all rows up to and including the target
result <- df[1:target_row, ]

# View the result
print(result)

Option 2: Tidyverse (dplyr) #

If you prefer the tidyverse syntax, dplyr makes this clean with slice_head() and the near() function (built for safe floating-point comparisons):

library(dplyr)

# Example tibble (works with data frames too)
df <- tibble(
  values = c(0.001, -0.005, -0.010623, 0.02, -0.03)
)

# Slice up to the first occurrence of the target value
result <- df %>%
  slice_head(n = which(near(values, -0.010623))[1])

# View the result
print(result)

Key Notes: #

• Floating-point precision: Always use near() (dplyr) or an absolute difference check instead of == when comparing decimal values—this avoids missing matches due to tiny storage discrepancies.
• Multiple matches: If your target value appears multiple times, [1] ensures you only take the first occurrence. Remove it if you want to slice up to the last occurrence (use tail(which(...), 1) instead).

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