I need to transform from one schema to another. Is there any way of achieving this without doing a for loop?
Original data
[
{
"browser": "Chrome",
"count": 73,
"verdict": "detected"
},
{
"browser": "Opera",
"count": 3,
"verdict": "detected"
},
{
"browser": "Chrome",
"count": 3,
"verdict": "blocked"
},
{
"browser": "Edge",
"count": 1,
"verdict": "detected"
}
]
Transformed data
[
{
"browser": "Chrome",
"detected":73,
"blocked":3
},
{
"browser": "Opera",
"detected": 3,
"blocked": 0
},
{
"browser": "Edge",
"detected": 1,
"blocked": 0
}
]