Assign CSV serialisation of an object into a string variable in R

Question

I am writing a package that would create a CSV gists on github.com from a data frame. Signature would be like so:

gist.csv(my.data.frame, public=FALSE, description="my results in CSV")

I'm using httr for the HTTP calls and the GitHub API expects the content of the gist as part of the body.

However, I'm stuck on serialising the object my.data.frame into a CSV string and assigning the string into a variable. I'm looking for a way to have

csv.string <- write.csv(my.data.table)

Is there a good way to achieve that (ideally without having to resolve to writing to a temp file)

MrFlick · Accepted Answer · 2016-08-10 18:36:29Z

2

You can write to a variable in R via a textConnection. For example

#sample data
dd <- data.frame(x=1:10, y=letters[1:10])

#write to variable
x <- ""
tx <- textConnection("x","w")
write.csv(dd, tx)
close(tx)

#check contents
cat(x, sep="\n")

answered Aug 10, 2016 at 18:36

MrFlick

209k19 gold badges300 silver badges324 bronze badges

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

Collectives™ on Stack Overflow

Assign CSV serialisation of an object into a string variable in R

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related