problem in reading data
Dear jholtman, The problem is that in this case, it seems that the blank is not replaced by NA according to the information I quote. It is replaced by blank. I have try: which(is.na(a$V4)), but get NA. I want to delete the rows that have different format from others.
jholtman wrote:
In some cases the missing values have been replaced by NAs so you can look for those. On Thu, Apr 30, 2009 at 9:28 AM, tedzzx <zengzhenxing at gmail.com> wrote:
Dear R users
I am runing into a problem in reading data in R
This is the error information
a<-read.table("tt_mb_200409.txt",as.is=T)
Error in scan(file, what, nmax, sep, dec, quote, skip, nlines,
na.strings,
:
line 1653997 did not have 5 elements
It seams that some lines don't have equal variables. I want to try
a<-read.table("tt_mb_200409.txt",as.is=T,fill=T)
a[1653997,]
V1 V2 V3 V4 V5 1653997 00992 2777010 But, I want to delect the rows that do not have the same number of variables with others, how can I do this? Many thanks Ted -- View this message in context: http://www.nabble.com/problem-in-reading-data-tp23316321p23316321.html Sent from the R help mailing list archive at Nabble.com.
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html<http://www.r-project.org/posting-guide.html> and provide commented, minimal, self-contained, reproducible code.
-- Jim Holtman Cincinnati, OH +1 513 646 9390 What is the problem that you are trying to solve? [[alternative HTML version deleted]]
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
View this message in context: http://www.nabble.com/problem-in-reading-data-tp23316321p23327660.html Sent from the R help mailing list archive at Nabble.com.