I have a small dataset in JSON file which I want to convert into hierarchal data format to create a tree map. This is part of my dataset:
{
"root": [
{"Folder": "Videos", "filename": "file1.mp4", "size": 77},
{"Folder": "Videos", "filename": "file2.mp4", "size": 10},
{"Folder": "Misc", "filename": "file11.ppt", "size": 1},
{"Folder": "Misc", "filename": "file12.ppt", "size": 3}
]
}
This is the output I am looking for:
{
"name": "root",
"children": [
{ "name": "Videos",
"children": [
{ "name": "file1.mp4" , "size" : 77},
{ "name": "file2.mp4" , "size" : 10}
]
},
{ "name": "Misc",
"children": [
{ "name": "file11.ppt" , "size" : 1},
{ "name": "file12.ppt" , "size" : 3}
]
}
]
}
I know I have to group it somehow but I can't figure out how. Any idea how should I proceed with this?