I have a dataset like this:
| Timestamp | GeneratorPower1 | GeneratorPower2 | GeneratorPower3 |
|---|---|---|---|
| 2022-06-30 23:40 | NaN | NaN | NaN |
| 2022-06-30 23:50 | NaN | 7,61 | NaN |
| 2022-07-01 00:00 | 13,79 | 11,54 | NaN |
| 2022-07-01 00:10 | 14,58 | 13,67 | NaN |
| ... | ... | ... | ... |
| 2022-07-01 10:30 | 32,98 | 29,77 | 43,28 |
My aim is to compare the development of generator power in a graph to see which has the best performance over time since the installation. Currently they depend on the timestamp of every measurement/observation, but as I installed them on different days I won't get the graph I want by plotting just the Power column with the timestamp.
My first idea was to create extra columns like "Days since installation of Generator X" where I can count the days starting with the first measurement of each generator, which seems also a bit complicated.
Does anyone know a better or more elegant way to solve this problem? I would be happy for every food for my thoughts or a link to a very similar topic (I didn't find anything helpful), thank you!