Saving R Dataframe as filename based on objects

Question

I have some objects in R that can change from time to time:

    beginning <- "Our_Office_Preface"
    query_type <- "PA_"
    date <- "2018_06_08_"
    office_query_type <- "dis_"
    input_FY <- 2015
    filename <- paste(beginning,"",query_type,"",date,"",office_query_type,"",input_FY,sep="")

and I'm trying to write a dataframe as a tab delimited txt file. I'm trying to save it as filename and having a hard time making it tab delimited.

df <- data.frame(name=c('Inst1','Inst2','Inst3','Inst4','Inst5','Inst6','Inst7','Inst8','Inst9','Inst10'), num=c(1,5,6,7,4,6,5,7,8,4))

these two lines

write.table(df , file=paste(filename, ".txt", sep="\t", quote = FALSE))
write.table(df , file=paste(filename, ".txt", sep="\t"), append = FALSE, quote = FALSE, row.names = FALSE, col.names = TRUE)

both produced this error

Error in file(file, ifelse(append, "a", "w")) : cannot open the connection

Could I get some assistance?

Fino · Accepted Answer · 2018-06-08 19:00:04Z

1

You just misplaced your closing parenthesis on the paste function. sep = "\t" is a write.table argument and it's being passed to paste instead.

Close the paste function after ".txt" and it should work.

write.table(df , file=paste(filename, ".txt"), sep="\t", quote = FALSE)

answered Jun 8, 2018 at 19:00

Fino

1,78413 silver badges21 bronze badges

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

1 Comment

tangerine7199 Over a year ago

Derp! I knew it would be something like that. Thank you!

Collectives™ on Stack Overflow

Saving R Dataframe as filename based on objects

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related