如何在普通Scala中解析包含csv数据的大型文件并计算其中一列的平均值？

import scala.io.Source
import scala.util.Try

def calculateAverage(csvFilePath: String, columnIndex: Int): Option[Double] = {
  Try {
    val fileSource = Source.fromFile(csvFilePath)
    val lines = fileSource.getLines().toList
    fileSource.close()

    val columnValues = lines.flatMap(line => line.split(",")(columnIndex).toDoubleOption)
    if (columnValues.nonEmpty) {
      val sum = columnValues.sum
      val count = columnValues.length
      Some(sum / count)
    } else {
      None
    }
  }.getOrElse(None)
}

val csvFilePath = "path/to/your/csv/file.csv"
val columnIndex = 2 // 假设要计算第三列的平均值

val average = calculateAverage(csvFilePath, columnIndex)
average match {
  case Some(value) => println(s"The average of column $columnIndex is: $value")
  case None => println("Unable to calculate average")
}