
28 Text Mining and Visualization: Case Studies Using Open-Source Tools
FIGURE 1.46: Visualization: Layout of transposed worksheet.
=REPT((A1 & " " ),B1)
The Token should be stored within Cell A2, and the Number of Times that it appears
throughout the document is within Cell B2 (Figure 1.46). The formula in Cell C2
recreates the number of times that this token is mentioned in the original source
document by repeating the word (Wordle requires this in order to generate a word
cloud visualization of its frequency). Drag this formula down Column C until you
reach the last token row.
2. Once complete, open www.wordle.net (Figure 1.47), select Create, and ...