[R] Best way to strsplit a column

From: Daniel Brewer <daniel.brewer_at_icr.ac.uk>
Date: Tue, 04 Mar 2008 13:54:51 +0000


I have a data.frame with a column that I would like to split into based around the delimiter ":". This is a useful feature in Excel. I cannot work out the best way to do it in R. I am sure you need to use strsplit, but that returns a list. The problem is that some values in the column do not contain a ":" so should have a "NA" in the second column of the result, and this makes doing an unlist a non-starter.

Any ideas?

Many thanks

Daniel Brewer

The Institute of Cancer Research: Royal Cancer Hospital, a charitable Company Limited by Guarantee, Registered in England under Company No. 534147 with its Registered Office at 123 Old Brompton Road, London SW7 3RP.

This e-mail message is confidential and for use by the a...{{dropped:2}}

R-help_at_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. Received on Tue 04 Mar 2008 - 14:07:49 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Tue 04 Mar 2008 - 14:30:20 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive