擅长:python、mysql、java
<p>您可以创建一个与<code>GROUP</code>相同的伪列,然后将该伪列用作<code>pivot_table()</code>中的值</p>
<pre class="lang-py prettyprint-override"><code>df['GROUP_'] = df['GROUP']
df_ = ~ pd.pivot_table(df, index=['ID', 'REV'], columns='GROUP', values='GROUP_').isna()
</code></pre>
<pre><code>print(df_)
GROUP 1 2 3
ID REV
0 0 True True False
1 1 True True True
print(df_.reset_index().rename_axis(None,axis=1))
ID REV 1 2 3
0 0 0 True True False
1 1 1 True True True
</code></pre>