HI all, I am trying to read a csv file, but have a problem in the row names. After reading, the name of the first column is now "row.names" and all other column names are shifted to the right. The value of the last column become all NAs( as an extra column).
My sample data looks like as follow, filename = dat.csv The first row has a missing value at column 3 and 5. The last row has a missing value at column 1 and 5 x1,x2,x3,x4,x5 12,13,,14,, 22,23,24,25,26 ,33,34,34, To read the file I used this dsh<-read.csv(file="dat.csv",sep=",",row.names=NULL,fill=TRUE,header=TRUE,comment.char = "", quote = "", stringsAsFactors = FALSE) The output from the above is dsh row.names x1 x2 x3 x4 x5 1 12 13 NA 14 NA NA 2 22 23 24 25 26 NA 3 33 34 34 NA NA The name of teh frist column is row,banes and all values of last columns is NAs However, the desired output should be x1 x2 x3 x4 x5 12 13 NA 14 NA 22 23 24 25 26 NA 33 34 34 NA How can I fix this? Thank you in advance ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.
