Hello,
By looking at the output of
pat <- "(str)|(_name)|( name)"
strsplit(c("str1_name2", "str3_name5"), pat)
[[1]]
[1] "" "1" "2"
[[2]]
[1] "" "3" "5"
I could understand why colsplit includes NAs as column 'str' values.
So the hack is to fake we want three coluns and then set the first one
to NULL.
df2 <- data.frame(df1, colsplit(df1$x, pattern = pat, names=c("Null",
"str","name")))
df2$Null <- NULL
df2
I don't like it very much but it's simple and it works.
Hope this helps,
Rui Barradas
Em 27-09-2012 12:25, Johannes Radinger escreveu:
Hi,
I am using colsplit (package = reshape) to split all strings
in a column according to the same patterns. Here
an example:
library(reshape2)
df1 <- data.frame(x=c("str1_name2", "str3_name5"))
df2 <- data.frame(df1, colsplit(df1$x, pattern = "_", names=c("str","name")))
This is nearly what I want but I want to remove the words "str" and
"name" from the values, because the columns are already named with
that words. Is there a way to remove them using colsplit? Or any other
simple way?
/johannes
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.