Hi,
The other day, for kaggle I had to read a csv file into R. It was around 4GB in size. None of the text editors were able to open the file. Even Access text import failed. I had to work with a macro or had to look at open source RDBMS like MySql. Luckily, my teammate gave me the idea of using file stream reader and writers in Java, Also my manager showed me this link.
I didn’t need to read the entire file, for initial experiments I needed only a part of the file. So, the below is a code snippet to get a part of the csv;
# initializing file readers
x<-file('extra_unsupervised_data.csv','rt')
x
y<-file('unsupervised_trim.csv','wt')
y
# reading lines
line<-readLines(x,n=10001)
# writing lines
cat(line,file='unsupervised_trim.csv',fill=TRUE)
# closing files
close(x)
close(y)
May this snippet save you some time!!!!!
BIdesi 