[R] Increasing the maximum number of rows
Alex Ruiz E.
rruizeuler at ucsd.edu
Sat May 22 23:19:57 CEST 2010
Hi thank you both for your answers.
I did verify that the number of rows in the csv is actually ~207,000,
both in the MySQL output and then directly in the csv file. The line
128328 looks exactly as all others above and below.
I tried the comment.char and quote parameters and it turns out that the
quote parameter worked. I appreciate the pointer.
On Sat, 2010-05-22 at 08:04 -0400, jim holtman wrote:
> You might also try setting the following parameters on read.csv:
> comment.char='', quote=''
> If you have a "#", this might cause missing data; also an unbalanced
> quote will cause missing lines.
> On Sat, May 22, 2010 at 2:12 AM, Erik Iverson <eriki at ccbr.umn.edu> wrote:
> > Alex Ruiz E. wrote:
> >> Dear R helpers,
> >> I created a somewhat big database (+206,700 rows) in MySQL and have
> >> exported into a csv file, but I can't open the whole thing in R. I am
> >> using:
> >>> base<-read.csv("/path/to/file.csv", header=F, sep="," nrows=206720)
> >> R doesn't complain but it only opens 128,328 observations (the number of
> >> columns corresponds to the original database):
> >>> dim(base)
> >>  128328 134
> > Have you verified that file.csv does indeed contain the number of rows you
> > think it does? Can you go to line 128328 of the CSV file and look if it's
> > any different?
> > ______________________________________________
> > 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.
More information about the R-help