Project 2

Answer as file

I have used

school-performance .csv

CREATE DATABASE alumini

CREATE TABLE if not exists alumini.performance (DBN varchar(20),Quality_Review_Year year,Quality_Review_Score varchar(255),
Progress_Rpt_10_11 char(10),Student_Progress_10_11 char(10),Student_Perf_10_11 char(10),Envi_10_11 char(10),
College_Ready_10_11 varchar(25),graduation_2010_11 varchar(25),college_enroll_2010_11 varchar(25),
Progress_Rpt_11_12 char(10),Student_Progress_11_12 char(10),
Student_Perf_11_12 char(10),Envi_11_12 char(10),College_Ready_11_12 char(10),graduation_2011_12 varchar(20),
college_enroll_2011_12 varchar(20));


Import above csv file 


after importing data in table

Execute my python file - Project 2 





Change this to your user and password where you have created the  database