[R] problem in reading data

[tedzzx]

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.