Visualizing Text Data With WordClouds

Follow

Neha Kumar

January 06, 2020 17:49

A popular way of visualizing text data is using WordClouds. Using Python's WordCloud library this can be done with a column of text data and a few lines of code. 

# SQL output is imported as a pandas dataframe variable called "df"
import matplotlib.pyplot as plt
from wordcloud import WordCloud, STOPWORDS

stopwords = ["my","to","at","for"] # removes any words you may want to exclude from your wordcloud


img = WordCloud(width = 600, height = 400,
                          background_color='black', colormap = 'Oranges',
                          stopwords=stopwords,
                          max_words=200,
                          max_font_size=100,
                          random_state=42
                         ).generate(str(df["TEXT"]))

plt.figure(figsize=(30,20))
plt.subplots_adjust(left=0, right=1, top=1, bottom=0)
plt.imshow(img)
plt.axis('off')
periscope.output(plt)

Here is our result! 

0

• 

  Sam Nicholls February 03, 2020 19:25

  This is great!  Can you provide a bit more insight into the implementation?

  Where is this work done?  Obviously not in-widget or using Blox..

  0

  Comment actions Permalink
• 

  Neha Kumar February 03, 2020 21:55 (Edited February 03, 2020 21:55)

  Hi Sam Nicholls, this is done in the Sisense for Cloud Data Teams product. It sounds like you are in Sisense for BI and Analytics.

  0

  Comment actions Permalink
• 

  Vyomesh Tala December 22, 2020 16:51

  We use this to uncover some quick insights from lengthy texts and overall it works well.

  Any idea on the versioning & latest updates of the WordCloud library on Sisense for Cloud Data Teams? When trying to add configurations such as "min_word_length", it's not recognized and results into errors.

  0

  Comment actions Permalink

Please sign in to leave a comment.