给定以下Pandas DataFrame(原始DataFrame有200多行):
import pandas as pd
df = pd.DataFrame({
'child': ['Europe', 'France', 'Paris','North America', 'US', 'Canada'],
'parent': ["", 'Europe', 'France',"", 'North America', 'North America'],
'value': [746.4, 67.75, 2.16, 579,331.9, 38.25]
})
df
个
|---+---------------+---------------+--------|
| | child | parent | value |
|---+---------------+---------------+--------|
| 0 | Europe | | 746.40 |
| 1 | France | Europe | 67.75 |
| 2 | Paris | France | 2.16 |
| 3 | North America | | 579.00 |
| 4 | US | North America | 331.90 |
| 5 | Canada | North America | 38.25 |
|---+---------------+---------------+--------|
我想生成以下JSON树:
[
{
name: 'Europe',
value: 746.4,
children: [
{
name: 'France',
value: 67.75,
children: [
{
name: 'Paris',
value: 2.16
}
]
}
]
},
{
name: 'North America',
value: 579,
children: [
{
name: 'US',
value: 331.9,
},
{
name: 'Canada',
value: 38.25
}
]
}
];
这棵树将被用作ECharts可视化的输入,例如这basic sunburst chart.