Light It Red: Exploring Bell Tower Celebrations with R
Apr 14, 2019RWeb Scraping
NC State Belltower
Among the sights to see when taking a trip to Raleigh is NC State’s iconic Belltower. Erected as a monument to honor fallen soldiers of WW1, the memorial Belltower has become a symbol of pride for NC State students and alumni.
On any given night, the bell tower might have a red illumination. Red bell tower lightings signify special achievements made by NC State organizations and staff as well as memorial holidays.
Every Belltower lighting since the summer of 2010 has been recorded at ncsu.edu, along with its occasion. I thought it was worth trying to understand a litle more about what makes the Belltower shine red.
Getting the data
In the archive, dates are listed with their occasion. Scores are listed for Baseball, Football, and Basketball. For this analysis, I used the rvest package for scraping the page, and then did some manipulation to get the data into a tidy format.
date | occasion |
---|---|
2019-04-13 | Recognition of student Madison Maloney being selected as a 2019 Knight-Hennessy Scholar |
2019-04-07 | Baseball |
2019-03-31 | Baseball |
2019-03-30 | Men’s Swimming and Diving |
2019-03-25 | Women’s Basketball |
2019-03-23 | Women’s Basketball |
Since June of 2010, there have been 320 Belltower celebrations.
Going through the data, it becomes evident pretty quickly that sports victories make a large number of Belltower celebrations. Students are likely quick to assume that a red Belltower means that one of our Basketball or Football teams had an ACC win. Interesting that NC State women’s basketball outranks the men in this measure.
Among the less common occasions are a number of personal achievements made by individuals affiliated with the University. When lumping these personal recognitions together, it turns out that they make up a significant number.
occasion | n |
---|---|
Women’s Basketball | 76 |
Men’s Basketball | 69 |
Recognition | 45 |
Football | 34 |
Baseball | 24 |
Veterans Day | 7 |
How often is the Belltower lit?
Students can be seen gathering around the Belltower after big wins, but how likely is that you’ll see it red on random night in Raleigh?
It turns out that the weekend is a good time to see a red Belltower. College football games are almost always played on Saturdays, but even with 34 less occasions, Saturday would still be tied for the highest occuring day.
The winter months stand out as those with the most nights with a lit Belltower. Based on the numbers for the most frequently occuring occasions, it’s easy to guess that Basketball is the cause. Also interesting is that there have been 0 Belltower lightings in the month of July for these 8 years.
What is the longest drought between celebrations?
Since 2010, what’s the longest time the Belltower has gone without being lit?
date | occasion | gap | previous |
---|---|---|---|
2011-05-06 | Recognition of Garik Sadovy for being selected to receive a Udall Scholarship. | 140 | 2010-12-17 |
2017-09-23 | Football | 133 | 2017-05-13 |
2018-08-25 | Packapalooza | 105 | 2018-05-12 |
2016-08-20 | Wolfpack Welcome Week finale — Packapalooza | 105 | 2016-05-07 |
2015-08-22 | Welcome Week Finale — Packapalooza | 101 | 2015-05-13 |
In 2011, the Belltower underwent construction to prevent water seepage through its joints. Interesting too is that the Wolfpack Welcome Week tradition of Packapalooza has a reputation for ending droughts.
What is the longest streak of Belltower lightings?
date | occasion | streak |
---|---|---|
2012-03-02 | Women’s Basketball | 3 |
2012-03-09 | Men’s Basketball | 3 |
2016-02-22 | Wrestling | 3 |
2016-03-08 | Men’s Basketball | 3 |
2018-03-03 | Men’s Basketball | 3 |
2018-03-18 | Women’s Basketball | 3 |
2018-03-25 | Baseball | 3 |
2019-03-09 | Baseball | 3 |
2011-11-12 | Recognition of Professor Trudy Mackay for being selected to receive the 2011 North Carolina Award in Science | 2 |
2012-03-01 | Women’s Basketball | 2 |
It’s pretty unlikely to see the Belltower lit more than 3 consecutive days.
The NC State Belltower has a rich history and will continue to represent success for the Wolfpack nation.
The code for this blog can be found here
Go Pack!!