R word cloud visual in Tableau

Question

Trying to get Tableau to display a simple R visual (word cloud) but I can't get it work. Any help would be appreciated.

R code:

library(wordcloud)
library(tm)
cp <- Corpus(VectorSource('asdf gato perro 98945')) 
wordcloud(cp)

The table calculation in Tableau looks like this:

SCRIPT_STR("library(wordcloud)
library(tm)
cp <- Corpus(VectorSource('asdf gfg ff 98945')) 
wordcloud(cp)",ATTR([SampleMeasure1]))

My question is how can I display the above word cloud without supplying a measure (SampleMeasure1)? Is it even possible to display an R word cloud in Tableau? If so could anyone please provide a simple example what the calculation should look like?Thank you

Mark Druffel Mark Druffel · Accepted Answer · 2017-03-02T22:01:13

I'm assuming your goal is simply to make a word cloud in Tableau from a vector you have in R?

I took the vector you suggested and produced a dataframe with random counts for each string in the vector. I saved the vector as a csv.

count <- as.integer(round(runif(4,1,100),0))
words <- c('asdf','gfg','ff','98945')
df <- as.data.frame(cbind(words,count),stringsAsFactors = FALSE)
df$count <- as.integer(df$count)
write.csv(df,"word_cloud.csv",row.names = FALSE)

Then if I import the csv to Tableau I can simply create a word cloud. The below image shows the Tableau configurations:

The "Word" needs to be put in the text bin.
The "Count" should be in the size bin.
**Then you have to flip the marks drop down menu to text. It will produce a word cloud. **

Alternatively you can use the wordcloud library as you're attempting to do. I used the Kaggle Starbucks data set for this example, found here. The code used to generate this image was:

library(wordcloud)
df <- read.csv("directory.csv",stringsAsFactors = FALSE)
words <- df$City
words <- gsub(" ",".",words)
wordcloud(words, min.freq = 50)

R word cloud visual in Tableau

2 Answers