Hi,
You could use ?strsplit()
dat <- read.table(text="'Column
1'???????????????????????????????????????????
'AAA--> BBB'??????????????????????????????????????????
'CCC-->
DDD'",sep="",header=TRUE,check.names=FALSE,stringsAsFactors=FALSE)??
dat1 <- setNames(as.data.frame(do.call(rbind,strsplit(dat[,1],"-->
")),stringsAsFactors=FALSE),paste("Column", 1:2))
dat1
#? Column 1 Column 2
#1????? AAA????? BBB
#2????? CCC????? DDD
#or
dat2 <- setNames(read.table(text=gsub("[^[:alnum:]]+","
",dat[,1]),sep="",header=FALSE,stringsAsFactors=FALSE),paste("Column",
1:2))
identical(dat1,dat2)
#[1] TRUE
A.K.
Hi All,
I am using Association Algorithm in RStudio.
I am facing a situation, where I need to Split the Single column value into Two
column values.
Eg:
?Column 1 ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?Column 1 ? ? ? ? ? ? ?
Column 2
AAA--> BBB ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?AAA ? ? ? ? ? ? ? ? ?
? ?BBB
CCC--> DDD ? ? ? ? ? ? ? ? ? ? into ? ? ? ? ? ? ? ? ? CCC ? ? ? ? ? ? ? ? ? ?
?DDD
Can anyone help me in this ?
Thanks,
Praveen