擅长:python、mysql、java
<p>也许您可以尝试使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.assign.html" rel="nofollow noreferrer">pandas.DataFrame.assign</a>执行此操作:</p>
<pre><code>>>> import pandas as pd
>>> df = pd.DataFrame([
... ['sn11','N','Y','Y','Y'],
... ['sn1','N','Y','N','N'],
... ['sn1','Y','N','Y','N'],
... ['sn2','Y','Y','N','N'],
... ['null','N','Y','N','Y']
>>> df
category value body legs face
0 sn11 N Y Y Y
1 sn1 N Y N N
2 sn1 Y N Y N
3 sn2 Y Y N N
4 null N Y N Y
>>> df[df['body']==df['legs']] = df[df['body']==df['legs']].assign(value=df['face'])
>>> df
category value body legs face
0 sn11 Y Y Y Y
1 sn1 N Y N N
2 sn1 Y N Y N
3 sn2 Y Y N N
4 null N Y N Y
</code></pre>