Skip to Content
Home » Questions » Inserting a large csv file into R

Inserting a large csv file into R

Submitted by Ali Tamaddoni on August 18, 2012

I have a mid-size csv file (comma delimited) with 4483745 observations. I am trying to insert it to R. using the following command:

df<-read.table("myfile.csv",sep=",")

but when I run this it gives me an empty data frame with column one's name as: 'ÿþ3'

however when I take a small sample of this file, it works well and I get my data frame.

Sample of Raw Data:

id,date.time,duration,in.out,type
3051,01-01-08 11:09:23,25,1,N                                                  
3136,01-01-08 11:09:27,6,1,N                                                   
2923,01-01-08 11:07:17,70,1,N                                                  
2394,01-01-08 11:08:43,19,1,N                                                  
2814,01-01-08 11:10:35,7,1,N                                                   
1977,01-01-08 11:08:09,70,1,N

can anyone help my with this problem?

Thanks in advance.