var table,years,majors,employed;
var yearsdata = new Array();
var femaledata = new Array();
var maxlim,minlim;
var maxyr,minyr;

function preload() {
  table = loadTable('graduates.csv', 'csv', 'header');
}

function setup() {
  	//count the columns
  	createCanvas(1000,1000);
	majors = table.getColumn('Major');
	female = table.getColumn('Females');
	male = table.getColumn('Males');
  	years = table.getColumn('Year');
	employed = table.getColumn('Employed');
	var j =0;
	for(var i =0; i<table.getRowCount();i++) {
		if(majors[i]=="Computer Science and Math") {
			yearsdata[j] = years[i];
			femaledata[j] = female[i];
			j++;
  		}
	}

	maxlim =Math.max.apply(null, femaledata);
	maxyr = Math.max.apply(null,yearsdata);
	minyr = Math.min.apply(null,yearsdata);    

  	print(table.getRowCount() + ' total rows in table');
  	print(table.getColumnCount() + ' total columns in table');
  
}

function draw() {
	background(255);
	
	var interval = maxlim/10;
	for(var l =0;l<maxlim+interval;l=l+interval) {
		posy = map(l,0,maxlim+interval,750,10);
		fill(50);
		var cnum = Math.ceil(l)
		textAlign(LEFT);
		text(cnum,53,posy);
	}
	text(0,100,765);
	for(var m = minyr;m<maxyr+1;m++) {
		posx = map(m,minyr,maxyr+1,150,1000);
		fill(50);
		textAlign(CENTER);
		text(m,posx,765);
													
	}

	//print(femaledata.length);	
	for(var k = 0;k<yearsdata.length;k++) {
		x1 = Number(yearsdata[k]);
		posx1 =map(x1,minyr,maxyr+1,150,1000);
		y1 = Number(femaledata[k]);
		posy1 = map(y1,0,maxlim+interval,750,10);

		fill("ORANGE");
		ellipse(posx1,posy1,7,7);

		var sval = map(posy1,10,750,maxlim+interval,0);

		if(mouseX > posx1 && mouseY > posy1 && mouseX < posx1+7 && mouseY< posy1+7 ) {
			fill(50);
			text(sval, mouseX+10, mouseY-10); 
		}	
	
	}
	line(100,10,100,750);
	line(100,750,1000,750);
	fill(50)
	text("Year",500,780);
	text("CS Females count",50,325);
}