英文:
How to create bar chart with geomean, mean, max and min from data using Plotnine
问题
如何为每个类别创建包含gmean、mean、max和min统计数据的条形图。
对于以下数据，
| X | B | Y |
|---|---|---|
| A1 | b1 | 4 |
| A1 | b2 | 2 |
| A1 | b3 | 3 |
| A1 | b4 | 8 |
| A2 | b1 | 7 |
| A2 | c1 | 10 |
| A2 | c2 | 8 |
| A2 | b3 | 7 |
| A3 | b4 | 10 |
| A3 | b5 | 9 |
| A3 | b1 | 4 |
| A3 | b3 | 1 |
图表应该如下所示，
英文:
How to create bar chart with gmean, mean, max and min stats for each category.
For the data below,
| X | B | Y |
|---|---|---|
| A1 | b1 | 4 |
| A1 | b2 | 2 |
| A1 | b3 | 3 |
| A1 | b4 | 8 |
| A2 | b1 | 7 |
| A2 | c1 | 10 |
| A2 | c2 | 8 |
| A2 | b3 | 7 |
| A3 | b4 | 10 |
| A3 | b5 | 9 |
| A3 | b1 | 4 |
| A3 | b3 | 1 |
The chart should look like,
答案1
得分: 1
你需要准备（计算汇总）要可视化的数据。
import pandas as pdfrom plotnine import ggplot, aes, geom_colfrom scipy.stats import gmeanfrom pandas.api.types import CategoricalDtype# 原始数据df = pd.DataFrame({"X": sorted(("A1", "A2", "A3") * 4),"Y": [4, 2, 3, 8, 7, 10, 8, 7, 10, 9, 4, 1]})# 计算汇总df2 = (df.groupby("X").agg({"Y": [gmean, "mean", "max", "min"]}).unstack().reset_index().rename(columns={0: "value", "level_1": "agg"}))# 排序汇总df2["agg"] = df2["agg"].astype(CategoricalDtype(["gmean", "mean", "max", "min"]))(ggplot(df2, aes("X", "value", fill="agg"))+ geom_col(position="dodge"))
英文:
You need to prepare(calculate the aggregates) the data you want to visualise.
import pandas as pdfrom plotnine import ggplot, aes, geom_colfrom scipy.stats import gmeanfrom pandas.api.types import CategoricalDtype# Original Datadf = pd.DataFrame({"X": sorted(("A1", "A2", "A3") * 4),"Y": [4, 2, 3, 8, 7, 10, 8, 7, 10, 9, 4, 1]})# Calculate the aggregatesdf2 = (df.groupby("X").agg({"Y": [gmean, "mean", "max", "min"]}).unstack().reset_index().rename(columns={0: "value", "level_1": "agg"}))# Order the aggregatesdf2["agg"] = df2["agg"].astype(CategoricalDtype(["gmean", "mean", "max", "min"]))(ggplot(df2, aes("X", "value", fill="agg"))+ geom_col(position="dodge"))
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论