擅长:python、mysql、java
<p>这应该可以做到:</p>
<pre class="lang-py prettyprint-override"><code>df["_dummy"]=1
df2=pd.concat([
df.pivot_table(index="Employee", columns="Location", values="_dummy", aggfunc=max),
df.pivot_table(index="Employee", columns="Title", values="_dummy", aggfunc=max)
], axis=1).fillna(0).astype(int).reset_index(drop=False)
</code></pre>
<p>参考:<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.pivot_table.html" rel="nofollow noreferrer">https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.pivot_table.html</a></p>