擅长:python、mysql、java
<p>您可以将<code>apply()</code>与查找dict一起使用</p>
<pre class="lang-py prettyprint-override"><code>lookup = {'10': 'Firstfilled', '01': 'Secondfilled', '11': 'bothfilled', '00': 'missing'}
def fill(row):
key = '00'
if row['First'] != '':
key = '1' + key[1]
if row['Second'] != '':
key = key[0] + '1'
return lookup[key]
df['Third'] = df.apply(fill, axis=1)
</code></pre>
<pre><code># print(df)
First Second Third
0 12 Secondfilled
1 missing
2 A 10 bothfilled
3 B Firstfilled
4 B Firstfilled
5 C 11 bothfilled
</code></pre>