KEMBAR78
Fleet Analysis Case Study - Python | PDF | Data Analysis | Computer Programming
Scribd
Upload
70 views2 pages

Fleet Analysis Case Study - Python

This case study focuses on analyzing fleet data from airlines between 1985 and 2022 to derive insights on aircraft operations. Key objectives include counting currently operating aircraft, tracking exited and retired aircraft, identifying new additions, and calculating average age by master series for each airline. The expected output is a Python notebook containing exploratory data analysis and code to automate calculations for future years, along with visual representations of the findings.

Uploaded by

as116ra
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
70 views2 pages

Fleet Analysis Case Study - Python

This case study focuses on analyzing fleet data from airlines between 1985 and 2022 to derive insights on aircraft operations. Key objectives include counting currently operating aircraft, tracking exited and retired aircraft, identifying new additions, and calculating average age by master series for each airline. The expected output is a Python notebook containing exploratory data analysis and code to automate calculations for future years, along with visual representations of the findings.

Uploaded by

as116ra
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Fleet Analysis Case Study

The objective of this case study is to understand how to efficiently do the data crunching and apply
relevant logic to reach the overall outcome. Please note that the datasets are confidential and should
not be shared with anyone else.

Details regarding the Datasets


You have been provided with Fleet data for the years 1985 to 2022. The datasets have the same schema
but for different years. It provides a year-end snapshot of the different fleets that each airline has
(Snapshot as of 31st Dec for each year for each airline). For example, the 2022 file will provide you with a
list of all the aircrafts that are operating/stored/sold for let's say, United Airlines. Each row in this file
represents one single aircraft encompassing the following details.

Name of the column Description


Type Type of the aircraft
Serial Number Serial Number of the aircraft
Operator Airline operator e.g. Air India
Master Series Master Series - lower granularity than "Type" of the aircraft
Describes whether the aircraft is currently operating, retired, stored etc.
Status
(please ignore the data points that are marked as “Type swap”)
Manufacturer Manufacturer of the aircraft
When the aircraft came into service (please note that in-service date
means when the aircraft started flying – not when it came into service in
In Service Date
that airline – for example, Air India can sell its aircraft to another airline.
In service date will still be the one when Air India started it)
Registration Registration No. of the aircraft

Please note that there are other columns in the datasets that you can ignore. The data looks
straightforward but isn’t. Please do an extensive exploratory data analysis before framing the
solution. Hint: Please do not use In Service Date column as the source of truth for majority of the
analysis mentioned below.

Problem Statement:
 Exact count of aircrafts are “currently operating” for a particular operator in a particular year at
a master series level
 Exact count of aircrafts that have exited and retired in a particular year for an airline at a master
series level. Please do note that there is a difference between exited and retired. For example –
an aircraft can retire which means it is no longer in service or it can be sold to another airline
therefore not a part of the existing fleet for that airline.
 Exact count of new aircrafts that have been added in that particular year for an airline at a
master series level
 Average age of each Master Series within an airline operator for each year

Desired Output:
 Python code which includes all the Exploratory data analysis.
 Python code that calculates the above-mentioned outputs. Please note that you must develop
the code in such a way that if we add more years, it should directly calculate the outputs in one
click
 A simple graph showcasing each of the outputs mentioned above (you can utilize Python
libraries for the same and include that in the notebook)

Output To be shared with the Hiring Team:


A detailed and commented Python notebook or .py file.

You might also like