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_lk...@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 > > > > -- > > ______________________________________________ R-help@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.