Recently I was given the feedback that I am quite negative in the office. I was not surprised by this feedback as I have noticed it in myself too, and I want to do something about it.
I have a goal to be more positive in 12 months time, but the problem with that goal is that it is pretty hard to measure, it will just be about perspective of others around me without any “concrete” proof.
In order to have some fact behind whether or not I achieve my goal, I going to attempt to use Azure Sentiment Analysis on my social media and emails for the next 12 months.
In this post, I discuss what I am intending to measure and what I have set up with Azure to help me measure it.
Azure Cognitive Services - Text Analytics will take in text, analyse the words in the text and give a sentiment rating on that text. The sentiment rating is just a scale from 0 (negative) to 100 (positive). If sentiment can’t be detected on the text, or it is not very confident in the sentiment, the rating will be close to the middle (~50).
You can try it out live on the Azure website.
If you enter something with no clear positive or negative sentiment you will get a neutral score.
e.g. “The Flyers score on the power play” gives a sentiment score of exactly 50. If I enter “Claude Giroux’s power play goal was amazing” it gives a sentiment score of 93. Finally; if I enter “The Penguins are the worst team to follow in the NHL” I get a sentiment score of 20.
The sentiment analysis also picks up that I am talking about the Pittsburgh Penguins and the National Hockey League:
The API for this result gives you a strucuted JSON output:
To get started with this, I first created a Text Analytics resources in Azure.
To do this; open your Azure portal and follow the following:
- Click “Create a resource”
- Select “AI + Machine Learning”
- Select “Text Analytics”
- Enter a name for your new Text Analytics resource
- Choose your subscription for it to be created in
- Choose a location for your resource to be hosted in
- Choose your pricing tier (F0 is the free tier with 5000 transactions per month)
- Create a new resource group, or use an existing one
And then you can save to create your new Text Analytics resource.
You now have a Text Analytics API that you are able to call. In order to use it you need to get your Keys, and find your API endpoint.
You can find these under the Overview section, and the Keys sections on your resource.
You can contact your Text Analytics endpoint with a basic Http Client like the following:
HttpClient client = new HttpClient();
The code above assumes some basic classes in place to strongly type the data when sending and receiving like the following:
I am not normally very vocal on social media, so I am going to make an effort to post more in general, especially when I feel strongly about issues or topics. I also send a lot of emails, I have not figured out how I will get my emails into the sentiment detection yet as they will have footers and history attached. There are Office365 API’s available but it looks like that you need to add an application to your AzureAD in order to use them, which the company I work for will likely not allow me to do.
At this stage I will likely skip my emails, but I have the option of using Postman to manually put my emails through sentiment analytics. If I figure out an automated way to achieve this; I will write a follow up post with my method.
There is a limit to how much text the Text Analytics service can process at once, that limit is 5000 characters. I will just skip any social media post or email that is larger than that limit as splitting it up may skew the sentiment.
I need to set a baseline for how negative I was in the past in order to figure out if there has been any noticable improvement when I have tried to be positive for the next year. To do this; I decided that I would pull my previous posts from Twitter, Facebook, and Reddit and store them in an Azure Table. I will then automate pulling in future posts on these mediums and save them to the same table. After a year is up; I will analyse the data and confirm if I was able to be more positive or not.
The data I am storing from each medium is the following:
- Medium (Facebook, Twitter, Reddit [I may add email at a later stage])
- Date & Time (The date and time that I made the content)
- RawContent (The content that I posted)
- SentimentRating (The sentiment rating generated from Azure)
- SentimentJSON (The JSON output from the sentiment result)
The code I am using is a series of Azure Functions to pull the data from the various sources and save them to the Azure table. In order to run this code in Azure you will need a Function App, and a storage account to save it to. You can view the code on my GitHub. This is not structured particularly well, it was just thrown together for the purpose of retrieving the data.
Facebook’s API was a little too restrictive with the content that the Graph API would output, so instead of having an automated function to pull in data from the API, I have a monthly reminder to upload my data manually. You can see how to get your data from Facebook on the Facebook help pages. I downloaded my data in JSON format, and sent the comments/comments.json, and posts/your_posts.json files to my endpoint with a specified date range.
I have used the code above to set a baseline for how negative I was over the past 12 months and found that I had not posted enough to set a decent baseline, so I used my entire social media history rather than the past 12 months instead. From that base line I found the following results grouped by medium:
- On Twitter I found my median sentiment was 0.752673924 and mean sentiment was 0.572312586.
- On Facebook I found my median sentiment was 0.997742295 and mean sentiment was 0.867793107.
- On Reddit I found my median sentiment was 0.702302575 and mean sentiment was 0.569304293.
This baseline shows that I am much more positive on Facebook than the other two mediums, looking into this further I can see that it has been skewed by me saying “Happy Birthday” to my friends on their birthdays which generally has a 0.99 sentiment. These sort of comments take up a large portion of the comments I make on Facebook so if I continue that trend, the baseline will still be accurate when I look again in a years time.
Reddit and Twitter have similar numbers, but I generally post about different things on each of those mediums. I use Twitter to complain about services that I am consuming and sometimes I will tweet about technical things. On Reddit, I generally am on sport subreddits talking about my favourite teams in ice hockey (The Flyers), and in rugby (The Highlanders). I am active in game day threads in sports, where sentiment is easily detected if I am commenting about something like a bad pass, or an amazing play.
All of the numbers are higher than I would have estimated to begin with, which doesn’t leave me much room to grow - especially on Facebook. I am looking forward to at least attempting to improve my demeanor and be a more positive person in general.
I will check back in on this in 12 months time to see if I have made any progress being positive.