从文本文件temperature.txt中获得某地的华氏平均气温数据,计算每个季度的平均温度,以及全年的平均温度。
解答:
A | |
1 |
![]() =file@s("temperature.txt").import@t()
|
2 |
![]() =A1.derive(int((Month+2)/3):Quarter)
|
3 |
![]() =A2.group(Quarter)
|
4 |
![]() =A3.new(Quarter,round(~.avg(Temperature),2):Average)
|
5 |
![]() =round(A1.avg(Temperature),2)
|
6 |
![]() >A4.insert(0,"annual",A5)
|
A4中运算结果如下: