擅长:python、mysql、java
<p>IIUC,我们可以使用<code>melt</code>、<code>loc</code>和<code>groupby</code>和<code>agg(list)</code>注意,这只在0.24+中有效</p>
<pre><code>s = df.melt(id_vars='Name',var_name='vehicle')
new_df = s.loc[s['value'] == 1].groupby('Name')['vehicle'].agg(list).to_frame()
</code></pre>
<hr/>
<pre><code>print(new_df)
vehicle
Name
Doug [motorcycle, car]
Mike [car]
Sarah [motorcycle]
</code></pre>