Exercise

Delays on US airports

Now that you have successfully loaded, joined, and cleaned the DataFrame, it's time to find which airport in the US is best to avoid!

The flights DataFrame you created in the last exercise has been loaded for you.

flights contains, among others, the following columns important for this exercise:

  • airport, containing the starting airport of the flight;
  • departure_delay, containing the number of minutes of delay at departure.

DataFrames, Statistics, and Chain packages have been loaded for you.

Instructions

100 XP
  • Start a @chain macro for the flights DataFrame.
  • Group flights by the airport column.
  • Calculate the minimum, median, and maximum departure delay for each airport.
  • Sort the result by the median departure delay in descending order.