Re: [R] Quick fix formatting

From: <Richard.Cotton_at_hsl.gov.uk>
Date: Mon, 07 Apr 2008 18:17:19 +0100


> I have two data frames and am running a loop to match similar rows.
> However the matching is not working well, and I suspect it is because of
> the different formats of columns. For example, in col. 1 of dataframe 1
> the nummbers are formatted as 1,2,3,4,5,6,7,8,9...31 However in col. 1
> dataframe 2 the numbers are 01,02,03,04,05,06,07,08,09...31 After
> investigation it seems only the numbers below 10 do not match up well
> (i.e. those with a 0 in).
>
> My question is: is there a quick fix so I can convert the first set of
> numbers into the format of the second? I could write a loop and if
> statement but that seems a lot and I thought there must be an easier way
> out there. However having searched the archives, nothing has appeared.

Method 1:
Use numbers that are of type numeric, rather than strings with digits in them. Take a look at ?as.numeric for the conversion.

Method 2:
Reformat the strings using format, or formatC. These both accept vector inputs, so you can format a whole column with one command.

Regards,
Richie.

Mathematical Sciences Unit
HSL



ATTENTION: This message contains privileged and confidential inform...{{dropped:20}}

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 Mon 07 Apr 2008 - 17:20:46 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 Mon 07 Apr 2008 - 17:30:26 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