Plotly不从轴绘制条形图

2024-03-28 14:41:24 发布

您现在位置:Python中文网/ 问答频道 /正文

我试图从我使用pivot_表转换的CSV数据中绘制条形图。条形图应具有y轴上的计数和x轴上的公司状态

我得到的是: Bar chart not showing

最后,我想按CompanySizeId来堆叠条

我一直在关注this video

import plotly.graph_objects as go
import plotly.offline as pyo
import pandas as pd

countcompany = pd.read_csv(
    'https://raw.githubusercontent.com/redbeardcr/Plotly/master/Data/countcompany.csv')

df = pd.pivot_table(countcompany, index='CompanyStatusLabel',
                    values='n', aggfunc=sum)
print(df)

data = [go.Bar(
    x=df.index,
    y=df.values,
)]

layout = go.Layout(title='Title')

fig = go.Figure(data=data, layout=layout)

pyo.plot(fig)

代码可以找到here

谢谢你的帮助


Tags: csvimportgodfdataindexasplotly
1条回答
网友
1楼 · 发布于 2024-03-28 14:41:24

如果用y值展平数组,即用y=df.values.flatten()替换y=df.values,代码将按预期工作

import plotly.graph_objects as go
import plotly.offline as pyo
import pandas as pd

countcompany = pd.read_csv('https://raw.githubusercontent.com/redbeardcr/Plotly/master/Data/countcompany.csv')

df = pd.pivot_table(countcompany, index='CompanyStatusLabel', values='n', aggfunc=sum)

data = [go.Bar(
    x=df.index,
    y=df.values.flatten(),
)]

layout = go.Layout(title='Title')

fig = go.Figure(data=data, layout=layout)

pyo.plot(fig)

enter image description here

相关问题 更多 >