[R] Weird read.xls behavior

David Winsemius dwinsemius at comcast.net
Tue May 10 16:59:32 CEST 2011


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



More information about the R-help mailing list