<p>可以按样式和<a href="http://pandas.pydata.org/pandas-docs/stable/user_guide/style.html#Export-to-Excel" rel="nofollow noreferrer">export to excel</a>设置背景色:</p>
<pre><code>def color(x):
c1 = 'background-color: green'
c2 = 'background-color: red'
c = ''
m = x['Income januari 2019'] > x['Income Januari 2018']
df1 = pd.DataFrame(c, index=x.index, columns=x.columns)
df1['increase▲/decrease▼'] = np.where(m, c1, c2)
return df1
df['increase▲/decrease▼'] = df['Income januari 2019'] - df['Income Januari 2018']
print (df)
sector Income Januari 2018 Income januari 2019 increase▲/decrease▼
0 1 2000 3000 1000
1 1 7000 1000 -6000
df.style.apply(color,axis=None).to_excel('styled.xlsx', engine='openpyxl', index=False)
</code></pre>
<p>如果需要输出列中的绝对值,请添加<a href="http://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.abs.html" rel="nofollow noreferrer">^{<cd1>}</a>:</p>
<pre><code>df['increase▲/decrease▼'] = (df['Income januari 2019'] - df['Income Januari 2018']).abs()
print (df)
sector Income Januari 2018 Income januari 2019 increase▲/decrease▼
0 1 2000 3000 1000
1 1 7000 1000 6000
</code></pre>