[置顶] 【机器学习PAI实践八】用机器学习算法评估学生考试成绩

gshengod 分享于

（本文数据为实验用例）

三、离线训练

1.SQL脚本-数据预处理

select (case sex when 'F' then 1 else 0 end) as sex, (case address when 'U' then 1 else 0 end) as address, (case famsize when 'LE3' then 1 else 0 end) as famsize, (case Pstatus when 'T' then 1 else 0 end) as Pstatus, Medu, Fedu, (case Mjob when 'teacher' then 1 else 0 end) as Mjob, (case Fjob when 'teacher' then 1 else 0 end) as Fjob, (case guardian when 'mother' then 0 when 'father' then 1 else 2 end) as guardian, traveltime, studytime, failures, (case schoolsup when 'yes' then 1 else 0 end) as schoolsup, (case fumsup when 'yes' then 1 else 0 end) as fumsup, (case paid when 'yes' then 1 else 0 end) as paid, (case activities when 'yes' then 1 else 0 end) as activities, (case higher when 'yes' then 1 else 0 end) as higher, (case internet when 'yes' then 1 else 0 end) as internet, famrel, freetime, goout, Dalc, Walc, health, absences, (case when G3>14 then 1 else 0 end) as finalScore from \${t1};

四、其它

（本文数据为实验用例） 一、背景 母亲是老师反而会对孩子的学习成绩造成不利影响？能上网的家庭，孩子通常能取得较好的成绩？影响孩子成绩的最大因素居然是母亲的学历？本文通过机器挖掘算法和

×
• 登录
• 注册

×