[R] Dividing one column of form xx-yy into two columns, xx and yy
Peter.Alspach at plantandfood.co.nz
Tue Feb 9 01:09:40 CET 2010
Tena koe Mike
for post input separation. AFAIK there is one cannot specify multiple
fortune('this is R')
> -----Original Message-----
> From: r-help-bounces at r-project.org
> [mailto:r-help-bounces at r-project.org] On Behalf Of ZeMajik
> Sent: Tuesday, 9 February 2010 12:32 p.m.
> To: R mailing list
> Subject: [R] Dividing one column of form xx-yy into two
> columns, xx and yy
> I have a data set where one column consists of two numerical
> factors, separated by a "-".
> So my data looks something like this:
> There are additional columns consisting of single factors as
> well, so reading the csv file (where the data is stored) with
> the sep="-" addition won't work since the rest of the factors
> are separated by commas.
> So first of all, is there any way to import a file which is
> separated by ","
> OR "-"?
> If this is not possible, does anyone have any ideas how I
> could go about to separate these? I could use a text editor
> to replace the - with , and import, but I would prefer doing
> this inside of R so that making a script could be used in the future.
> Just to clarify, I would like the above to turn out as two
> separate columns (or vectors) where the first in this would
> be (43,43,1267,....) and the second (156,43,18,.....) The
> dataset is rather large, with a few hundred thousand lines,
> so it would be preferable to keep resource intensive methods
> to a minimum if possible.
> Thanks in advance!
> [[alternative HTML version deleted]]
> R-help at r-project.org mailing list
> PLEASE do read the posting guide
> and provide commented, minimal, self-contained, reproducible code.
More information about the R-help