On Thu, 29 Jul 2010, kayj wrote:
Hi All,
I have a dataset that I would like to split based on : or – ( the data file
is tab delimited) for example:
Ny:23-45 AC
BA:88-91 DB
KJ:21-13 PA
And I would like the data to be splitted and the final results look like
NY 23 45 AC
BA 88 91 DB
KJ 21 13 PA
read.table(textConnection(gsub("[-:]","\t",readLines("your.data.file.tab"))))
or
read.table(textConnection(chartr("-:","\t\t",readLines("your.data.file.tab"))))
HTH,
Chuck
I would like to have the resulting data as a data frame so each column is a
variable.
Thanks,
--
View this message in context:
http://r.789695.n4.nabble.com/help-splitting-a-data-frame-tp2306832p2306832.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
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.
Charles C. Berry (858) 534-2098
Dept of Family/Preventive Medicine
E mailto:cbe...@tajo.ucsd.edu UC San Diego
http://famprevmed.ucsd.edu/faculty/cberry/ La Jolla, San Diego 92093-0901
______________________________________________
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.
