项目作者: xhlow

项目描述 :
Tableau Story that highlights trends in U.S. flight delays
高级语言: Jupyter Notebook
项目地址: git://github.com/xhlow/dand-t2-p4-data-visualization.git
创建时间: 2018-06-18T13:21:04Z
项目社区:https://github.com/xhlow/dand-t2-p4-data-visualization

开源协议:

下载


Tebleau Story for U.S. Flight Delays

Summary

In this project, I created interactive visualizations using Tableau for U.S.
flight delays data from 2010 to 2018, which is downloaded from The U.S.
Bureau of Transportation Statistics.
The purpose of my visualizations is to answer the following questions:

  • How does flight delay time change over time in comparison to the number of
    arrived flights? Is there any variation in delay time in different quarters of
    the year?
  • How much time is delayed by each delay cause? Does the proportion change over
    time?
  • Which airports have more flight delays? Is the delay time related to the
    number of arrived flights?

Through the visualizations, I showed that:

  • Flight delay time have greater fluctuations compared to number of flights.
    The total number of minutes delayed usually increases in the first and second
    quarter of the year and decreases in the third and fourth quarter of the year.
  • Late aircraft contributes to the longest flight delays, followed by carrier,
    national air system, weather, and security reasons. This proportion remains
    fairly constant over time.
  • Airports with vary in delay time regardless of the number of arrived flights.

Process of Creating the Visualizations

The visualizations were created through an iterative process. Every time after
I created a draft of the visualizations, I showed it to multiple people,
obtained feedbacks from them, and made improvements using those feedbacks. The
detail of the process, including the link to each draft, is recorded in
Tableau Story Project Report.pdf. The final iteration of the visualizations
can be viewed
here.

Datasets

  • airline_delay_jan10_mar18.csv: Original dataset downloaded from the Bureau
    of Transportation Statistics.
  • airline_delay_jan10_mar18_master.xlsx: Wrangled dataset, which contains a
    date column. Saved in .xlsx format for easier processing in Tableau. The
    wrangling process and the codes involved can be found in
    flights_data_assess_wrangle.ipynb.

Other Files

  • Tableau Story Project Report.pdf: A report that records the process of
    creating each iteration of the visualizations, the thoughts involved, feedbacks
    received, and URLs to each iteration.
  • flights_data_assess_wrangle.ipynb: Jupyter notebook that contains details
    and codes of the data wrangling process.