I have a list of 12 data frames with data related to the refueling of machines. The structure of which is as below:
Machine.No | Refuel.Date | Quantity | Engine.Hours
39 | 9/10/2022 | 696 | 34964
39 | 9/07/2022 | 1011 | 34926
39 | 9/04/2022 | 688 | 34869
... | ... | ... | ...
39 | 2/27/2014 | 190 | 256
39 | 2/21/2014 | 1010 | 217
Machines are scheduled to be refueled every 3 days, at which time the machine number, date, quantity in liters and engine hour meter are recorded. For various reasons, sometimes a machine will be refueled early and as such will have a lower quantity of fuel used for that day, or the machine may not have been used much which will be reflected in the Engine.Hours reading.
I would like to plot fuel usage for each machine over time, to see if any machines have increased their fuel usage. I expect the plot to look similar to this but with 12 lines and either Refuel.Date or Engine.Hours on the x-axis.
I'm not quite sure how to do it but I would like the data to be "smoothed" somewhat, so there aren't huge spikes in the plot, for example when a machine took 1010 liters of fuel one day and then only 190 liters the next.
I am using the R programming language.
Thanks in advance.