r - 使用 highcharter 在旭日形图中显示平均值而不是总和

Question

我正在尝试使用 R 中的 highcharter 包制作旭日形图。这是代码：

data <- read.csv('Student_CGPA.csv')
out <- data_to_hierarchical(data, c(Semester, Course), CGPA)
hchart(out, type = "sunburst")

正如您在图片中看到的，当我滚动图表时，它显示了所有学生的课程的 CGPA 总和。
输出：

structure(list(Student_Id = 1:6, Name = c("James", "John", "Robert", 
"Michael", "William", "Mary"), Gender = c("M", "M", "M", "M", 
"M", "F"), Stream = c("BTech", "BTech", "BTech", "BTech", "BTech", 
"BTech"), College = c("SRM IST", "SRM IST", "SRM IST", "SRM IST", 
"SRM IST", "SRM IST"), City = c("Chennai", "Chennai", "Chennai", 
"Chennai", "Chennai", "Chennai"), State = c("TN", "TN", "TN", 
"TN", "TN", "TN"), Semester = c("Semester 1", "Semester 1", "Semester 1", 
"Semester 1", "Semester 1", "Semester 1"), Course = c("Course 1", 
"Course 1", "Course 1", "Course 1", "Course 1", "Course 1"), 
    CGPA = c(9.7, 5.4, 6, 5.4, 10, 7.3)), row.names = c(NA, 6L
), class = "data.frame")

除了总和之外，有没有办法显示课程的 CGPA 平均值？

标签： raverager-highchartersunburst-diagram