PyQt5中QBarChart职位与性别统计数值不匹配问题求助

我使用QChart创建了一个条形图，想要按职位统计并展示男性和女性员工的总人数，但如图所示，统计出来的数值和对应的职位标签无法正确匹配。

实现代码 #

def second_create_bar(self):
    # 查询各职位男性员工数量
    male_barchart = ''' SELECT position, COUNT(*) AS Male_Count FROM employee WHERE gender='Male' GROUP BY position  '''
    male_barchart_sql = cur.execute(male_barchart).fetchall()

    series = QBarSeries()
    set0 = QBarSet("Male")
    for male in male_barchart_sql:
        set0 << male[1]
        series.append(set0)

    # 查询各职位女性员工数量
    female_barchart = ''' SELECT position, COUNT(*) AS Female_Count FROM employee WHERE gender='Female' GROUP BY position  '''
    female_barchart_sql = cur.execute(female_barchart).fetchall()

    set1 = QBarSet("Female")
    for female in female_barchart_sql:
        set1 << female[1]
        series.append(set1)
  
    chart = QChart()
    chart.addSeries(series)
    chart.setTitle("Gender- Employee Positions Total ")
    chart.setAnimationOptions(QChart.SeriesAnimations)

    # 定义职位分类
    categories = ["Auditor", "Clerk", "Directors", "Managers", "VOs"]
    axis = QBarCategoryAxis()
    axis.append(categories)
    chart.createDefaultAxes()
    chart.setAxisX(axis, series)

    # 设置图例
    chart.legend().setVisible(True)
    chart.legend().setAlignment(Qt.AlignBottom)

    chartView = QChartView(chart)
    chartView.setRenderHint(QPainter.Antialiasing)

    self.ui.widget_321.setChart(chart)

当前展示效果 #

内容的提问来源于stack exchange，提问作者Kobby