Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee

    Update your R script as follows:

     

    write.csv(dataset, file = "G:/xxx/xxx.csv", row.names = FALSE)

     

    Pat

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Perfect, thank you