Hello.
In "Dictionary", is it possible to find the sum of the average "B" values of "A" values for the same date and create one for each date?
ex)
a = [ { "Bdata": 2826.5, "time": "2023-09-15", "Adata": 51.5 },
{ "Bdata": 29629.0, "time": "2023-09-18", "Adata": 50.8 },
{ "Bdata": 346.8, "time": "2023-09-19", "Adata": 32.8 },
{ "Bdata": 7274.9, "time": "2023-09-15", "Adata": 50.9 },
{ "Bdata": 29630.3, "time": "2023-09-18", "Adata": 50.7 },
{ "Bdata": 334.9, "time": "2023-09-19", "Adata": 40.4 },
{ "Bdata": null, "time": "2023-09-15", "Adata": null },
{ "Bdata": 4247.0, "time": "2023-09-18", "Adata": 50.3 },
{ "Bdata": 351.3, "time": "2023-09-19", "Adata": 54.8 } ]
===>>
[ { Bdata: sum,||time: 2023-09-15, Adata: average },
{ Bdata: sum,||time: 2023-09-18, Adata: average },
{ Bdata: sum,||time: 2023-09-19, Adata: average } ]
Please tell me how to change this!!
Tanks