ETL: Join rack and tray

[jaketbouma]

ETL: Join rack and tray from ERP data

As a data scientist I would like to join ERP data onto the sensor data so that I am able to calculate the growth rate in each rack for comparison with sensor data (i.e. humidity)

DOD

Will need to build up a lifetime dataset (plant date, harvest date, tray id, rack id...):

• Join the two sheets HARVEST (tray id) and PLANT (tray id, rack id)
  this google sheet
  to the sensor data.
• Write the dataset to disk

Next steps

• Compare pairwise sensor variables with the growth rates.