I have a JSON input with different types, all representing a data point at a certain time. I have the start time of the event and am looking for a way to get all the data organised without having to revert to custom Python code - how do I do this? The 'time' type in JSON depicts how many seconds since the start time a data point is happening across all these types. Ideally I'm looking for something that looks like this based on the data below assuming the start time is 12:00:00, probably latlng even split but that's secondary for now: _time distance altitude latlng 12:00:00 3.8 51.5 -33.895627, 151.228228 12:00:01 5.2 51.6 -33.895627, 151.228228 12:00:03 6.7 51.5 -33.895627, 151.228228 12:00:04 8.9 51.5 -33.895627, 151.228228 [
{
"type": "time",
"data": [
0,
1,
3,
4
]
},
{
"type": "distance",
"data": [
3.8,
5.2,
6.7,
8.9
]
},
{
"type": "altitude",
"data": [
51.5,
51.6,
51.5,
51.5
]
},
{
"type": "latlng",
"data": [
[
-33.895627,
151.228228
],
[
-33.895627,
151.228228
],
[
-33.895627,
151.228228
],
[
-33.895627,
151.228228
],
]
},
]
... View more
