Explanations: Chart A: The below chart shows ranking of units in comparison with work. Chart B: The below table shows ranking of units in comparison with work. It also highlights the unit that have been working least and most. Chart C: The below chart shows ranking of units in comparison with work average of run1, run2 and runOdo. Chart D: The below graph plots unit 205836 in comparison wiht time and engine speed. Chart E: The below table shows the 6 units that have been working most with engine speed between 14 and 16. Chart F: The below graph shows the unit that have been working most (346419) with engine speed.
Row
Chart A: Barcharts (Opgave 1) The below chart shows ranking of units in comparison with work.
Row
Table B: Table (Opgave 1) The below table shows ranking of units in comparison with work. It also highlights the unit that have been working least and most.
| Machines.id | Machines.name | Machines.deviceModel | Machines.batteryLevel | Machines.run1 |
|---|---|---|---|---|
| 45518 | 1350033 JLG_510AJ E300001821 | ME401 | 85 | 4308660 |
| 46216 | AUSGEBUCHT - 401053 | ME401 | 0 | 9433860 |
| 47256 | VERKAUF - 137865 SV100 ABYY10983 | ME401 | 80 | 14382960 |
| 48790 | 137376 JS175W 1628695 | ME401 | 85 | 16954260 |
| 48794 | 137391 JS175W 1628701 | ME401 | 95 | 17879100 |
| 49093 | 137789 SV15 PCQ200932 | ME401 | 90 | 5670540 |
| 49098 | 505039 SV100 LBYY10905 | ME401 | 90 | 11127480 |
| 49102 | 1220176 2014_VIO80 1A211 | ME401 | 90 | 8155920 |
| 49104 | 137929 SV15 TCQ201819 | ME401 | 90 | 6180540 |
| 49106 | 1221721 Kramer_5085 353110132 | ME401 | 100 | 915120 |
Row
Table C: Barchart (Opgave 2) The below chart shows ranking of units in comparison with work average of run1, run2 and runOdo.
Row
Chart D: Plot Unit 205836 (Opgave 3) The below graph plots unit 205836 in comparison wiht time and engine speed.
Row
Chart E(Opgave 3) The below table shows the 6 units that have been working most with engine speed between 14 and 16.
| df_engine_t_h_agg.unitid | df_engine_t_h_agg.value |
|---|---|
| 346419 | 2106.212 |
| 309938 | 2066.000 |
| 309941 | 2047.124 |
| 210942 | 2044.957 |
| 346421 | 2005.204 |
| 194091 | 2002.222 |
Row
Chart F (Opgave 3) The below graph shows the unit that have been working most between 14 and 16 (346419) with engine speed.
