Email news@statisticool.com to sign up to receive news and updates

Poetry Word Cloud

1/18/22

When I had 2,456 poems, I decided to make a word cloud using the 53,590 words from these poems because I was curious about the frequencies of repeatedly used words. The current poem count is poems, which can be read here. The current word count is words.

Here are the steps of how I made the word cloud:

  1. Paste all the lines of each poem into a column in Excel
  2. Use Excel's "Text to Columns" feature, delimiting by space, to put each word into a column
  3. Paste each of the columns into a single column
  4. Use Excel's functions lower(), trim(), clean(), to make the text lowercase and remove extra spaces
  5. Remove "stop words" (like "the", "of", "a", etc.") and non-letter characters (like "(", ")", "?", "!", "-", etc.) from the analysis
  6. Copy/paste this column into a Free Word Cloud Generator or similar site
  7. Choose a color scheme you like and generate and save the .jpg

The result:

My summary is that I like writing about water, colors, and nature in general in my poems.

I plan to recreate the word cloud on an infrequent basis, say every few thousand poems or so. I am interested in how this word cloud could change over time.

Thanks for reading.

Please anonymously VOTE on the content you have just read:

Like:
Dislike:



For poetry, I recommend:


Please show me a randomly selected poem






If you enjoyed any of my content, please consider supporting it in a variety of ways:

AFFILIATE LINK DISCLOSURE: Some links included on this page may be affiliate links. If you purchase a product or service with the affiliate link provided I may receive a small commission (at no additional charge to you). Thank you for the support!