I have big data set which consist of around  94 columns and 3 Million rows. This file have single as well as multiple spaces as delimiter between columns. I need to read some columns from this file in R. For this I tried using read.table() with options which can be seen in the code below, the code is pasted below-

    ### Defining the columns to be read from the file, the first 5 column, then we do not read next 24, after this we read next 5 columns. Last 60 columns are not read in-
    
        col_classes = c(rep(&quot;character&quot;,2), rep(&quot;numeric&quot;, 3), rep(&quot;NULL&quot;,24), rep(&quot;numeric&quot;, 5), rep(&quot;NULL&quot;, 60))   
    
    ### Reading first 100 rows of the data
    
        data &lt;- read.table(file, sep = &quot; &quot;,header = F, nrows = 100, na.strings =&quot;&quot;, stringsAsFactors= F)


Since, the file which has to read in have more than one space as the delimiter between some of the column, the above method does not work. Is there any method using which we can read in this file efficiently. 
             


All Delimited Solutions on Gang of Coders

Total of 1 Delimited Solutions

Reading text file with multiple space as delimiter in R