TSA Rolling Average Data

A chart of TSA data normalized to a rolling average

TSA Data

For this project I aimed to chart the passenger throughput data from the Transportation Security Administration (TSA) website to better understand the trends. While observing news outlets, I saw graphs with sharp swings up and down, which represented passenger throughput during the week and weekends. However, I found this representation to be jarring and not very informative. Therefore, I decided to create a normalized, rolling average on top of the original data to better show the trends.

To achieve this, I wrote a Python script that web scraped the TSA website for the data and used BeautifulSoup to organize it into a Jupyter notebook. Then, I plotted it nicely with Plotly. The resulting graph is more informative and visually appealing than the original graphs I had seen.

Interactive Result

Data source and works cited

PROJECT DATA UPDATED FROM: DEC 31, 2021

“TSA Checkpoint Travel Numbers (Current Year versus Prior Year(s)/Same Weekday).” TSA Checkpoint Travel Numbers (Current Year versus Prior Year(s)/Same Weekday) | Transportation Security Administration, Transportation and Security Administration of the United States of America, 2021, www.tsa.gov/coronavirus/passenger-throughput.