将pandas中跨不同列的重复值替换为“0”

import pandas as pd

data = {'A': ['foo', 'bar', 'foo', 'bar', 'foo', 'bar', 'foo', 'foo'],
        'B': ['one', 'one', 'two', 'two', 'one', 'one', 'two', 'two'],
        'C': [1, 2, 3, 4, 5, 6, 7, 8],
        'D': [1, 1, 2, 2, 3, 3, 4, 4]}

df = pd.DataFrame(data)

     A    B  C  D
0  foo  one  1  1
1  bar  one  2  1
2  foo  two  3  2
3  bar  two  4  2
4  foo  one  5  3
5  bar  one  6  3
6  foo  two  7  4
7  foo  two  8  4

df_pivot = df.pivot_table(index='A', columns='B', values='C', aggfunc='first', fill_value=0)

B    one  two
A            
bar    2    4
foo    1    3