如何在R中的data.table对象的单列中分隔两个值?
要data.table在R中对象的单列中分隔两个值,我们可以按照以下步骤操作-
首先,创建一个data.table对象。
然后,使用tidyr包中的单独函数来分隔单列中的值。
示例
创建data.table对象
让我们创建一个data.table对象,如下所示-
library(data.table)
DT<-
data.table(x=sample(c("A,B","B,C","C,D","D,E","E,F","F,G","G,H"),25,replace=TRUE))
DT输出结果执行时,上述脚本生成以下内容output(thisoutputwillvaryonyoursystemduetorandomization)-
x
1: C,D
2: C,D
3: C,D
4: A,B
5: F,G
6: A,B
7: C,D
8: G,H
9: B,C
10: C,D
11: G,H
12: G,H
13: G,H
14: C,D
15: F,G
16: G,H
17: C,D
18: C,D
19: F,G
20: G,H
21: E,F
22: A,B
23: G,H
24: D,E
25: F,G
x在列中分隔值
使用tidyr包中的单独函数来分隔data.table对象DT的x列中的值-
library(data.table)
DT<-
data.table(x=sample(c("A,B","B,C","C,D","D,E","E,F","F,G","G,H"),25,replace=TRUE))
library(tidyr)
DT %>% separate(x,c("Group1","Group2"),sep=",")输出结果Group1 Group2 1: C D 2: C D 3: C D 4: A B 5: F G 6: A B 7: C D 8: G H 9: B C 10: C D 11: G H 12: G H 13: G H 14: C D 15: F G 16: G H 17: C D 18: C D 19: F G 20: G H 21: E F 22: A B 23: G H 24: D E 25: F G Group1 Group2