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.
Regards,
Alex
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 <er...@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)
> >>
> >> [1] 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@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.
> >
>
>
>
______________________________________________
R-help@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.
