擅长:python、mysql、java
<p>对于Python:</p>
<pre><code>df = df.replace(np.nan, '', regex = True)
df['diff'] = df.apply(lambda x: x['column2'].replace(x['column1'], '').strip(), axis = 1)
df = df.replace('', np.nan, regex = True)
</code></pre>
<p>输出:</p>
<pre><code> column1 column2 diff
0 Admission Date Residence - Location Residence - Location
1 Malnutrition Malnutrition-12 -12
2 TB NaN NaN
3 Anaemia NaN NaN
</code></pre>