[R] "as.numeric"

Rainer Schuermann Rainer.Schuermann at gmx.net
Tue Jul 12 14:33:27 CEST 2011


It may be helpful to make sure that, in the dialog that pops up when saving a spreadsheet to CSV, the option "Save cell content as shown" is checked - that 
would leave numbers as numbers, not wrapping them in "". That has helped me at least in a similar situation!
Rgds,
Rainer


On Tuesday 12 July 2011 06:09:18 Sarah Goslee wrote:
> Jessica,
> 
> This would be easier to solve if you gave us more information, like str(PE).
> 
> However, my guess is that your data somewhere has a nonnumeric value in that
> column, so the entire column is being imported as factor. It's not
> "really awful" -
> R is converting those factor values to their numeric levels, just as you asked.
> 
> The best solution is to find and deal with the nonnumeric value before
> you import
> your data (something else you did not tell us about). Failing that, you may find
> this useful:
> as.numeric(as.character(PE[1, 90:99]))
> 
> Sarah
> 
> On Tue, Jul 12, 2011 at 4:38 AM, Jessica Lam <ma_lkyac at yahoo.com.hk> wrote:
> > Dear R user,
> >
> > After I imported data (csv format) in R, I called it out. But it is in
> > non-numeric format.
> > Then using "as.numeric" function.
> > However, the output is really awful !!!!!
> >
> >> PE[1,90:99]
> >           V90          V91          V92          V93          V94
> > V95          V96          V97          V98          V99
> > 1  16.8467742   17.5853166   19.7400328   21.7277241   21.5015489
> > 19.1922102   20.3351524   18.1615471   18.5479946   16.8983887
> >
> >> as.numeric(PE[1,90:99])
> >  [1] 11 10 11 10 11  9 10  9  9  8
> >
> >  How can I solve the above problem??
> >
> > Thanks so much!
> > Jessica
> >
> > --
> 
>



More information about the R-help mailing list