用Tableau画嵌套气泡图

import pandas as pd
import json
df=pd.read_csv('test.csv',encoding='gb2312')

Level1_sum=df.groupby('Level1').sum('value').reset_index()
Level1_sum.rename(columns={'Level1':'Lebel'},inplace=True)
concat_sum=pd.concat([Level1_sum])
dic_Level1=[]
for x in range(Level1_sum.shape[0]):
    Level2_sum=df[df.Level1==Level1_sum.Lebel[x]].groupby('Level2').sum('value').reset_index()
    Level2_sum.rename(columns={'Level2':'Lebel'},inplace=True)
    concat_sum=pd.concat([concat_sum,Level2_sum])
    dic_Level2=[]
    for y in range(Level2_sum.shape[0]):
        Level3_sum=df[df.Level2==Level2_sum.Lebel[y]].groupby('Level3').sum('value').reset_index()
        Level3_sum.rename(columns={'Level3':'Lebel'},inplace=True)
        concat_sum=pd.concat([concat_sum,Level3_sum])
        dic_Level3=[]
        for z in range(Level3_sum.shape[0]):
            dic_Level3.append(dict(id=Level3_sum.Lebel[z] ,datum=Level3_sum.value[z]))
        dic_Level2.append(dict(id=Level2_sum.Lebel[y] ,datum=Level2_sum.value[y],children=dic_Level3))
    dic_Level1.append(dict(id=Level1_sum.Lebel[x] ,datum=Level1_sum.value[x],children=dic_Level2))

#生成json
data=json.dumps(eval(str(dic_Level1))) 
#第二部分输出没有value值，增加一个输出文件，方便tableau里添加标签
concat_sum.reset_index(drop=True).to_csv('test_label.csv',encoding='utf-8-sig')

import csv
import circlify
import matplotlib.pyplot as plt

# 将第一部分的json数据赋值给data
data=json.loads(data)

# Compute circle positions thanks to the circlify() function
# The maximum radius is set to 1.
circles = circlify.circlify(
    data,
    show_enclosure=False,
    target_enclosure=circlify.Circle(x=0, y=0, r=1)
)

# To ensure in Tableau the sizing works the fig size is the same x*y.
fig, ax = plt.subplots(figsize=(10,10))

# Add axes
ax.axis('on')

# Find axis boundaries, lim will be 1.0 with current settings
lim = max(
    max(
        abs(circle.x) + circle.r,
        abs(circle.y) + circle.r,
    )
    for circle in circles
)
plt.xlim(-lim, lim)
plt.ylim(-lim, lim)

# Amend Radius zone, Make sure Inner pad always > than Outer pad
padding_outer = 1
padding_inner = 1

header = ['ID', 'X co-ord', 'Y-cord', 'Radius', 'Rank',"Level"]
rank = 1

with open('test_result.csv', 'w',newline="") as f:
    writer = csv.writer(f)
    writer.writerow(header)

    # World Level
    for circle in circles:
        if circle.level != 1:
            continue
        x, y, r = circle
        level =1
        label = circle.ex["id"]
        #print(label,x,y,r,level)
        printdata = [label, x, y, r, rank,level]
        rank = rank + 1
        writer.writerow(printdata)

        # Not needed for Tableau
        ax.add_patch(plt.Circle((x, y), r*padding_outer, alpha=0.5, linewidth=2, color="lightblue"))

        # Continent Level
        for circle in circles:
            if circle.level != 2:
                continue
            x, y, r = circle
            level =2
            label = circle.ex["id"]
            #print(label,x,y,r,level)
            printdata = [label, x, y, r, rank,level]
            rank = rank + 1
            writer.writerow(printdata)

            # Not needed for Tableau
            ax.add_patch(plt.Circle((x, y), r*padding_outer, alpha=0.5, linewidth=2, color="lightblue"))

        # Country Level 
        for circle in circles:
            if circle.level != 3:
                continue
            x, y, r = circle
            level =3
            label = circle.ex["id"]
            #print(label,x,y,r)
            printdata = [label, x, y, r, rank,level]
            rank = rank + 1
            writer.writerow(printdata)

            # Not needed for Tableau
            ax.add_patch(plt.Circle((x, y), r*padding_inner, alpha=0.5, linewidth=2, color="#69b3a2"))
            plt.annotate(label, (x,y), ha='center', color="white")

# Show The Example Of The Graph We Will Be Recreating!
plt.show()