擅长:python、mysql、java
<p>让我们做吧</p>
<pre><code>yourdf=df.City.str.split('|').explode().to_frame('City').join(df[df.columns.difference(['City'])])
City EmployeeId
0 Mumbai 157
0 Bangalore 157
1 Pune 292
1 Mumbai 292
1 Delhi 292
2 Mumbai 643
2 Bangalore 643
3 Mumbai 124
3 Pune 124
4 Bangalore 355
</code></pre>