如何在pandas数据透视表中创建仅包含已填充列的匹配值的新列？

   Name  Category  Value
0   A    Category1   10
1   B    Category2   20
2   C    Category1   NaN
3   D    Category2   30

import pandas as pd

df = pd.DataFrame({'Name': ['A', 'B', 'C', 'D'],
                   'Category': ['Category1', 'Category2', 'Category1', 'Category2'],
                   'Value': [10, 20, None, 30]})

pivot_table = pd.pivot_table(df, index='Name', columns='Category', values='Value')

Category  Category1  Category2
Name
A              10.0        NaN
B               NaN       20.0
C               NaN        NaN
D               NaN       30.0

pivot_table_filled = pivot_table.fillna(0)

Category  Category1  Category2
Name
A              10.0        0.0
B               0.0       20.0
C               0.0        0.0
D               0.0       30.0

pivot_table_filled['Matched'] = pivot_table_filled.apply(lambda row: row[row != 0].index[0], axis=1)

Category  Category1  Category2  Matched
Name
A              10.0        0.0  Category1
B               0.0       20.0  Category2
C               0.0        0.0
D               0.0       30.0  Category2