The Sword of Pretty Thoughts

The (Creative) Life and Times of J.G. Jerome

Word Clouds in Tableau

The weird thing about Tableau 9 (or 10) is that it will let you make word clouds of phrases, but not of words (please contact me if you’ve found a better way).

At work we were allowed to use a (very crippled by IT;  you had to manually download Eggs and Wheel files) Python distribution called Enthought Canopy.  I somehow managed to get the Natural Language Toolkit installed with the corpuses (that’s a story for another day).  In Tableau I exported a crosstab CSV with all of the Record IDs in one column and all the phrases in question in the next column. I then ran this script that I wrote:

It spit out a CSV file that I then re-imported into Tableau and it had separated verbs and nouns in 2 other columns.  From there it was easy to build the word clouds below.

The zip file I’m sharing has example input and output files, as well as this script.   Enjoy!


Photo Credit: Pixabay.com

Next Post

Previous Post

© 2019 The Sword of Pretty Thoughts

Theme by Anders Norén