擅长:python、mysql、java
<p>这对我很有用,而且从好的方面来说,是非常可读的!在</p>
<pre><code>strings = ['jan', 'feb', 'mar', 'apr', 'may']
replacement = ['January', 'February', 'March', 'April', 'May']
def match_string(col3, col2):
# if in col3, return that result. Else, lazy eval for col2. If neither, return empty string.
k = ([replacement[strings.index(s)] for s in strings if s in col3]) or ([s for s in replacement if s in col2])
return k[0] if k else ''
df['NewCol4'] = df.apply(lambda x: match_string(x['SearchCol3'], x['Col2']), axis=1)
</code></pre>
<p>输出:</p>
^{pr2}$