擅长:python、mysql、java
<pre><code>pd.crosstab(df.index,df.CATZ)[['AAA','BBB']]
Out[66]:
CATZ AAA BBB
row_0
0 1 0
1 0 1
2 1 0
3 0 0
4 0 1
5 0 0
6 0 0
7 0 0
pd.concat([df,pd.crosstab(df.index,df.CATZ)[['AAA','BBB']]],1)
Out[68]:
CATX CATY CATZ AAA BBB
row_0
0 A G AAA 1 0
1 B H BBB 0 1
2 C I AAA 1 0
3 B J CCC 0 0
4 A G BBB 0 1
5 B H DDD 0 0
6 D K EEE 0 0
7 E L FFF 0 0
</code></pre>