我有一个大的R数据.框架,其中我有重复的化学名称,第二列中有不同的"结果"和"使用"值.我想合并这些,这样每个化学物质就有一行,所有"结果"和"使用"值都在各自列的单个单元格中以逗号分隔.
示例DF:
df1 <- data.frame(Name=c("reservatol","reservatol","reservatol","DPG"),
Result = c("naturally occurring", "antagonist", "synthetic", "rubber"),
Use = c("Pharma", "Pharma", "Drugs and Medication", "Tires"))
Name Result Use
1 reservatol naturally occurring Pharma
2 reservatol antagonist Pharma
3 reservatol synthetic Drugs and Medication
4 DPG rubber Tires
有没有办法让它看起来像这样?
Name Result Use
1 reservatol naturally occurring, antagonist, synthetic Pharma, Drugs and Medication
2 DPG rubber Tires
我try 使用group_by