擅长:python、mysql、java
<p>您可以将要忽略的值更改为<code>nan</code>,然后计算平均值。这可以通过<code>df.replace({0: pd.NA})</code>完成,如以下代码所示:</p>
<pre><code>import pandas as pd
df = pd.DataFrame({
"math": {"mark": 10, "tom":10, "hall": 0},
"english": {"mark":0, "tom": 20,"hall":25},
"chemistry": {"mark":20, "tom":30, "hall":15}
})
df["average_marks"] = df.replace({0: pd.NA}).mean(axis=1)
df
</code></pre>
<p>产出:</p>
<pre><code> math english chemistry average_marks
mark 10 0 20 15.0
tom 10 20 30 20.0
hall 0 25 15 20.0
</code></pre>