Re: [R] not supressing leading zeros when reading a table?

From: Duncan Murdoch <>
Date: Mon 11 Jul 2005 - 06:20:23 EST

Adrian Dusa wrote:
> Dear R list,
> I have a dataset with a column which should be read as character, like this:
> name surname answer
> 1 xx yyy "00100"
> 2 rrr hhh "01"
> When reading this dataset with read.table, I get
> 1 xx yyy 100
> 2 rrr hhh 1
> The string column consists in answers to multiple choice questions, not all
> having the same number of answers. I could format the answers using formatC but
> there are over a hundred different questions in there.
> I tried with quote="\"'" without any luck. Googling after this take me nowhere
> either. It should be simple but I seem to miss it...
> Can anybody point me to the right direction?

By default, read.table guesses about the column type. Yours looks numeric, even though it is not.

Use the colClasses argument of read.table to specify the column type. If you only have the 3 columns above, colClasses="character" should work.

Duncan Murdoch mailing list PLEASE do read the posting guide! Received on Mon Jul 11 06:32:22 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:33:27 EST