擅长:python、mysql、java
<p>您可以使用:</p>
<pre><code>df = pd.pivot(index=df['Animal'],
columns=df.groupby('Animal').cumcount().add(1).astype(str),
values=df['Food'])
.add_prefix('Food').fillna('')
print (df)
Food1 Food2 Food3
Animal
dog carrots
horse grass hay
rabbit grass carrots cabbage
</code></pre>
<p>或:</p>
<pre><code>df = pd.crosstab(df['Animal'], df['Food']).astype(bool)
print (df)
Food cabbage carrots grass hay
Animal
dog False True False False
horse False False True True
rabbit True True True False
</code></pre>