i am making a Python script to check my power prices. and i cannot figure out how to handle this data, when the the list object is a timestamp…
in example this query
JavaScript
x
28
28
1
{
2
"2022-07-19T00:00:00+02:00": {
3
"NOK_per_kWh": 1.5862,
4
"valid_from": "2022-07-19T00:00:00+02:00",
5
"valid_to": "2022-07-19T01:00:00+02:00"
6
},
7
"2022-07-19T01:00:00+02:00": {
8
"NOK_per_kWh": 1.5942,
9
"valid_from": "2022-07-19T01:00:00+02:00",
10
"valid_to": "2022-07-19T02:00:00+02:00"
11
},
12
"2022-07-19T02:00:00+02:00": {
13
"NOK_per_kWh": 2.5051,
14
"valid_from": "2022-07-19T02:00:00+02:00",
15
"valid_to": "2022-07-19T03:00:00+02:00"
16
},
17
"2022-07-19T03:00:00+02:00": {
18
"NOK_per_kWh": 1.4132,
19
"valid_from": "2022-07-19T03:00:00+02:00",
20
"valid_to": "2022-07-19T04:00:00+02:00"
21
},
22
"2022-07-19T04:00:00+02:00": {
23
"NOK_per_kWh": 2.7307,
24
"valid_from": "2022-07-19T04:00:00+02:00",
25
"valid_to": "2022-07-19T05:00:00+02:00"
26
}
27
}
28
this is what i get from the api, and i would like to know how to handle it.
i have been googling, an i cannot find my solution.
Advertisement
Answer
I suppose that by “handle” you mean to iterate over timestamped objects and access all inner values:
JavaScript
1
4
1
for timestamp in data.keys():
2
print(data[timestamp]["NOK_per_kWh"])
3
}
4
or
JavaScript
1
4
1
for timestamp, obj in data.items():
2
print(timestamp, obj["valid_from"])
3
}
4