Re: [R] problems in read.table-Solved
Thank you very much for help. I am learning R every day
Taka
Quoting Peter Dalgaard <[EMAIL PROTECTED]>:
> [EMAIL PROTECTED] wrote:
>> Dear R-users,
>>
>> I have encountered the following problem every now and then. But I
>> was dealing with a very small dataset before, so it wasn't a problem
>> (I just edited the dataset in Openoffice speadsheet). This time I
>> have to deal with many large datasets containing commuting flow
>> data. I appreciate if anyone could give me a hint or clue to get out
>> of this problem.
>>
>> I have a .dat file called "1081.dat": 1001 means Birmingham, AL.
>>
>> I imported this .dat file using read.table like
>> tmp<-read.table('CTPP3_ANSI/MPO3441_ctpp3_sumlv944.dat',header=T)
>>
>> Then I got this error message:
>> Error in scan(file, what, nmax, sep, dec, quote, skip, nlines,
>> na.strings, :
>> line 9499 did not have 209 elements
>>
>> Since I got an error message saying other rows did not have 209
>> elements, I added skip=c(205,9499,9294)) in hoping that R would take
>> care of this problem. But I got a similar error message:
>> tmp<-read.table('CTPP3_ANSI/MPO3441_ctpp3_sumlv944.dat',header=T,skip=c(205,9499,9294))
>> Error in scan(file, what, nmax, sep, dec, quote, skip, nlines,
>> na.strings, :
>> line 9294 did not have 209 elements
>> In addition: Warning message:
>> the condition has length > 1 and only the first element will be used
>> in: if (skip > 0) readLines(file, skip)
>>
>> Is there any way to let a R code to automatically skip problematic
>> rows? Thank you very much!
>>
>>
> Skip is the NUMBER of rows to skip before reading. It has to be a
> single number.
>
> You can use fill and flush to read lines with too few or too many
> elements, but it might be better to investigate the cause of the
> problem. What are in those lines? Quote and comment characters are
> common culprits.
>
>> Taka
>>
>> __
>> R-help@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
>> and provide commented, minimal, self-contained, reproducible code.
>>
>
>
> --
> O__ Peter Dalgaard Øster Farimagsgade 5, Entr.B
> c/ /'_ --- Dept. of Biostatistics PO Box 2099, 1014 Cph. K
> (*) \(*) -- University of Copenhagen Denmark Ph: (+45) 35327918
> ~~ - ([EMAIL PROTECTED]) FAX: (+45) 35327907
>
>
>
Takatsugu Kobayashi
PhD Student
Indiana University, Dept. Geography
__
R-help@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
and provide commented, minimal, self-contained, reproducible code.
Re: [R] problems in read.table
[EMAIL PROTECTED] wrote:
> Dear R-users,
>
> I have encountered the following problem every now and then. But I was
> dealing with a very small dataset before, so it wasn't a problem (I
> just edited the dataset in Openoffice speadsheet). This time I have to
> deal with many large datasets containing commuting flow data. I
> appreciate if anyone could give me a hint or clue to get out of this
> problem.
>
> I have a .dat file called "1081.dat": 1001 means Birmingham, AL.
>
> I imported this .dat file using read.table like
> tmp<-read.table('CTPP3_ANSI/MPO3441_ctpp3_sumlv944.dat',header=T)
>
> Then I got this error message:
> Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, :
> line 9499 did not have 209 elements
>
> Since I got an error message saying other rows did not have 209
> elements, I added skip=c(205,9499,9294)) in hoping that R would take
> care of this problem. But I got a similar error message:
> tmp<-read.table('CTPP3_ANSI/MPO3441_ctpp3_sumlv944.dat',header=T,skip=c(205,9499,9294))
> Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, :
> line 9294 did not have 209 elements
> In addition: Warning message:
> the condition has length > 1 and only the first element will be used
> in: if (skip > 0) readLines(file, skip)
>
> Is there any way to let a R code to automatically skip problematic
> rows? Thank you very much!
>
>
Skip is the NUMBER of rows to skip before reading. It has to be a single
number.
You can use fill and flush to read lines with too few or too many
elements, but it might be better to investigate the cause of the
problem. What are in those lines? Quote and comment characters are
common culprits.
> Taka
>
> __
> R-help@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
> and provide commented, minimal, self-contained, reproducible code.
>
--
O__ Peter Dalgaard Øster Farimagsgade 5, Entr.B
c/ /'_ --- Dept. of Biostatistics PO Box 2099, 1014 Cph. K
(*) \(*) -- University of Copenhagen Denmark Ph: (+45) 35327918
~~ - ([EMAIL PROTECTED]) FAX: (+45) 35327907
__
R-help@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
and provide commented, minimal, self-contained, reproducible code.
Re: [R] problems in read.table
See ?count.fields to get a vector of how many fields are on each line.
Also fill = TRUE on read.table() can be used to fill out short lines if
that is appropriate.
On 9/6/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Dear R-users,
>
> I have encountered the following problem every now and then. But I was
> dealing with a very small dataset before, so it wasn't a problem (I
> just edited the dataset in Openoffice speadsheet). This time I have to
> deal with many large datasets containing commuting flow data. I
> appreciate if anyone could give me a hint or clue to get out of this
> problem.
>
> I have a .dat file called "1081.dat": 1001 means Birmingham, AL.
>
> I imported this .dat file using read.table like
> tmp<-read.table('CTPP3_ANSI/MPO3441_ctpp3_sumlv944.dat',header=T)
>
> Then I got this error message:
> Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, :
>line 9499 did not have 209 elements
>
> Since I got an error message saying other rows did not have 209
> elements, I added skip=c(205,9499,9294)) in hoping that R would take
> care of this problem. But I got a similar error message:
> tmp<-read.table('CTPP3_ANSI/MPO3441_ctpp3_sumlv944.dat',header=T,skip=c(205,9499,9294))
> Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, :
>line 9294 did not have 209 elements
> In addition: Warning message:
> the condition has length > 1 and only the first element will be used
> in: if (skip > 0) readLines(file, skip)
>
> Is there any way to let a R code to automatically skip problematic
> rows? Thank you very much!
>
> Taka
>
> __
> R-help@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
> and provide commented, minimal, self-contained, reproducible code.
>
__
R-help@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
and provide commented, minimal, self-contained, reproducible code.
Re: [R] problems in read.table
Dear R-users,
I have encountered the following problem every now and then. But I was
dealing with a very small dataset before, so it wasn't a problem (I
just edited the dataset in Openoffice speadsheet). This time I have to
deal with many large datasets containing commuting flow data. I
appreciate if anyone could give me a hint or clue to get out of this
problem.
I have a .dat file called "1081.dat": 1001 means Birmingham, AL.
I imported this .dat file using read.table like
tmp<-read.table('CTPP3_ANSI/MPO3441_ctpp3_sumlv944.dat',header=T)
Then I got this error message:
Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, :
line 9499 did not have 209 elements
Since I got an error message saying other rows did not have 209
elements, I added skip=c(205,9499,9294)) in hoping that R would take
care of this problem. But I got a similar error message:
tmp<-read.table('CTPP3_ANSI/MPO3441_ctpp3_sumlv944.dat',header=T,skip=c(205,9499,9294))
Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, :
line 9294 did not have 209 elements
In addition: Warning message:
the condition has length > 1 and only the first element will be used
in: if (skip > 0) readLines(file, skip)
Is there any way to let a R code to automatically skip problematic
rows? Thank you very much!
Taka
__
R-help@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
and provide commented, minimal, self-contained, reproducible code.
