Weird read.xls behavior
On May 10, 2011, at 10:54 AM, Jun Shen wrote:
Hi, Kenneth,
I would like a bit more advice on how to use gsub to remove the
spaces at
the beginning or the end for a data frame and still keep the data
frame in
the same format. The way I see is something like
gsub(' *$', '' , unlist(dataframe)). But the result is not a data
frame
anymore. Thanks.
1) Please do not attach unrelated questions to existing threads. 2) Please do include reproducible code that creates an example to work with. 3) Please do read the help page for gsub with careful attention to the datatypes it expects as input and the values it will return.
David. > Jun > > On Mon, May 9, 2011 at 11:01 PM, Kenneth Roy Cabrera Torres < > krcabrer at une.net.co> wrote: > >> Maybe in the original there are some "ghost" spaces after ng/ml, >> verify them. >> >> Any way you can erase the first and the last white spaces with gsub >> function. >> >> HTH >> >> Kenneth >> El lun, 09-05-2011 a las 22:44 -0500, Jun Shen escribi?: >>> Dear list, >>> >>> I used read.xls to read in an excel file, which has both character >>> and >>> numeric columns. Everything seems fine except in the last column, >>> I have >>> this character value "ng/ml". When reading in, read.xls seems to >>> add a >> space >>> at the end of it, became "ng/ml ". How can I prevent read.xls >>> doing so? >>> Thanks. >>> >>>> read.xls(data, header=T, as.is=T) >>> >>> Jun >>> >>> [[alternative HTML version deleted]] >>> >>> ______________________________________________ >>> 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. >> >> >> > > [[alternative HTML version deleted]] > > ______________________________________________ > 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. David Winsemius, MD West Hartford, CT