我想使用python在下面的数据框中只加粗产品下的水果和蔬菜,并将数据传输到excel,在excel中水果和蔬菜应该是粗体。感谢你的帮助!
df:
Code Product Limit Value
0 3A68185 Fruits 0.6 0.000000
1 3A68185 Apple 0.6 0.000000
3 3B22979 Fruits 3.5 0.430146
2 3B22979 Apple 3.5 0.430146
4 3B22979 Orange 0.0 0.000000
6 3C67260 Fruits 3.0 1.123774
5 3C67260 Apple 3.0 1.123774
7 3C71601 Vegetables 15.0 0.000000
8 3C71601 Tomato 15.0 0.000000
14 3C78910 Fruits 2.0 1.187282
15 3C78910 Apple 2.0 1.187282
16 3C82861 Fruits 64.0 0.560864
17 3C82861 Apple 15.0 0.000000
18 3C82861 Orange 49.0 0.560864
21 3D11357 Vegetables 26.0 0.000000
19 3D11357 Tomato 25.5 0.000000
20 3D11357 Onion 0.5 0.000000
23 3D51126 Vegetables 15.0 0.000000
24 3D51126 Tomato 14.5 0.000000
22 3D51126 Onion 0.5 0.000000
26 3E20062 Vegetables 1.0 0.000000
25 3E20062 Onion 1.0 0.000000
10 3E45212 Fruits 5.0 0.000000
9 3E45212 Apple 5.0 0.000000
13 3E45212 Vegetables 36.0 0.000000
11 3E45212 Tomato 35.5 0.000000
12 3E45212 Onion 0.5 0.000000
预期输出:代码产品极限值0 3A68185水果0.6 0.0000001 3A68185苹果0.6 0.0000003 3B22979水果3.5 0.4301462 3B22979苹果3.5 0.4301464 3B22979橙色0.0 0.0000006 3C67260水果3.0 1.1237745 3C67260苹果3.0 1.1237747 3C71601蔬菜15.00.0000008 3C71601番茄15.00.00000014 3C78910水果2.0 1.18728215 3C78910苹果2.0 1.18728216 3C82861水果64.0 0.56086417 3C82861苹果15.00.00000018 3C82861橙色49.0 0.56086421 3D11357蔬菜26.0 0.00000019 3D11357番茄25.50.00000020 3D11357洋葱0.5 0.00000023 3D51126蔬菜15.00.00000024 3D51126番茄14.5 0.00000022 3D51126洋葱0.5 0.00000026 3E20062蔬菜1.0 0.00000025 3E20062洋葱1.0 0.00000010 3E45212水果5.0 0.0000009 3E45212苹果5.0 0.00000013 3E45212蔬菜36.0 0.00000011 3E45212番茄35.5 0.00000012 3E45212洋葱0.5 0.000000
您可以使用这个:
def bold_categ(cat):
return ['font-weight: bold' if i in ["Vegetables","Fruits"] else () for i in cat]
df.style.apply(bold_categ)