R language
Budget: $10 – $30 CAD
Context:
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 pumps 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 allbe 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, namely:
• $ 4 000: Whole pump replaced
• $ 200: Bearings replaced
• $ 100: Seals replaced
• $ 250: Bearings and seals replaced (cheaper to replace both at once)
Even if not 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 has a total of 100 000 pumps. They provide 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.10$ 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).
Sensor Data
A zip file containing the data is available on ZoneCours. The data is split between different files:
• repairs.csv: The list of repairs that were done on the 200 pumps used for the study last year.
• Sensors-study.csv: Sensor data for 12 months for the 200 pumps in the study last year.
• Sensors-score.csv: Sensor data for the first 5 months of the year to help you decide which pump should be maintained.
How to play the game:
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.
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 pumps 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 allbe 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, namely:
• $ 4 000: Whole pump replaced
• $ 200: Bearings replaced
• $ 100: Seals replaced
• $ 250: Bearings and seals replaced (cheaper to replace both at once)
Even if not 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 has a total of 100 000 pumps. They provide 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.10$ 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).
Sensor Data
A zip file containing the data is available on ZoneCours. The data is split between different files:
• repairs.csv: The list of repairs that were done on the 200 pumps used for the study last year.
• Sensors-study.csv: Sensor data for 12 months for the 200 pumps in the study last year.
• Sensors-score.csv: Sensor data for the first 5 months of the year to help you decide which pump should be maintained.
How to play the game:
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.