MapReduce--平均分,最高,低分以及及格率的计算
计算班级的平均分,以及个人的最高最低分,以及每个班级的及格率。
来先看一下我的数据。
时间 班级 姓名 科目 成绩
20180501 1708a1 li bishi 80
20180501 1708a1 li jishi 55
20180501 1708a1 li project 90
20180501 1708a1 li2 bishi 80
20180501 1708a1 li2 jishi 20
20180501 1708a1 li2 project 90
20180501 1708a1 li3 bishi 50
20180501 1708a1 li3 jishi 70
20180501 1708a1 li3 project 60
20180501 1708a1 zhangsan bishi 88
20180501 1708a1 zhangsan jishi 55
20180501 1708a1 zhangsan project 98
20180501 1708a1 lishi bishi 18
20180501 1708a1 lishi jishi 15
20180501 1708a1 lishi project 15
20180501 1708a1 wangwu bishi 88
20180501 1708a1 wangwu jishi 76
20180501 1708a1 wangwu project 70
20180501 1708a2 li1 bishi 80
20180501 1708a2 li1 jishi 71
20180501 1708a2 li1 project 96
20180501 1708a2 li2 bishi 80
20180501 1708a2 li2 jishi 26
20180501 1708a2 li2 project 90
20180501 1708a2 li3 bishi 80
20180501 1708a2 li3 jishi 55
20180501 1708a2 li3 project 90
20180501 1708a2 zhangliang bishi 81
20180501 1708a2 zhangliang jishi 55
20180501 1708a2 zhangliang project 98
20180501 1708a2 liuli bishi 70
20180501 1708a2 liuli jishi 95
20180501 1708a2 liuli project 75
20180501 1708a2 wangwu bishi 80
20180501 1708a2 wangwu jishi 76
20180501 1708a2 wangwu project 70
20180501 1708a2 zhangxi bishi 18
20180501 1708a2 zhangxi jishi 16
20180501 1708a2 zhangxi project 10
数据之间是空格。。。。
代码来了 -- 平均分,最高分,最低分
package com.huhu.day01;
import java.io.IOException;
import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.fs.Path;
import org.apache.had