擅长:python、mysql、java
<p>尝试创建一个<code>map</code>{<cd2>}来映射状态</p>
<pre><code>fl = lambda s: s.iloc[[0,-1]]
d = {'mgr-mgr': 'hired as mgr', 'emp-mgr': 'promoted to mgr', 'emp-emp': 'hired as emp', 'mgr-emp': 'status change'}
res = df.groupby('email', as_index=False)['level'].apply(lambda x: (fl(x).shift(1) + "-" + (fl(x))).bfill()).map(d)
res.index= res.index.droplevel()
df['status'] = res
df.dropna(inplace=True)
</code></pre>
<hr/>
<div class="s-table-container">
^{tb1}$
</div>