Xavier University vs University of Cincinnati

Introduction

Today I will be comparing the twitters of Xavier University and University of Cincinnati, two schools that love to be competitive with each other. I have asked myself three questions with the data given and have used analytics like graphs and tables to retrieve some insight on these answers.

Question 1: How does the popularity of Xavier differ from UC throughout the day?

Here I used really only one term, created_at; which represents the time at which a tweet was sent out. Based on the visuals I have created here using ggplot. It seems like Xavier generally gets more interaction in the earlier hours, while UC gets more interaction in the later hours. I kept the time zone in UTC so you can differentiate between things like hour 6 and hour 18, as I did not know how ggplot or R would deal with timezoned data like EST.

Question 2: What Twitter page gets the most amount of favorites and retweets?

Xavier Total Favorites	Xavier Total Retweets	Xavier Total Quote Retweet Count	Xavier Total Quote Favorites
861	58	1582	7886

UC Total Favorites	UC Total Retweets	UC Total Quote Retweet Count	UC Total Quote Favorite Count
1111	157	957	12292

Here I used four terms. The amount of favorites, the amount of retweets, and the amount of quoted retweets and favorites. For competitive sake, I wanted to see what community is more active. This table displays the number of retweets and favorites each school has accumulated within the most recent 150 tweets. From the numbers alone, it is easy to say that UC generates more interaction, but when you take into account the followings of each twitter account, UC being at ~80k while Xavier is at ~20k, you start to look at these numbers a little differently. I would say that it is safe to say that the interaction between the 2 accounts is comparable, and in my opinion, Xavier’s might be a little more impressive considering the significantly smaller follower amount.

Question 3: What hashtags generate the largest amount of interactions, and which school has the most ‘popular’ hashtag?

hashtags	Total Favorites
NA	673
LetsGoX	77
win	45
NIT basketball	17
ExchangesAre	14
GMTS	6
ItsBruinTime	6

hashtags	Total Favorites
NA	564
Bearcats	198
BearcatsBound NextLivesHere	62
PhD awardwinning BlessedAndGrateful	61
UC_RIweek22 CincyResearch2030 NextLivesHere	26
nephforward	23

Here I used only two terms. The hashtags and the favorite count. I figured a decent way to understand interactions based on hashtags was to see the amount of total favorites certain hashtags attain. I took the top 5 most favorited hashtags and analyzed them. NA here stands for tweets without a hashtag, so really it is top 6. Looking at the tables, it is clear that UC generates more favorites with their hashtags. Looking deeper into some context though, UC’s most popular hashtag is #Bearcats , while Xavier’s is #LetsGoX. #LetsGoX generates around half the amount of favorites that #Bearcats does, but AGAIN, looking at context, Xavier’s follow count is around a fourth the amount of the UC twitter. So, I would say that Xavier’s interaction based on it’s hashtags is comparable to UC if not flat out more impressive. Essentially what I am saying is: Based on the hashtags, Xavier’s basketball program receives more interactions among the community than the UC twitter does as a whole.