如何修改DataFrame中的特定值？针对给定R数据框的修改需求

Hey there! Let's work through your question step by step—first addressing your specific data frame modification, then covering general methods for tweaking specific values in R DataFrames.

First, let's recreate your data frame to align on the starting point:

test2 <- data.frame(id = c(1, 2), score = c(0, 100))

To make your requested changes (swap id=1 for "John" and id=2 for 3), you can use logical indexing to target exactly the rows you want to modify:

# Replace id=1 with "John"
test2$id[test2$id == 1] <- "John"

# Replace id=2 with 3
test2$id[test2$id == 2] <- 3

After running this, your test2 data frame will look like this:

id score
1 John     0
2    3   100

Quick note: Mixing character ("John") and numeric (3) values in the id column will automatically convert the entire column to character type in R. If you need the column to stay numeric, you'd want to use a numeric identifier for John (like 0 or another unique number) instead.

Here are several flexible approaches you can use for different scenarios:

1. Logical Indexing (Most Widely Used) #

This is the go-to for targeting values based on conditions, works for single or bulk changes:

# Example: Change all scores of 100 to 95
test2$score[test2$score == 100] <- 95

# Example: Swap "John" back to 1 in a character id column
test2$id[test2$id == "John"] <- 1

2. Tidyverse Style with dplyr #

If you prefer the tidyverse workflow, use mutate() combined with case_when() for multiple replacement rules at once. First, install/load dplyr if you haven't:

install.packages("dplyr")
library(dplyr)

Then apply your changes in a single pipeline:

test2 <- test2 %>%
  mutate(id = case_when(
    id == 1 ~ "John",
    id == 2 ~ 3,
    TRUE ~ id  # Keep any other values unchanged
  ))

3. Direct Position Indexing #

If you know the exact row and column positions of the value to modify, use bracket notation [row, column]:

# Change row 1, column 1 to "John"
test2[1, 1] <- "John"

# Change row 2, column 1 to 3
test2[2, 1] <- 3

This is great for fixed positions, but less flexible if your data's order might change.

4. Base R's replace() Function #

A concise way to swap values in a single column by specifying the target vector, condition, and replacement:

test2$id <- replace(test2$id, test2$id == 1, "John")
test2$id <- replace(test2$id, test2$id == 2, 3)

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