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!
Please sign in to leave a comment.