我从头开始自学R,主要是通过做某事,然后阅读这些帖子,以及基于此的反复试验 . 有时候我会撞墙而伸出手 .
我撞墙了 . 我安装了dplyr 0.7 . 我有一个列的字节 - 称之为 contract_key
- 我通过将mutate(coalesce())应用于tibble中的其他三个列来添加 . 这是样本数据:
product <- c("655393265191","655393265191","168145850127","168145850127","350468621217","350468621217","977939797847","NA","928893912852")
supplier <- c("person5","person3","person10","person5","person11","person5","person11","person14","person5")
vendor <- c("org2","org3","org3","org2","org1","org2","org1","org5","org2")
quantity <- c(7,5,6,1,2,1,18,2,2)
gross <- c(0.0419,0.0193,0.0439,0.0069,0.0027,0.0055,0.0233,NA,0.0004)
df <- data_frame(product,supplier,vendor,quantity,gross)
这是我生成 contract_key
的方式:
df <- df %>%
mutate(contract_key = coalesce(product,supplier,vendor))
我现在想要添加另一列,根据提供内容的三列中的哪一列(通过coalesce())对 contract_key
的内容进行分类 . 因此,如果contract_key = "person5",则新列contract_level将为"supplier" . contract_key = "org2"将映射到contract_level = "vendor"等 .
基本上,我将使用 contract_level
作为另一个tibble的连接变量 .
我_325959已经尝试了 if_else
,我看到我不应该费心 case_when
(因为它's inside mutate()). I'也尝试嵌套_325963的无济于事 .
它可能是我不知道的基本R语法 . 与点符号和语法有关 . 如果有人提供答案,我会回溯,直到我弄清楚你做了什么 . (而且我将在R中学到新的一课!)
谢谢!
1 回答
这个怎么样:
其他需要较少代码的选项: