Forum Discussion
Anonymous
4 years agoNot applicable
Export table to csv using r script adds extra column
Hi
I have a simple r script (below) which is exporting a table into csv and saving in a local area. This all works fine, however when the file exports, it adds a blank column at the beginning with the row number for each record. Does anyone know how to stop this from happening?
write.csv(dataset, file = "G:/xxx/xxx.csv")
Any help greatly appreciated
Update your R script as follows:
write.csv(dataset, file = "G:/xxx/xxx.csv", row.names = FALSE)
Pat
2 Replies
- mahoneypatMicrosoft Employee
Update your R script as follows:
write.csv(dataset, file = "G:/xxx/xxx.csv", row.names = FALSE)
Pat
- AnonymousNot applicable
Perfect, thank you