gpt4 book ai didi

在 R 中重新排列数据框中的信息

转载 作者:行者123 更新时间:2023-12-01 16:23:34 25 4
gpt4 key购买 nike

我有以下 df,它是从 excel 文件中获得的:

df1 <- data.frame( Colour = c("Green","Red","Blue"), 
Code = c("N","U", "U"),
User1 = c("John","Brad","Peter"),
User2 = c("Meg","Meg","John"),
User3= c("", "Lucy", ""))

我需要重新排列它以获得一个数据框,其中所有名称都列在第一列(仅一次)并且颜色(和各自的代码)出现在以下列中,如下所示:

df2 <- data.frame(User=c("John","Brad","Peter","Meg","Lucy"),
Color1 = c("Green","Red","Blue","Green","Red"),
Code1 = c("N","U","U","N","U"),
Color2=c("Blue","","","Red",""),
Code2=c("U","","","U",""))

非常感谢您的帮助。非常感谢,

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com