2019: Week 9

The rollercoaster ride of Chin & Beard Suds Co continues unabated. This time we have been asked by our Social Media manager to run our analytical minds over some questions on Complaints we receive via Twitter.

Our Social Media manager has just pulled out the complaints for us to analyse where someone has tagged our Twitter handle @C&BSudsCo but then followed up with some issues raised. We need to know the common themes of these tweets and be ready to re-run this analysis at any time. In order to do that, we want you to make the data available to build a view on what common words are used in the complaint tweets.


  • Input data
  • Remove Chin & Beard Suds Co Twitter handle
  • Split the tweets up in to individual words
  • Pivot the words so we get just one column of each word used in the tweets
  • Remove the 250 most common words in the English language (sourced from here for you: http://www.anglik.net/english250.htm)
  • Output a list of words used alongside the original tweet so we know the context for how the word was used. 

  • 2 Columns of data
  • 69 Rows of data (70 including the header)
  • No null cells
  • A few chuckles at the complaints
For comparison, here's our output file. Don't to forget to fill in our participation tracker!


Popular posts from this blog

How to use... Custom SQL in Prep Builder

2021: Week 22 - Answer Smash

2021: Week 1