如何显示plotly.express直方图的悬停数据中的所有出现情况

Question

我正在尝试在 plotly 中构建一个直方图，它可以使用 hover_data 参数显示直方图箱中其他列的数据。作为示例，采用以下小数据集：

import pandas as pd

word_data = {'author':['Martin Luther King Jr.',
                       'Martin Luther King Jr.',
                       'Martin Luther King Jr.',
                       'Malcolm X',
                       'Malcolm X',
                       'Fred Hampton',
                       'Fred Hampton',
                       'James Baldwin',
                       'James Baldwin'], 
             'words': ['dream', 'color', 'nonviolence',
                       'color', 'rights',
                       'panthers', 'rights',
                       'color', 'rights']}

words_df = pd.DataFrame(word_data)
print(words_df)

其结果（仅供参考）：

                   author        words
0  Martin Luther King Jr.        dream
1  Martin Luther King Jr.        color
2  Martin Luther King Jr.  nonviolence
3               Malcolm X        color
4               Malcolm X       rights
5            Fred Hampton     panthers
6            Fred Hampton       rights
7           James Baldwin        color
8           James Baldwin       rights

我构建了以下 plotly 直方图：

import plotly.express as px

fig = px.histogram(words_df, x='words', hover_data=['author'],
                  labels={
                      'words': 'Most Common Words'
                  },
                   title='Most Common Words that Speakers Use'
                  ).update_xaxes(categoryorder='total descending').update_layout(yaxis_title='Number of Speakers')
fig.show()

如您所见，悬停数据仅显示值从字数和计数。我正在尝试找到一种方法，将使用与给定垃圾箱相关的单词的发言者列表合并到其悬停数据中。我尝试将 ['author'] 传递到 hover_data 参数中，但这似乎不起作用。有谁知道如何实现这一目标？

Answer 1

如果您准备好数据框，则可以将其作为条形图。

import pandas as pd
import plotly.express as px

word_data = {
    "author": [
        "Martin Luther King Jr.",
        "Martin Luther King Jr.",
        "Martin Luther King Jr.",
        "Malcolm X",
        "Malcolm X",
        "Fred Hampton",
        "Fred Hampton",
        "James Baldwin",
        "James Baldwin",
    ],
    "words": [
        "dream",
        "color",
        "nonviolence",
        "color",
        "rights",
        "panthers",
        "rights",
        "color",
        "rights",
    ],
}

words_df = pd.DataFrame(word_data)

px.bar(
    words_df.groupby("words", as_index=False)
    .agg(count=("words", "size"), speakers=("author", list))
    .sort_values(["count", "words"], ascending=[0, 1]),
    x="words",
    y="count",
    hover_data=["speakers"],
    title="Most Common Words that Speakers Use",
).update_layout(xaxis_title="Most Common Words", yaxis_title="Number of Speakers")