擅长:python、mysql、java
<pre><code>In [403]: df.join(df.CATZ.str.get_dummies())
Out[403]:
CATX CATY CATZ AAA BBB CCC DDD EEE FFF
0 A G AAA 1 0 0 0 0 0
1 B H BBB 0 1 0 0 0 0
2 C I AAA 1 0 0 0 0 0
3 B J CCC 0 0 1 0 0 0
4 A G BBB 0 1 0 0 0 0
5 B H DDD 0 0 0 1 0 0
6 D K EEE 0 0 0 0 1 0
7 E L FFF 0 0 0 0 0 1
</code></pre>
<p>或:</p>
<pre><code>In [410]: df.join(df.CATZ[df.CATZ.isin(['AAA','BBB'])].str.get_dummies(), how='left').fillna(0)
Out[410]:
CATX CATY CATZ AAA BBB
0 A G AAA 1.0 0.0
1 B H BBB 0.0 1.0
2 C I AAA 1.0 0.0
3 B J CCC 0.0 0.0
4 A G BBB 0.0 1.0
5 B H DDD 0.0 0.0
6 D K EEE 0.0 0.0
7 E L FFF 0.0 0.0
</code></pre>