瀑布颜色和熊猫iloc格式

Question

我已经创建了一个瀑布使用Plotly通过创建两个数据文件从excel。我可以将数据的数字格式更改为3小数点，但当我使用iloc时则不能。有办法吗？

此外，我无法找到一个关于是否可以更改的答案：

bars

• background颜色的
• 个人颜色
• y轴标度和格式

我在下面添加了一个例子。

import plotly.express as px
import plotly.graph_objects as go

start = 0.143
ap = 0.02
impairments = 0.03
PVA = -0.02
other =0.04
rwa = 0.02
end = 0.146

fig = go.Figure(go.Waterfall(
name = "legend", orientation = "v",
measure = ["relative", "relative", "relative", "relative", "relative","relative","total"],
x = ["Start", "AP", "Impairments", "PVA", "Other", "RWA", "Final point"],
textposition = "outside",
text = [start*100, ap*100, impairments*100,PVA*100, other*100, rwa*100, end*100],
y = [start, ap, impairments, PVA, other, rwa, end], 
connector = {"line":{"color":"rgb(63, 63, 63)"}}, )) 
fig.update_layout( 
title = "CET1 movements",
showlegend = False ) 
fig.show()

非常感谢

Answer 1

我想我找到了你要找的大部分东西。我评论了您要求的部分代码，并对您的代码进行了一些格式化。

import plotly.graph_objects as go
import pandas as pd
import numpy as np

x = ["Start", "AP", "Impairments", "PVA", "Other", "RWA", "Final point"]
y = [0.143, 0.02, 0.03,-0.02, 0.04, 0.02, 0.146]

df = pd.DataFrame({"x":x,
                   "y":y})

# here you better work with string
df["text"] = (df["y"]*100).apply(lambda x: '{:,.3f}'.format(x))

# to lazy to write all possible cases
df["measure"] = np.where(df["x"]=="Final point", "total", "relative")
# as alternative
# df["measure"] = ["relative"]*(len(df)-1) + ["total"]

fig = go.Figure()
fig.add_trace(
    go.Waterfall(x=df["x"],
                 y=df["y"],
                 text=df["text"],
                 measure=df["measure"],
                 textposition = "outside",
                 orientation = "v",
                 connector = {"line":{"color":"rgb(63, 63, 63)"}},
                 # set colors for different types of bars
                 # see https://plotly.com/python/waterfall-charts/#setting-marker-size-and-color
                 decreasing = {"marker":{"color":"Maroon",
                                         "line":{"color":"red", 
                                                 "width":2}}},
                 increasing = {"marker":{"color":"Teal"}},
                 totals = {"marker":{"color":"orange", 
                                     "line":{"color":'blue', 
                                             "width":3}}}


                ))

# with this you can change the yaxes range
fig.update_yaxes(range=[0, 0.3])
fig.update_layout(title="CET1 movements",
                  title_x=0.5,
                  # background color
                  plot_bgcolor="lightgrey")
fig.show()

​

​

我认为我做的颜色选择是可怕的，但你可以做它。