擅长:python、mysql、java
<p>下面是一个您可以尝试的想法,首先创建一个<code>Brother</code>列,将所有兄弟作为一个包含其自身的列表,然后分别删除其自身。可能会对代码进行优化,但您可以从以下方面入手:</p>
<pre><code>import numpy as np
import pandas as pd
df['Brother'] = df.groupby('Father')['Name'].transform(lambda g: [g.values])
def deleteSelf(row):
row.Brother = np.delete(row.Brother, np.where(row.Brother == row.Name))
return(row)
df.apply(deleteSelf, axis = 1)
# Name Father Brother
# 0 John Smith Erick Moon [Mathew Common]
# 1 Rodolph Ruppert Ralph Docker []
# 2 Mathew Common Erick Moon [John Smith]
# 3 Patrick French Stewart Adborn []
</code></pre>