擅长:python、mysql、java
<p>您只需设置数学公式,用列的名称来表示结果:</p>
<pre><code> df['col4'] = (df['col1']+df['col2'])/df['col3']
</code></pre>
<p>编辑:新请求的公式:</p>
<pre><code>df['Max(In/Out Util)-1Mbr'] = [df['Max(In/Out Util)']/100*df['Egress Speed']] / [df['Egress Speed']-(df['Egress Speed']/df['Oper. Member Count'])]*100
</code></pre>
<p>EDIT2:基于你的数字是用拉丁符号编码的(这是用逗号来表示小数点),你应该先用:</p>
<pre><code>df = df.apply(lambda x: x.str.replace(',','.'))
df['Max(In/Out Util)-1Mbr'] = df['Max(In/Out Util)-1Mbr'].astype(int)
df['Egress Speed'] = df['Egress Speed'].astype(int)
df['Oper. Member Count'] = df['Oper. Member Count'].astype(int)
</code></pre>
<p>然后你建议的公式是:</p>
<pre><code>df['Max(In/Out Util)-1Mbr'] = (df['Max(In/Out Util)']*df['Egress Speed']) / (df['Egress Speed'] - df['Egress Speed'] / df['Oper. Member Count'])
</code></pre>
<p>只要用最后的公式就行了。你知道吗</p>