擅长:python、mysql、java
<p>如果空白值缺少值,请将pandas <a href="https://pandas.pydata.org/pandas-docs/stable/user_guide/style.html" rel="nofollow noreferrer">styles</a>与自定义函数一起使用:</p>
<pre><code>df = pd.DataFrame({'T':[np.nan, np.nan, 1, 5],
'A':range(4),
'B':list('abcd')})
print (df)
T A B
0 NaN 0 a
1 NaN 1 b
2 1.0 2 c
3 5.0 3 d
def highlight(x):
c = 'background-color: lime'
df1 = pd.DataFrame('', index=x.index, columns=x.columns)
m = x.isna().any(axis=1)
df1 = df1.mask(m, c)
return df1
df.style.apply(highlight, axis=None).to_excel('styled.xlsx', engine='openpyxl', index=False)
</code></pre>