python - 如何使用电子表格中的两个不同列制作分组条形图？

Question

我正在做一个业余项目，但在制作显示州内学费和州外学费的分组条形图时遇到了麻烦。我只能显示其中之一。如何使其并排显示每个学院？

import plotly.express as px
import pandas as pd
import plotly.graph_objects as go
import plotly.io as pio

df = pd.read_csv('college_data.csv')

barchart = px.bar(
    data_frame = df,
    x = "college_name",
    #color = "out-of-state_tuition",
    y = "in-state_tuition",
    opacity = 0.9,
    orientation = "v",
    barmode = 'group',
    title='Annual In-State Tuition vs Out-of-state Tuition',
)
pio.show(barchart)

仅使用一列的条形图:

具有 2 个不同列的电子表格:

Answer 1

• 样本数据作为图像并且不完整，因为列使得在答案中无法使用。由此合成。
• https://plotly.com/python-api-reference/generated/plotly.express.bar.html x 或 y 可以选择是列引用或 array_likes 的列表，在这种情况下，数据将被视为“宽”而不是“长”。

import numpy as np
df = pd.DataFrame({"college_name":list("ABCD"),"in-state_tuition":np.random.randint(5000,7000,4),"out-of-state_tuition":np.random.randint(8000,15000,4)})

px.bar(
    data_frame = df,
    x = "college_name",
    y = ["in-state_tuition","out-of-state_tuition"],
    opacity = 0.9,
    orientation = "v",
    barmode = 'group',
    title='Annual In-State Tuition vs Out-of-state Tuition',
)