Hi, when I used:
Dist=read.csv("test.csv",header=TRUE)
to read data from CSV file. For some cells, R
mistakenly put in as NA, while most of the cells still
appears to be right, and there is no error message in
R. I am pretty sure the csv file is all right, but
just can't figure out what went wrong. Can someone
share your thoughts with me? Thanks!
Ed
NA when using read.csv
3 messages · Haibo Huang, Gabor Grothendieck, Wuming Gong
On 8/1/05, Haibo Huang <edhuang00 at yahoo.com> wrote:
Hi, when I used:
Dist=read.csv("test.csv",header=TRUE)
to read data from CSV file. For some cells, R
mistakenly put in as NA, while most of the cells still
Its not likely that there are errors in this software so its probably not a mistake but some other cause.
appears to be right, and there is no error message in R. I am pretty sure the csv file is all right, but just can't figure out what went wrong. Can someone share your thoughts with me? Thanks!
Read the posting guide at the bottom of each post. In particular, cut down the input file to a few lines that still exhibit the problem in order to provide a reproducible example. As an aside note that 'header = TRUE' is the default in read.csv (but not on read.table) so you don't need to specify it.
Hi Haibo, Are there any character "#" in the cells? By default, the things at the right side of the character "#" will be masked as comments. Wuming
On 8/2/05, Gabor Grothendieck <ggrothendieck at gmail.com> wrote:
On 8/1/05, Haibo Huang <edhuang00 at yahoo.com> wrote:
Hi, when I used:
Dist=read.csv("test.csv",header=TRUE)
to read data from CSV file. For some cells, R
mistakenly put in as NA, while most of the cells still
Its not likely that there are errors in this software so its probably not a mistake but some other cause.
appears to be right, and there is no error message in R. I am pretty sure the csv file is all right, but just can't figure out what went wrong. Can someone share your thoughts with me? Thanks!
Read the posting guide at the bottom of each post. In particular, cut down the input file to a few lines that still exhibit the problem in order to provide a reproducible example. As an aside note that 'header = TRUE' is the default in read.csv (but not on read.table) so you don't need to specify it.
______________________________________________ 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