R programming, naming output file using variable

Question

I would like to direct output to a file, using a write.csv statement. I am wanting to write 16 different output files, labeling each one with the extension 1 through 16.

Example as written now:

    trackfilenums=1:16
    for (i in trackfilenums){
       calculations etc
       write.csv(max.hsi, 'Severity_Index.csv', row.names=F)
    }

I would like for the output csv files to be labeled 'Severity_Index_1.csv', 'Severity_Index_2.csv', etc. Not sure how to do this in R language.

Thanks! Kimberly

juba · Accepted Answer · 2013-09-19 19:23:10Z

13

You will want to use the paste command:

write.csv(max.hsi, paste0("Severity_Index_", i,".csv"), row.names=F)

edited Sep 19, 2013 at 19:23

juba

49.3k14 gold badges116 silver badges121 bronze badges

answered Sep 19, 2013 at 19:07

Sarah

7517 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

juba Over a year ago

The variable is already here as i, and you can use paste0 to shorten the code a bit. Which gives : paste0('Severity_Index_',i,'.csv')

Sarah Over a year ago

you're right @juba, I completely missed the 'i'.I've updated my answer to reflect it. I didn't know about the paste0 command - Thanks!

lebatsnok · Accepted Answer · 2013-09-19 19:37:26Z

1

Some people like to have file names like Name_01 Name_02 etc instead of Name_1 Name_2 etc. This may, for example, make the alphabetical order more reasonable: with some software, otherwise, 10 would come after 1, 20 after 2, etc.

This kind of numbering can be achieved with sprintf:

sprintf("Severity_Index_%02d.csv", 7)

The interesting part is %02d -- this says that i is an integer value (could actually use %02i as well) that will take at least 2 positions, and leading zero will be used if necessary.

# try also
sprintf("Severity_Index_%03d.csv", 7)
sprintf("Severity_Index_%2d.csv", 7)

answered Sep 19, 2013 at 19:37

lebatsnok

6,5292 gold badges24 silver badges22 bronze badges

Comments

Scott Ritchie · Accepted Answer · 2013-09-20 02:49:50Z

0

To add to the other answers here, I find it's also a good idea to sanitise the pasted string to make sure it is ok for the file system. For that purpose I have the following function:

fsSafe <- function(string) {
 safeString <- gsub("[^[:alnum:]]", "_", string)
 safeString <- gsub("_+", "_", safeString)
 safeString
}

This simply strips out all non-alphabetic and non-numeric characters and replacing them with an underscore.

answered Sep 20, 2013 at 2:49

Scott Ritchie

10.6k3 gold badges34 silver badges68 bronze badges

Collectives™ on Stack Overflow

R programming, naming output file using variable

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related