英文:
How to overwrite/replace specific rows in R?
问题
You can merge the Data_new to Data and overwrite the old values using R. Here's an example of how to do it:
library(dplyr)merged_data <- Data %>%left_join(Data_new, by = c("ID", "Treatment")) %>%mutate(Value = coalesce(Value.y, Value.x)) %>%select(ID, Treatment, Value)
This code uses the dplyr package to left join Data_new to Data based on the "ID" and "Treatment" columns and then uses mutate to choose the new values if they exist (Value.y) or keep the old values (Value.x). Finally, it selects the desired columns.
英文:
I have a dataset containing some data obtained after a correction that should be merged with the primary dataset. I need a way to overwrite the old values with the new ones, but I don't know how.
Here is an example of what I have:
Data <- data.frame(ID = c("Gfa","Gfa","Gfa","Pka","Pka","Pka"),Treatment = c("Control","T1","T2","Control","T1","T2"),Value = c(3,4,6,2,9,7))Data_new <- data.frame(ID = c("Gfa","Pka","Pka"),Treatment = c("Control","Control","T2"),Value = c(5,2,8))
How can I merge the Data_new to the Data, overwriting only the new values?
答案1
得分: 4
Sure, here is the translated code:
library(dplyr)Data %>%rows_update(Data_new, by = c("ID", "Treatment"))
And here is the translated result:
结果ID Treatment Value1 Gfa 控制 52 Gfa T1 43 Gfa T2 64 Pka 控制 25 Pka T1 96 Pka T2 8
英文:
library(dplyr)Data %>%rows_update(Data_new, by = c("ID", "Treatment"))ResultID Treatment Value1 Gfa Control 52 Gfa T1 43 Gfa T2 64 Pka Control 25 Pka T1 96 Pka T2 8
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论