I have a file with 21 fields as headers in the first row. The remaining rows have unequal number of fields, some of the rows have more columns than the headers. When i tried to read it using read.delim(), it shows the error:duplicate 'row.names' are not allowed. And when row.names=NULL is given, it reads the data without error but the total row count is more than the original number. Could someone help how to read the data properly in this case?
Here is the link to the sample file: http://www.fileconvoy.com/dfl.php?id=ge13fc2a43090ca2c999307592170df128be67740f
Any help is valuable.