擅长:python、mysql、java
<P>考虑基于集合的(类似SQL)方法,使用{{CD1>}和^ {< CD2>}保留您的^ {CD3>}子句:</P>
<pre><code>final_df = (
df.query("Belonging == 'Car'")
.merge(df.query("Belonging == 'House' & Value > 400"),
on="Person", suffixes=["_Car","_House"])
)
# Person Belonging_Car Value_Car Belonging_House Value_House
# 0 Diana Car 15 House 450
# 1 Erika Car 11 House 600
</code></pre>
<p>或者没有房子的柱子:</p>
<pre><code>final_df = (
df.query("Belonging == 'Car'")
.merge((df.query("Belonging == 'House' & Value > 400")
.reindex(["Person"], axis="columns")),
on="Person")
)
# Person Belonging Value
# 0 Diana Car 15
# 1 Erika Car 11
</code></pre>