对分组变量中的因子进行重新排序，以便可以使用ggplot2对其进行绘制

我正在尝试制作一张图表，显示按性别种族划分的平均年龄。图表本身应以最低平均年龄到最高平均年龄的顺序显示此信息，并按总体性别分组。

我正在根据按工作类别，性别/种族，性别和平均年龄分组的数据集进行工作。我已经可以使用以下代码按性别成功订购此商品：

rsltProf = rslt %>% 
      filter(group == "Professionals" & avg > 0) %>%
      group_by(gender) %>%
      arrange(avg, .by_group = TRUE)
str(rsltProf$genXrce)

我得到以下输出：

    group          genXrce   gender      avg
1 Professionals Female-Asian Female 33.25397
2 Professionals Female-Other Female 37.55000
3 Professionals Female-White Female 39.89632
4 Professionals Female-Black Female 39.94118
5 Professionals   Male-Other   Male 32.80000
6 Professionals   Male-Asian   Male 37.86667
7 Professionals   Male-Black   Male 38.69767
8 Professionals   Male-White   Male 38.85294
Factor w/ 9 levels "Female-Asian",..: 4 2 3 1 9 7 8 6

太好了，这正是我想要的。但是，当我用ggplot对其进行图形处理时，它会产生以下结果：

clearly, this is because ggplot2 is graphing by the order of the factors rather than the order of the arranged dataframe. I have tried multiple ways to relevel the genXrce based on how it's arranged in the above code to no avail, including relevel, mutate, and reorder.

My question is: How can I reorder/arrange the data in such a way that ggplot2 will produce a graph that gives ascending averages grouped by gender, in the same way as the table I produced does? Any advice much appreciated.

EDIT 1: In a below comment it was suggested to do use forcats or a similar function to arrange the graph through ggplot. An example like so:

ggplot(data = rsltProf, mapping = aes(x =fct_reorder(!!as.name(genXrce), avg), y =  avg, fill = genXrce))

但是，这将平均排列所有genXrce因子，并且不再按性别分开。要明确的是，小节的顺序应与表格相同->女白，女黑，女其他，女亚洲，男白，男黑....

上面的ggplot产生了下面的图表，该图表混杂了性别：