如何获取文件中组织成列的测试分数的平均值？

问：

该文件包含以下格式的数据：

Name|Test1|Test2|Test3|Test4|Test5|Test6|Test7|Test8|Test9|Test10   
John Smith|82|89|90|78|89|96|75|88|90|96
Jane Doe|90|92|93|90|89|84|97|91|87|91
Joseph Cruz|68|74|78|81|79|86|80|81|82|87
Suzanne Nguyen|79|83|85|89|81|79|86|92|87|88

我正在尝试找出如何获取每列的总和（例如，测试 1 = 82 + 92 + 68 + ...）以最终计算每个测试的平均分数。

这就是我解析文件并进行其他计算的方式：

public class TestAverages
{
  private static int[] grades;
  private static int[] testTotal;
  private static int N;
  private static double classTotal;
  
  public static void main(String[] args) throws FileNotFoundException
  {
    File input = new File("TestData.txt");
    Scanner in = new Scanner(input);
    parseFile(in);
    
  }
  public static void parseFile(Scanner in) throws FileNotFoundException
  {
    TestAverages t = new TestAverages();
    in.nextLine(); //skips the first line of text in file (labels)
    double classAvg =0.0;
    
    while(in.hasNextLine())
    {
      String line = in.nextLine();
      String[] data = line.split("\\|");
      String name = data[0];
      
      grades = new int[data.length - 1];
      N = grades.length;
      for(int i = 0; i < N; i++)
      {
        grades[i] = Integer.parseInt(data[i + 1]);

      }
      
      System.out.println(name);
      System.out.println("Student Average: " + t.getStudentAvg(grades) + "%\n");
      classAvg = t.getClassAvg(grades);
     
      System.out.println("Test Average: " + t.getTestAvg(grades) + "%\n");
    }
    System.out.printf("\nClass Average: %.2f%%\n", classAvg );
  }
  
  
  public double getStudentAvg(int[] grades)
  {
    double total = 0.0;
    double avg = 0.0;
    int N = grades.length;
    
    for(int i = 0; i < N; i++){
      total += grades[i];}
    
    avg = total / N;
    
    return avg;
  }
  
  
  public double getClassAvg(int[] grades)
  {
    double classTotal = getStudentAvg(grades) / N;
    double classAvg =0.0;
    
    classTotal += classTotal;
    classAvg = classTotal;
    
    return classTotal;
  }
}

如果不符合标准，请原谅我的格式。

我目前的主要问题是如何提取每个学生每次测试的分数并将所有内容相加。