Merging the Datasets

We now have three datasets at the same level of granularity: the Asset, i.e., an individual rental car. Joining them together will give us the most possible information for a model. With the same Asset ID in each dataset, we can easily join the datasets with a visual recipe.

  1. From the failure dataset, initiate a Join recipe.

  2. Add usage_by_Asset as the second input dataset.

  3. Name the output data_by_Asset. Click Create Recipe.

  4. Add maintenance_by_Reason as the third input dataset.

  5. Both joins should be Left Joins. Asset should be the joining key in all cases.

  6. Run the recipe and update the schema to 21 columns.

../../../_images/compute_data_by_Asset.png

Note

Check the reference documentation for more information on the Join recipe.

data_by_Asset now holds information from maintenance and usage, labelled by failures. Congratulations, great work!