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.
>
--
Jim Holtman
Cincinnati, OH
+1 513 646 9390
What is the problem that you are trying to solve?
______________________________________________
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.
