Project: Data Wrangling and Analysis¶

Insights from WeRateDogs Twitter Datasets
¶

A.T. Aderoju
¶

Overview¶

With the cleansed dataset created from gathering twitter data pertaining to the popular WeRateDogs rating provider on Twitter, I analyzed and produced the following insights:

  1. Most occuring Dog stage according to the Neural Network's image prediction.
  2. The most Popular Breed on @WeRateDogs
  3. Engagement Frequency of the WeRateDog account
  4. Relationship Between Posts Retweeting & Favourism
  5. Influence of Post Retweeting on Number of Times a Post is Liked

Most occuring Dog stage according to the Neural Network's image prediction¶

The analysis of the WeRateDogs Twittter account shows that dogs in pupper stage are the most occuring, followed by those in doggo stage

Ade
Pupper
Image 1
Doggo
Image 1
Puppo
Image 1
Floofer
Image 1

The most Popular Breed on @WeRateDogs¶

Whereas Golden Retriever lead the list of breed with most liked tweets and retweet, Saluki has the highest likes per tweet, while Bedlington Terrier experienced the highest retweet per post . Hence, in terms of total likes and retweet, Golden Retriver is the most popular breed on Twitter

Dog
Image 1
Image 1

Golden Retrievers are the most liked and retweeted @WeRateDogs. See below for an image of a set of golden retrievers.

Image 1

In terms of per post, we have Saluki breed having the highest likes per post, with Bedlington Terrier having the highest retweeted count on, average

Image 1
Image 2
Saluki
Image 1
Bedlington Terrier
Image 2

We also looked at the dogs with highest likes and retweet @WeRateDogs, and below are their images

Highest Likes - Lakeland Terrier
Image 1
Highest Repost - Labrador Retriever
Image 2

Engagement Frequency of the WeRateDog account¶

Accross the year, Monday seems the most busy day of the account, and people Like to interract with in the early midnight of the day, lowest during the day and become high again between 4PM to 5PM. This is undesrtandable as most people become less active on the internet during work hours

Image 2 Image 2

Relationship Between Posts Retweeting & Favourism¶

The Pearson's r of rating and favorite count is around 0.5, which means there is a moderately positive correlation between the variables. This implies that ratings somewhat reflect people's preferences for dogs.

Image 1 Image 2

Top & Worst Rated Dogs
Top Rated
Image 1
Worst Rated
Image 2

Influence of Post Retweeting on Number of Times a Post is Liked¶

There is a strong positive linear relation between post retweet and number of time a post receives likes. This implies that people who like a post are highly likely to retweet and vice versa.

Image 1 Image 2

From the begining till 2016-04, the intensity of both favorite and retweet counts is similar, although favorite counts are higher than retweet counts. This trend is even more conspicuous with the progression of time, with favorite counts steadily rising above retweet counts from around 2016-09. Interestingly, the bulk of retweet counts remains below 10k.

Image 1
In [ ]: