Pandas多级索引与Dash DataTable：如何拆分同名索引避免表头合并

Dash DataTable的merge_duplicate_headers属性为全局匹配规则，只要同一层级的表头文本完全相同，就会跨上级分组合并，不会校验上级表头是否属于同一分组，因此会出现feedback和results下的同名二级表头AAA被跨分类合并的问题。

构造columns配置时，给不同一级分组下的二级表头追加不可见的零宽空格\u200B，保证同层级表头的实际文本值不同，但显示效果完全一致，无需修改原始数据结构，也不影响后续新增其他分类。

import dash_table
import pandas as pd
import dash

row_data={('id', '', ''): {0: 984, 1: 985, 2: 986, 3: 987, 4: 988},
 ('email', '', ''): {0: 'aa@gmail.com',1: 'bb@gmail.com',2: 'bb@gmail.com',3: 'cc@gmail.com',4: 'ff@dada.com'},
 ('feedback', 'AAA', 'Zaza'): {0: 'Perfect', 1: 'Loose',2: 'nan',3: 'nan',4: 'nan'},
 ('feedback', 'AAA', 'Kuku'): {0: 'Perfect',1: 'Tight',2: 'nan',3: 'nan',4: 'nan'},
 ('feedback', 'AAA', 'Duku'): {0: 'Tight',1: 'Perfect',2: 'nan',3: 'nan',4: 'nan'},
 ('feedback', 'AAA', 'Sasa'): {0: 'Tight',1: 'Perfect',2: 'nan',3: 'nan',4: 'nan'},
 ('feedback', 'AAA', 'Rere'): {0: 'Perfect',1: 'nan',2: 'nan',3: 'nan',4: 'nan'},
 ('results', 'AAA', 'Zaza'): {0: 14, 1: 12,2: 74,3: 87,4: 65},
 ('results', 'AAA', 'Kuku'): {0: 20, 1: 'nan', 2: 45, 3: 52, 4: 71},
 ('results', 'AAA', 'Duku'): {0: 25,1: 78,2: 25,3: 46,4: 89},
 ('results', 'AAA', 'Sasa'): {0: 45,1: 91,2: 45,3: 87, 4: 85},
 ('results', 'AAA', 'Rere'): {0: 42,  1: 77,  2: 45,  3: 12, 4: 41}}
df = pd.DataFrame.from_dict(row_data)

# 核心修改：处理表头文本，追加零宽空格区分不同一级分组下的同名二级表头
columns = []
for col in df.columns:
    modified_name = list(col)
    # 根据一级分类给二级表头加不同数量的零宽空格，确保文本唯一
    if modified_name[0] == 'feedback':
        modified_name[1] += '\u200B'
    elif modified_name[0] == 'results':
        modified_name[1] += '\u200B\u200B'
    columns.append({
        "name": tuple(modified_name),
        "id": "_".join(col)
    })

data = [ {"_".join(col): val for col, val in row.items() } for row in df.to_dict('records')]

app = dash.Dash(__name__)

app.layout = dash_table.DataTable(
    columns=columns,
    data=data,
    merge_duplicate_headers=True,
    style_cell={'textAlign': 'center'},
            css=[
            {'selector': 'th[data-dash-column^="id"]', 'rule': 'background-color: gray'},
            {'selector': 'th[data-dash-column^="email"]', 'rule': 'background-color: gray'},

            {'selector': 'th[data-dash-column^="results"]', 'rule': 'background-color: #3d69e1'},
            {'selector': 'th[data-dash-column^="feedback"]', 'rule': 'background-color: #849feb'},
            {'selector': 'th[data-dash-column^=""]', 'rule': 'background-color: #c0d1ff'}

        ]
)

if __name__ == '__main__':
    app.run_server(debug=False)

• 无需修改原始Pandas MultiIndex结构，不影响后续新增其他分类层级
• 零宽空格为不可见字符，不会改变表头的显示效果
• 列的id属性保持原有拼接逻辑，原有CSS、交互逻辑无需任何调整

内容的提问来源于stack exchange，提问作者Galat