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