[R] problem with read.table
Vincent MUTEAUD
muteau at ensam.inra.fr
Mon Jul 19 10:05:56 CEST 2004
Hello R-users,
I apologize for my question but I'm a newbie. I want to read a file which
columns separator is "\t". At the end of each row there is a "\n" to go to
the following line. The three first lines are remarks lines and the fourth
contains columns titles ( variables names, ids, dates, calculated values,
observed values...) . I do:
read.table("myFile", header=TRUE, sep = "\t", skip = 3)
I obtain a strange result, lines are in a bad order:
cell6/voxel15 1998/365a 2.0 1.0 0.55
0.27480000257492065 0\nRendement de la
culture 0.0 crop4 0/0a 0.0 1.0 0.0 0.0
0\nRendement de la
culture 0.0 crop4 1998/75a 0.0 1.0 0.0 0.0
0\nRendement de la
culture 0.0 crop4 1998/150a 0.0 1.0 0.0 0.0
0\nRendement de la
culture 0.0 crop4 1998/225a 0.0 1.0 0.0 0.0
0\nRendement de la
culture 0.0 crop4 1998/300a 0.0 1.0 0.0
3.0368848 0\nRayonnement diffu
reçu 0.0 crop1 0/0a 0.0 2.0 0.0 0.0
0\nRayonnement diffu
reçu 0.0 crop1 1998/50a 0.0 2.0 0.0
6.8406434 0\nRayonnement diffu
reçu 0.0 crop1 1998/100a 0.0 2.0 0.0
14.235084 0\nRayonnement diffu
reçu 0.0 crop1 1998/150a 0.0 2.0 0.0 14.15452
0\nRayonnement diffu
reçu 0.0 crop1 1998/200a 0.0 2.0 0.0
13.691006 0\nRayonnement diffu
reçu 0.0 crop1 1998/250a 0.0 2.0 0.0
10.997387 0\nRayonnement diffu
reçu 0.0 crop1 1998/300a 0.0 2.0 0.0
10.333394 0\nRayonnement diffu
reçu 0.0 crop1 1998/350a 0.0 2.0 0.0 4.198115
0\nRayonnement diffu
reçu 0.0 crop9 0/0a 2.0 0.0 0.0 0.0
0\nRayonnement diffu
reçu 0.0 crop9 1998/50a 2.0 0.0 0.0
6.8406434 0\nRayonnement diffu
reçu 0.0 crop9 1998/100a 2.0 0.0 0.0
14.235084 0\nRayonnement diffu
reçu 0.0 crop9 1998/150a 2.0 0.0 0.0 14.15452
0\nRayonnement diffu
reçu 0.0 crop9 1998/200a 2.0 0.0 0.0
13.676454 0\nRayonnement diffu
reçu 0.0 crop9 1998/250a 2.0 0.0 0.0
10.983188 0\nRayonnement diffu
reçu 0.0 crop9 1998/300a 2.0 0.0 0.0
10.333394 0\nRayonnement diffu
reçu 0.0 crop9 1998/350a 2.0 0.0 0.0 4.198115
0\n
weighting id date x y z calculated observed
1 0 tree1 1998/365a 1.5 1.5 0.00 1.580000e+02 162.000
2 0 tree1 0/0a 1.5 1.5 0.00 6.242254e-03 0.007
3 0 tree1 1998/365a 1.5 1.5 0.00 1.038187e-02 0.011
4 0 tree1 1998/365a 1.5 1.5 0.00 1.008111e+00 0.000
5 0 cell4/voxel23 1998/365a 0.0 1.0 0.55 0.000000e+00 0.000
6 0 cell5/voxel18 1998/365a 1.0 1.0 0.25 0.000000e+00 0.000
7 0 cell5/voxel20 1998/365a 1.0 1.0 0.90 0.000000e+00 0.000
8 0 cell6/voxel15 1998/365a 2.0 1.0 0.55 0.000000e+00 0.000
9 NA NA NA NA NA NA
The "\n" is read like a word and not like a symbol to skip a line.
What should I do?
Thanks
More information about the R-help
mailing list