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!
On Tuesday 12 July 2011 06:09:18 Sarah Goslee wrote:
> 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]))
> 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])
> >  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