Your company has operations in very remote area where centrifugal pumps are used to extract valuable liquids. Pump
maintenance is done by a contractor. All of the 100 000 pumps in your installations get maintained once a year, but there is
an option to repair selected pumps after 6 months at a cost. Your role will be to decide which pumps, if any, get the month 6
maintenance. The pumps will all be maintained at the end of the 12 months, whether they had a maintenance done at 6
months or not.
When pumps are maintained, the contractor may change the bearings, the seals, or replace the whole pump. Due to the
remote location, every pump maintenance has a base cost of $ 500, plus the cost of the repair. Note that your contract allows
for up to 20 000 maintained pumps at 6 months at the regular rate. If you exceed that number, the repairs would be
considered an emergency call at a hefty base cost of $ 5 000, plus the repairs. Those repairs, urgent or not, follow a fixed cost
• $ 4 000: Whole pump replaced
• $ 200: Bearings replaced
• $ 100: Seals replaced
• $ 250: Bearings and seals replaced (cheaper to replace both at once)
Even if no parts are replaced, the contractor performs an inspection and a tuning of the pump at no additional cost.
Sensors on the pump keep track of energy use, volume of liquid extracted, as well as vibrations of the pump. Because of their
remote location, the data are just stored locally as there are no networks available. The extracted liquid gets collected every
month, and the data are then brought back on a physical device by the transporter.
The company provides you with a summary of the sensor data for the first 5 months of the years to decide which pump will
be maintained at month 6. Last year, a study was also done on 200 pumps that were randomly split in two groups. The first
group got a maintenance at 6 months, then the regular maintenance at 12 months, but the second group just got the regular
maintenance at 12 month. The data from that study are available to you, namely the details of the maintenance and 12
months of sensor data.
Beyond the cost of repairs, pumps consume electrical energy that you pay $ 0.10 per kwh. The liquid that you extract is worth
$ 0.03 per cubic meter. Your objective is to net the largest possible profit during the 12 months period (value of liquid, minus
energy and repair costs). The platform will tell you how much more profit you make compared to doing no maintenance at 6
A zip file containing the data is available on ZoneCours. The data is split between different files:
• [login to view URL]: The list of repairs that were done on the 200 pumps used for the study last year.
• [login to view URL]: Sensor data for 12 months for the 200 pumps in the study last year.
• [login to view URL]: Sensor data for the first 5 months of the year to help you decide which pump should be
You need to prepare a one column CSV file with the list of IDs of the pumps to repair at 6 months
Your objective is based on a business outcome: net profit. The process of prediction will involve cleaning, combining,
analyzing, and modeling data.