0

I have a json list of objects with one entry representing the name of the object and several key-value pairs. The key is a timestamp:

{
  "8cpu-64ram-hpcv2-lmem": {
    "18/10/2022 08:42:52 UTC": 221,
    "18/10/2022 08:59:06 UTC": 221,
    "18/10/2022 10:35:40 UTC": 223,
    "18/10/2022 10:40:52 UTC": 223
  },
  "32cpu-256ram-hpc-mem": {
    "18/10/2022 08:42:52 UTC": 0,
    "18/10/2022 08:59:06 UTC": 0,
    "18/10/2022 10:35:40 UTC": 0,
    "18/10/2022 10:40:52 UTC": 0
  },
  "1cpu-4ram-test": {
    "18/10/2022 08:42:52 UTC": 427,
    "18/10/2022 08:59:06 UTC": 427,
    "18/10/2022 10:35:40 UTC": 443,
    "18/10/2022 10:40:52 UTC": 443
  }
}

I want to convert it into a table with the names of the objects in the first column and the values in one column per timestamp to visualize the changes over time in a graph. The list of values with timestamp will grow a lot:

Name "18/10/2022 08:42:52 UTC" "18/10/2022 08:59:06 UTC" "18/10/2022 10:35:40 UTC" "18/10/2022 10:40:52 UTC"
"8cpu-64ram-hpcv2-lmem" 221 221 223 223
"32cpu-256ram-hpc-mem" 0 0 0 0
"1cpu-4ram-test" 427 427 443 443

0 Answers0