[R] read.table

Gabor Grothendieck ggrothendieck at gmail.com
Tue Feb 14 02:11:50 CET 2006


You can do it manually by reading in the headers separately:

headers <- read.table(test, header = FALSE, nrow = 1, sep = ";", as.is = TRUE)
read.table(test, header = FALSE, skip = 1, sep = ";", col.names = headers)

On 2/13/06, Diethelm Wuertz <wuertz at itp.phys.ethz.ch> wrote:
>
>
> I have a file named "test.csv" with the following 3 lines:
>
> %y-%m-%d;VALUE
> 1999-01-01;100
> 2000-12-31;999
>
>
>  > read.table("test.csv", header = TRUE, sep = ";")
>
> delivers:
>
>   X.y..m..d VALUE
> 1 1999-01-01   100
> 2 2000-12-31   999
>
>
> I would like to see the following ...
>
>    %y-%m-%d VALUE
> 1 1999-01-01   100
> 2 2000-12-31   999
>
>
> Note,
>
>  > readLines("test.csv", 1)
>
> delivers
>
> [1] "%y-%m-%d;VALUE"
>
>
> Is this possible ???
>
>
> Thanks DW
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
>




More information about the R-help mailing list