Assignment 5

Introduction

The data being used throughout this analysis has been gathered through twitter and turned into a structured format. There are two datasets, both having different purposes with regards to this analysis. One will be used to examine which languages are tweeting about either Pepsi or Coca-Cola more and the other is being used to examine which company uses twitter more and how much more popular each one is.

The first data set containes 3000 tweets from Coca-Cola’s company twitter and Pepsi’s company twitter. The second dataset is just 3000 tweets.

Which Company Uses Twitter More?

The visuals below will be pulling from the company_tweets data set and I will be utilizing variables such as the company names and dates.

Interpretation: Both companies use twitter quite a lot. With over 250 tweets in the month of March. They are averaging between 8 and 10 tweets a day. Despite each company using twitter around the same amount, Pepsi does pull ahead with around 20 to 30 more tweets so far. Knowing this will help us better understand and look at the successes of each twitter.

Which Company is More Popular On Twitter

Logically speaking, when more people like a post or a group of posts, one would think that they are more popular. Favorites is one of the best ways to gage whether or not consumers are engaging and liking the content that each company is putting out there. I will count the amount of times posts have been favorited, sum them, and compare the results.

Interpretation: It is clear from the visual above to tell that Pepsi has a significant amount more of favorites. And it is not even close. This could be do to the amount of followers that each company’s twitter has, or simply that Pepsi is putting better content out. More things that the consumer can relate to.

Which Languages are Talking About Which Company

Knowing which markets are talking about your company can offer huge insights to decision makers. If there is an oversaturated amount of comments in languages that you are not marketing to, then there could be opportunities. The visuals below show the count of times that a tweet was sent out mentioning each of the past companies in recent time.

Interpretation: Overall, each company recieves a majority of its tweets from the dominant languages of english and spanish. However, with regards to Coca-Cola, here are plenty more languages that are tweeting about them as compared to pepsi. This could reveal an international advantage that Coca-Cola has over pepsi that would help them gain an edge.