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

Marc Schwartz MSchwartz at mn.rr.com
Sun Jul 10 22:18:59 CEST 2005


On Sun, 2005-07-10 at 18:13 +0000, 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?
> 
> TIA,
> Adrian

With your example data saved in a file called "test.txt":

> df <- read.table("test.txt", header = TRUE, colClasses = "character")

> df
  name surname answer
1   xx     yyy  00100
2  rrr     hhh     01

> str(df)
`data.frame':	2 obs. of  3 variables:
 $ name   : chr  "xx" "rrr"
 $ surname: chr  "yyy" "hhh"
 $ answer : chr  "00100" "01"


See the colClasses argument in ?read.table.

HTH,

Marc Schwartz




More information about the R-help mailing list