CafeConVega · March 21, 2016 19:03
diff --git a/co2_emissions.csv b/co2_emissions.csv
diff --git a/deaths_04yearsold_excerpt.csv b/deaths_04yearsold_excerpt.csv
diff --git a/deaths_04yearsold_excerpt_2013.csv b/deaths_04yearsold_excerpt_2013.csv
diff --git a/index.html b/index.html
 <!DOCTYPE html>

 <meta charset="utf-8">
 <body>

  <h2>Look in the console.</h2>

 <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.6/d3.min.js"></script>
 <script>

 d3.csv("deaths_04yearsold_excerpt.csv", function(error, data) {

  if (error) {
    console.log(error);
 }

 console.log(data);

    
 // var illnesses = d3.keys(data[0]).filter(function(key) { if (key !== "Country"||key !== "Year") 
 //     return key; }); // TODO: how do you get all the keys that are not country or year? - done with slice below
    
 var illnesses = d3.keys(data[0]).slice(2, 11);
    
 console.log("keys", illnesses);

  data.forEach(function(d) {
      var sum = 0;
        illnesses.forEach(function (y) {
            d[y] = +d[y];
            if (y) {
               sum = sum +d[y];
            }
         });//end illnesses foreach
      
      // TODO: how would you use the illnesses list to get the total for each row's illnesses? use a forEach.-done
      d.total = sum;
    });

 console.log("totals", data);

 var countryNames = data.map(function(d) { return d.Country; })//TODO: // How would you use a map to get the country names out of the original data file? -done

 countryNames.sort(function(a, b) {return d3.ascending(a, b);});//TODO: sort them alphabetically) -done
    
 console.log(countryNames);

 var dateFormat = d3.time.format("Year %Y");
 var outputFormat = d3.time.format("%Y");

 var nestByCountry = d3.nest()
  .key(function(d) {return d.Country;})
  .sortKeys(d3.ascending)
  .entries(data);//TODO: what goes in here?); - done

 console.log("nest By country", nestByCountry[0]);

 var nestByYear = d3.nest()
  .key(function(d) {
    return outputFormat(dateFormat.parse(d.Year));})
  .sortKeys(function(a,b) { return outputFormat.parse(a) - outputFormat.parse(b)
    console.log(a, b);
    // TODO: How would you sort these?  think about using your date formats, and check what a and b are. -done
  })
  .entries(data);
    
  console.log("nest By Year", nestByYear[0]);

  var years = nestByYear.map(function(d) {return d.key;});// TODO: use a map function on the nestByYear to get the years as strings in an array. -done

  console.log(years);

  var maxMeaslesFor2012 = d3.max(nestByYear[12].values.map(function(d) {return d.Measles;}));
      //TODO: find the max measles in 2012 using the nestByYear results, using maps, filters, d3.max, d3.keys, d3.values, etc.  There are several ways. -done

  console.log("Measles Max 2012", maxMeaslesFor2012);

  var nestByCountryYear = d3.nest()
  .key(function(d) { return d.Country; })
  .sortKeys(d3.ascending)
  .key(function(d) {
    return outputFormat(dateFormat.parse(d.Year));})
  .sortKeys(function(a,b) { return outputFormat.parse(a) - outputFormat.parse(b)
  })
  // TODO: nest by country, then by year. - done
    .entries(data);

  console.log("by country then year", nestByCountryYear[0]);


  d3.csv("co2_emissions.csv", do_stuff);  // fill in do_stuff below:

 }); // end d3.csv on illnesses


 function do_stuff(error, data) {
 
    var years = d3.keys(data[0]).slice(0, 50); // write some code to get an array of all the years from the columns in the data set. - done
    console.log("co2 data",data)
 //    console.log("keys", years);

  var countries = data.map(function(d) {return d.countryName;});// write some code to get all the country names (consider map). - done
    
 //    console.log("country names",countries);

    // what is another way to write data[0].countryName? - done

  console.log("First country name",countries[0]); // fill it in here) -done

  // how do you get the last object in the data array? - done
    
  console.log("last object in array",data[data.length-1]); // fill it in here) -done

  var totals = [];
  
  data.forEach(function(d) {
      var sum = 0;
      var yearsum = 0;
      
        years.forEach(function (y) {
            d[y] = +d[y];
            
            if (y) {
               sum = sum +d[y];
            }
            
         });//end years foreach
      
      d.total = sum;
      
       totals.push({
           country: d.countryName, 
           total: d.total}); 
      
    }); //end data foreach
        
    // write a loop to calculate the total for each country across all the years.
    // make an object that has { country: countryName, total: totals} for each country and add it to the array totals. - done

    console.log(totals.length, totals[0], totals[0].country, totals[0].total);
    
    console.log("percent of total Algeria 1961", percentOfTotal("1961", "Algeria"));

  // TODO: Write a JS function that would calculate what percentage of the total country's year emissions are -- e.g., if Algeria's 1961 value is 6065.218, what percent of the total is that? - done
    
    function percentOfTotal(year, country) {
        var numerator = data[countries.indexOf(country)][year];
        var denominator = totals[countries.indexOf(country)]["total"];
        return numerator/denominator;
    }

  // Extra credit (5): for each country's data, calculate the percent of total emissions that each year is responsible for, using your function. Save this in an object along with the original value. console.log it too.

 } // end of do_stuff

    
    

 </script>
 </body>
Country	Year	Meningitis_encephalitis	Respiratory_infections	Sepsis	Pertussis	Malaria	Measles	HIV_Aids	Diarrhoeal_diseases	Asphyxia_trauma
Angola	Year 2013	5461	26392	7199	897	19405	627	1778	22465	14245
Angola	Year 2012	5747	26910	7149	893	19692	1278	1769	23655	14150
Angola	Year 2000	9282	25989	4172	931	21138	1103	1179	27209	9800
Angola	Year 2001	9452	26463	4784	918	21232	3889	1276	27064	9715
Angola	Year 2011	6107	27282	7044	911	21331	573	1704	24567	13909
Angola	Year 2002	9628	27141	5269	931	21793	5054	1373	26969	10068
Angola	Year 2006	10465	30754	6064	1047	22022	602	1590	27001	12620
Angola	Year 2003	9840	28190	5219	964	22530	1786	1466	27015	11186
Angola	Year 2005	10242	29865	5742	1014	23066	297	1601	26962	12292
Angola	Year 2004	9987	28764	5685	976	23161	24	1545	26830	11386
Angola	Year 2007	6681	27597	6914	943	23597	333	1594	28242	12913
Angola	Year 2010	5899	26780	7363	906	23827	338	1629	25156	13731
Angola	Year 2008	6658	27658	7095	935	24441	328	1605	27199	13333
Angola	Year 2009	6851	27898	7453	973	24858	976	1610	25887	13953
Congo	Year 2013	9101	49598	16965	3102	47519	15453	4487	33730	32994
Congo	Year 2012	9464	50424	16477	3049	48443	15191	4411	35679	32653
Congo	Year 2011	9517	50487	15822	2990	50175	31815	4673	37069	33651
Congo	Year 2010	10559	51027	17331	3123	51128	5082	4837	37904	31325
Congo	Year 2009	10101	50916	18086	2936	52037	5166	4985	40063	32521
Congo	Year 2008	14461	54789	16769	2996	55752	5957	5154	38179	31857
Congo	Year 2007	14036	52394	16399	2923	65794	11342	5310	37671	31236
Congo	Year 2000	14917	49542	10926	2951	69177	39600	5135	45561	26571
Congo	Year 2006	14259	52196	15473	3007	69414	17086	5518	38939	31130
Congo	Year 2005	14634	52396	15521	3005	71000	39181	5597	40592	30835
Congo	Year 2001	15393	51350	10258	3052	71367	38386	5305	46001	27774
Congo	Year 2004	15031	52626	15097	3009	72224	54739	5601	42374	30474
Congo	Year 2002	15578	52583	12961	3066	72603	51468	5454	45553	29659
Congo	Year 2003	15416	52777	14298	3091	72874	35548	5551	44223	29881
Zambia	Year 2013	1082	7550	3230	659	8328	564	3044	4563	6251
Zambia	Year 2012	1110	7537	3131	632	8334	736	2921	4729	6037
Zambia	Year 2011	1086	7223	3124	597	9155	1740	4776	4773	5855
Zambia	Year 2010	1179	7590	3177	569	7969	2223	6335	5317	5771
Zambia	Year 2009	1170	7760	3061	529	7349	146	6844	5850	5646
Zambia	Year 2008	1237	7684	2966	530	8024	73	7940	5929	5484
Zambia	Year 2007	1315	7666	2908	534	8616	248	8911	6059	5360
Zambia	Year 2006	1339	7644	2926	522	9472	224	9808	6301	5335
Zambia	Year 2005	1358	7593	2968	510	11000	102	10381	6516	5375
Zambia	Year 2004	1398	7619	3019	496	12630	6	10928	6833	5414
Zambia	Year 2003	2381	8996	3089	488	12574	716	11099	7096	5505
Zambia	Year 2002	2610	9476	3159	478	13239	2911	11104	7852	5609
Zambia	Year 2001	2811	9853	3170	466	13914	2129	11056	8541	5759
Zambia	Year 2000	2923	9952	3042	455	14402	3616	10944	9000	5739
Namibia	Year 2013	42	428	208	69	1	114	197	217	351
Namibia	Year 2012	45	443	204	69	1	68	196	230	353
Namibia	Year 2011	49	461	200	69	5	83	284	249	351
Namibia	Year 2010	52	472	201	67	3	106	442	268	357
Namibia	Year 2009	81	538	199	66	7	149	608	260	362
Namibia	Year 2008	85	544	203	65	16	40	769	275	363
Namibia	Year 2007	89	549	209	65	23	39	918	290	359
Namibia	Year 2006	88	531	207	62	124	35	1082	291	373
Namibia	Year 2005	94	544	212	64	111	27	1324	315	370
Namibia	Year 2004	92	519	213	61	219	17	1508	311	376
Namibia	Year 2003	100	559	214	67	112	68	1494	347	388
Namibia	Year 2002	101	568	214	66	123	79	1431	359	415
Namibia	Year 2001	96	550	216	63	222	19	1334	350	448
Namibia	Year 2000	99	569	215	65	145	24	1206	373	435
Botswana	Year 2013	24	282	181	8	1	36	124	139	296
Botswana	Year 2012	26	297	185	9	1	25	126	152	304
Botswana	Year 2011	27	306	195	10	1	28	209	163	321
Botswana	Year 2010	48	361	199	10	5	42	242	159	326
Botswana	Year 2009	50	366	204	10	6	29	340	168	334
Botswana	Year 2008	52	366	197	8	5	16	418	176	328
Botswana	Year 2007	52	366	193	8	3	13	430	182	323
Botswana	Year 2006	52	361	185	8	13	8	496	185	313
Botswana	Year 2005	56	364	174	9	3	24	736	198	301
Botswana	Year 2004	61	367	163	8	17	27	1181	215	292
Botswana	Year 2003	67	372	154	9	10	34	1680	236	288
Botswana	Year 2002	67	363	152	9	10	43	1947	239	290
Botswana	Year 2001	63	343	150	8	30	84	2049	229	290
Botswana	Year 2000	56	314	152	8	60	366	2051	210	292
Mozambique	Year 2013	1673	11669	5632	1061	14685	0	5468	7000	9272
Mozambique	Year 2012	1801	12092	5575	1040	15203	214	5361	7538	9322
Mozambique	Year 2011	1887	12187	5663	1024	17293	867	7440	7963	9474
Mozambique	Year 2010	1943	12123	5766	1023	19800	1504	8308	8189	9648
Mozambique	Year 2009	2045	12446	5958	1019	20929	157	8550	8747	9932
Mozambique	Year 2008	3227	14399	6172	1021	21071	500	9468	9063	10236
Mozambique	Year 2007	3357	14572	6384	1021	23763	424	10668	9546	10603
Mozambique	Year 2006	3546	14909	6570	1009	26032	115	12097	10183	10973
Mozambique	Year 2005	3719	15232	6594	990	27154	8257	11671	10824	11146
Mozambique	Year 2004	3945	15612	6054	959	27672	6166	10892	11622	10869
Mozambique	Year 2003	4135	15889	5910	918	28118	6054	9903	12334	10768
Mozambique	Year 2002	4284	15999	5840	907	28815	4754	8763	12955	10652
Mozambique	Year 2001	4464	16197	5829	879	29373	4730	7529	13667	10556
Mozambique	Year 2000	4742	16699	5929	853	30354	4841	6313	14683	10645
Tanzania	Year 2013	1376	14263	7448	1911	9272	259	5526	7087	12984
Tanzania	Year 2012	1459	14777	7536	1890	9657	134	5464	7692	13198
Tanzania	Year 2011	1589	15313	7691	1899	10166	346	6796	8334	13502
Tanzania	Year 2010	1637	15235	7730	1855	12427	336	9186	8727	13695
Tanzania	Year 2009	1704	14918	7939	1872	16927	520	11386	8734	14329
Tanzania	Year 2008	2865	17310	7781	1806	17518	802	12781	8863	14589
Tanzania	Year 2007	3233	18457	7943	1754	17589	1190	14335	10051	14918
Tanzania	Year 2006	3472	18899	8180	1642	20133	255	15601	10856	15311
Tanzania	Year 2005	3797	19662	8409	1592	22146	506	16352	11945	15639
Tanzania	Year 2004	4197	20635	8595	1511	24071	635	16988	13274	15977
Tanzania	Year 2003	4582	21445	8799	1477	27055	830	17325	14581	16251
Tanzania	Year 2002	5106	22701	8861	1470	29298	1258	17568	16352	16562
Tanzania	Year 2001	5697	24029	9112	1445	31408	2388	17686	18352	16595
Tanzania	Year 2000	6301	25386	9032	1450	33425	2980	17658	20467	16889
Kenya	Year 2013	2348	18576	6843	1619	4637	238	4656	10515	14726
Kenya	Year 2012	2469	19081	7072	1606	4770	312	4617	11247	14799
Kenya	Year 2011	2505	19387	7424	1556	5118	341	5004	12063	14836
Kenya	Year 2010	2738	20007	7900	1577	5272	189	6642	12850	14894
Kenya	Year 2009	2842	20366	7978	1561	5422	476	8202	13650	15333
Kenya	Year 2008	2931	20621	7980	1549	5642	490	9386	14420	15461
Kenya	Year 2007	3160	21136	7797	1549	5564	569	11512	15301	15494
Kenya	Year 2006	3263	21210	7801	1523	6027	545	13044	15932	15399
Kenya	Year 2005	3368	21072	7543	1523	7373	414	14589	16228	15518
Kenya	Year 2004	3451	20880	7537	1493	7963	197	15650	16555	15165
Kenya	Year 2003	3494	20776	7443	1444	7903	10	16193	17077	14893
Kenya	Year 2002	3265	20197	7451	1348	7893	773	16505	17668	14521
Kenya	Year 2001	5017	22273	7248	1332	7115	1300	16648	16523	13733
Kenya	Year 2000	4984	21867	6959	1272	7010	1618	16597	16757	13405
Gabon	Year 2013	37	354	213	58	540	14	64	183	355
Gabon	Year 2012	38	354	208	57	548	36	63	193	344
Gabon	Year 2011	40	358	208	58	565	34	105	199	350
Gabon	Year 2010	46	380	209	59	530	31	140	219	351
Gabon	Year 2009	71	449	212	55	423	28	168	235	361
Gabon	Year 2008	75	458	212	52	399	12	200	249	365
Gabon	Year 2007	74	445	205	51	462	40	239	252	361
Gabon	Year 2006	72	419	195	58	545	34	265	247	337
Gabon	Year 2005	69	398	189	57	611	9	274	242	331
Gabon	Year 2004	68	391	187	56	635	100	278	245	331
Gabon	Year 2003	69	388	180	55	642	204	275	252	324
Gabon	Year 2002	70	387	193	55	643	131	265	259	333
Gabon	Year 2001	70	385	162	53	640	248	249	265	312
Gabon	Year 2000	70	385	156	51	642	111	229	273	309
Cameroon	Year 2013	2067	12718	4212	843	9261	218	2142	8497	8361
Cameroon	Year 2012	2195	13028	4176	831	9416	377	2112	8960	8343
Cameroon	Year 2011	2206	12691	3974	832	11965	293	2431	8986	8131
Cameroon	Year 2010	2104	12104	4289	814	15034	123	2868	8819	8259
Cameroon	Year 2009	2276	12536	4268	819	15095	286	3455	9448	8314
Cameroon	Year 2008	3400	14505	4361	798	13564	162	3771	9569	7998
Cameroon	Year 2007	3520	14666	4303	798	14171	227	4020	10069	8020
Cameroon	Year 2006	3569	14514	4362	800	15427	409	4161	10373	7774
Cameroon	Year 2005	3599	14337	4206	798	16822	519	4260	10638	7724
Cameroon	Year 2004	3682	14341	4042	806	17712	362	4259	11072	7663
Cameroon	Year 2003	3820	14510	3953	797	18017	150	4230	11660	7660
Cameroon	Year 2002	3977	14698	3716	798	18374	222	4107	12324	7558
Cameroon	Year 2001	4125	14835	3326	791	18601	7031	3888	12977	7296
Cameroon	Year 2000	4246	14972	3326	781	18817	4663	3579	13588	7322
Central African Republic	Year 2013	755	3175	911	197	5459	0	664	2002	2360
Central African Republic	Year 2012	699	3045	1049	192	5581	195	647	2090	2147
Central African Republic	Year 2011	718	3087	1129	187	5683	802	776	2184	2198
Central African Republic	Year 2010	742	3118	1153	185	5743	135	921	2270	2207
Central African Republic	Year 2009	760	3136	1160	185	5847	34	1052	2332	2254
Central African Republic	Year 2008	921	3348	1156	183	5683	175	1187	2373	2241
Central African Republic	Year 2007	943	3339	939	182	5666	114	1316	2474	2081
Central African Republic	Year 2006	949	3331	921	181	5718	64	1449	2541	2066
Central African Republic	Year 2005	935	3276	894	180	5907	785	1570	2562	2056
Central African Republic	Year 2004	922	3216	774	181	6046	1476	1631	2585	1975
Central African Republic	Year 2003	917	3193	743	186	6082	955	1657	2636	1952
Central African Republic	Year 2002	914	3177	732	187	6073	1314	1645	2692	1947
Central African Republic	Year 2001	905	3143	752	188	6024	2186	1605	2735	1949
Central African Republic	Year 2000	891	3100	747	186	5964	2491	1539	2765	1954
Uganda	Year 2013	2075	15454	6403	1735	12935	550	7382	8383	10680
Uganda	Year 2012	2201	15911	6385	1695	13356	500	7213	9024	10702
Uganda	Year 2011	2313	16212	6586	1637	14344	355	9470	9790	10817
Uganda	Year 2010	2486	16733	6466	1624	16216	172	9853	10518	11395
Uganda	Year 2009	2631	17052	6774	1586	18461	742	9823	11189	11540
Uganda	Year 2008	2939	17783	6695	1614	20556	685	9841	12052	11725
Uganda	Year 2007	3141	18353	6889	1561	22631	612	9930	13148	12015
Uganda	Year 2006	3536	19216	6860	1587	24896	340	9694	14200	12253
Uganda	Year 2005	3782	19670	7180	1539	27691	105	9409	15309	12234
Uganda	Year 2004	4131	20409	7095	1513	29455	31	9427	16681	12362
Uganda	Year 2003	4853	21683	6946	1483	30235	10509	9690	17967	12341
Uganda	Year 2002	5510	22717	6863	1450	30682	14138	10098	19139	12400
Uganda	Year 2001	6447	23927	6539	1416	30414	9449	10631	19887	12238
Uganda	Year 2000	6614	23825	6389	1384	30264	12943	11319	20691	11976
Nigeria	Year 2013	24987	120199	41218	9539	166102	4625	24647	76938	84188
Nigeria	Year 2012	29969	127745	39068	9281	164702	4660	23981	79453	81893
Nigeria	Year 2011	31982	131691	34962	8885	166599	16306	25194	82867	88220
Nigeria	Year 2010	32045	129541	39813	8367	180694	8134	26927	83863	88298
Nigeria	Year 2009	31193	123705	41418	7927	202337	1653	27451	82688	84847
Nigeria	Year 2008	30885	120767	38510	8124	222263	10822	28321	83354	85843
Nigeria	Year 2007	31384	120575	36049	8304	232256	5511	28767	86285	86422
Nigeria	Year 2006	31989	120416	35637	8215	238509	17257	29095	89331	85400
Nigeria	Year 2005	32968	121378	34611	8117	241102	83182	28862	93514	84467
Nigeria	Year 2004	34020	122591	33363	8001	243207	39144	27706	98038	83609
Nigeria	Year 2003	35105	123796	32448	7869	244883	107428	26139	102796	82397
Nigeria	Year 2002	36028	124582	31007	7728	244708	45910	24259	107088	81806
Nigeria	Year 2001	36825	124719	30455	7453	243805	125379	22166	110944	80083
Nigeria	Year 2000	37609	124790	29564	7222	243379	159344	19988	114935	78077
Malawi	Year 2013	640	5465	2632	601	5927	314	5056	3003	4320
Malawi	Year 2012	661	5719	2760	613	6322	374	5157	3335	4473
Malawi	Year 2011	747	6158	2910	623	6213	271	6841	3823	4759
Malawi	Year 2010	838	6457	3009	629	6812	1317	7925	4181	4964
Malawi	Year 2009	876	6514	3060	614	8260	94	8438	4411	5121
Malawi	Year 2008	986	6883	3133	594	8384	418	9280	4920	5207
Malawi	Year 2007	1134	7324	3109	576	8314	299	10158	5512	5281
Malawi	Year 2006	1123	7409	3103	528	9485	172	10698	6067	5206
Malawi	Year 2005	1272	7696	3078	519	10536	859	11024	6581	5113
Malawi	Year 2004	1469	8251	3091	510	11027	745	11110	7414	5145
Malawi	Year 2003	1685	8787	3099	504	12357	602	11081	8239	5271
Malawi	Year 2002	2095	9455	2970	524	14295	438	10992	8937	5365
Malawi	Year 2001	3209	10961	3288	465	15047	244	10881	9507	5406
Malawi	Year 2000	3574	11694	3185	477	16288	114	10735	10694	5548
Ethiopia	Year 2013	4516	34565	15241	3762	5748	4541	4588	18534	29664
Ethiopia	Year 2012	4961	36242	15540	3709	6008	4085	4524	20189	29541
Ethiopia	Year 2011	5396	37836	17627	3620	6137	1837	6060	21677	30864
Ethiopia	Year 2010	5950	39843	17790	3641	6946	7260	7330	23771	31969
Ethiopia	Year 2009	6821	42914	18251	3741	6549	13815	8598	26582	33169
Ethiopia	Year 2008	7847	46382	18403	3739	6895	9038	9970	30122	34272
Ethiopia	Year 2007	8934	49596	18903	3893	10061	3629	11554	33606	35566
Ethiopia	Year 2006	11819	56051	19234	3950	13669	19031	13000	36018	36829
Ethiopia	Year 2005	13344	60115	19540	4003	16518	13878	14212	40991	38021
Ethiopia	Year 2004	15051	64609	19560	4088	17975	17861	15024	46348	39607
Ethiopia	Year 2003	16791	68857	19294	4254	19253	20414	15543	52028	40414
Ethiopia	Year 2002	18437	72689	19089	4195	20382	17334	15743	57589	41243
Ethiopia	Year 2001	19810	75475	18264	4061	21246	7351	15616	62503	41441
Ethiopia	Year 2000	20710	76786	17273	4062	21660	20634	15126	66157	41262
Rwanda	Year 2013	375	3850	1597	417	949	131	329	2028	2873
Rwanda	Year 2012	423	4197	1725	435	1033	126	343	2317	3114
Rwanda	Year 2011	481	4544	1838	444	982	103	474	2639	3321
Rwanda	Year 2010	528	4748	1931	434	929	60	702	2913	3488
Rwanda	Year 2009	569	4856	1915	402	1073	123	786	3161	3497
Rwanda	Year 2008	598	4812	1761	350	1195	99	924	3335	3401
Rwanda	Year 2007	638	4763	1545	295	1229	47	1166	3555	3139
Rwanda	Year 2006	711	4940	1481	256	1433	165	1455	4022	2898
Rwanda	Year 2005	920	5756	1461	254	1978	98	1711	5014	3077
Rwanda	Year 2004	1264	7116	1722	287	2563	22	2015	6536	3726
Rwanda	Year 2003	1669	9157	2300	341	3383	394	2291	9130	4863
Rwanda	Year 2002	2421	11960	2920	422	4307	609	2411	12386	6326
Rwanda	Year 2001	4785	15817	3210	493	4576	461	2512	14008	7314
Rwanda	Year 2000	5196	16468	3689	477	4725	588	2570	15254	7682
Burundi	Year 2013	862	6483	2474	420	1790	210	462	4094	4173
Burundi	Year 2012	897	6579	2505	411	1817	104	453	4331	4149
Burundi	Year 2011	928	6647	2398	400	1898	79	515	4554	4234
Burundi	Year 2010	945	6637	2538	389	2127	79	593	4708	4292
Burundi	Year 2009	976	6604	2569	378	2391	149	690	4852	4226
Burundi	Year 2008	1017	6575	2402	365	2608	120	762	5045	4061
Burundi	Year 2007	993	6499	2346	340	2861	53	845	5295	4091
Burundi	Year 2006	1065	6484	2183	333	3114	180	925	5424	3923
Burundi	Year 2005	1141	6571	2070	326	3265	129	1045	5656	3993
Burundi	Year 2004	1220	6641	2053	317	3357	95	1192	5935	3844
Burundi	Year 2003	1940	7489	1998	306	3155	18	1324	5733	3721
Burundi	Year 2002	2022	7575	1930	299	3213	197	1446	6062	3635
Burundi	Year 2001	2113	7690	1799	292	3281	2415	1558	6429	3514
Burundi	Year 2000	2201	7819	1730	290	3355	2126	1651	6806	3467
	<!DOCTYPE html>

	<meta charset="utf-8">
	<body>

	<h2>Look in the console.</h2>

	<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.6/d3.min.js"></script>
	<script>

	d3.csv("deaths_04yearsold_excerpt.csv", function(error, data) {

	if (error) {
	console.log(error);
	}

	console.log(data);


	// var illnesses = d3.keys(data[0]).filter(function(key) { if (key !== "Country"\|\|key !== "Year")
	// return key; }); // TODO: how do you get all the keys that are not country or year? - done with slice below

	var illnesses = d3.keys(data[0]).slice(2, 11);

	console.log("keys", illnesses);

	data.forEach(function(d) {
	var sum = 0;
	illnesses.forEach(function (y) {
	d[y] = +d[y];
	if (y) {
	sum = sum +d[y];
	}
	});//end illnesses foreach

	// TODO: how would you use the illnesses list to get the total for each row's illnesses? use a forEach.-done
	d.total = sum;
	});

	console.log("totals", data);

	var countryNames = data.map(function(d) { return d.Country; })//TODO: // How would you use a map to get the country names out of the original data file? -done

	countryNames.sort(function(a, b) {return d3.ascending(a, b);});//TODO: sort them alphabetically) -done

	console.log(countryNames);

	var dateFormat = d3.time.format("Year %Y");
	var outputFormat = d3.time.format("%Y");

	var nestByCountry = d3.nest()
	.key(function(d) {return d.Country;})
	.sortKeys(d3.ascending)
	.entries(data);//TODO: what goes in here?); - done

	console.log("nest By country", nestByCountry[0]);

	var nestByYear = d3.nest()
	.key(function(d) {
	return outputFormat(dateFormat.parse(d.Year));})
	.sortKeys(function(a,b) { return outputFormat.parse(a) - outputFormat.parse(b)
	console.log(a, b);
	// TODO: How would you sort these? think about using your date formats, and check what a and b are. -done
	})
	.entries(data);

	console.log("nest By Year", nestByYear[0]);

	var years = nestByYear.map(function(d) {return d.key;});// TODO: use a map function on the nestByYear to get the years as strings in an array. -done

	console.log(years);

	var maxMeaslesFor2012 = d3.max(nestByYear[12].values.map(function(d) {return d.Measles;}));
	//TODO: find the max measles in 2012 using the nestByYear results, using maps, filters, d3.max, d3.keys, d3.values, etc. There are several ways. -done

	console.log("Measles Max 2012", maxMeaslesFor2012);

	var nestByCountryYear = d3.nest()
	.key(function(d) { return d.Country; })
	.sortKeys(d3.ascending)
	.key(function(d) {
	return outputFormat(dateFormat.parse(d.Year));})
	.sortKeys(function(a,b) { return outputFormat.parse(a) - outputFormat.parse(b)
	})
	// TODO: nest by country, then by year. - done
	.entries(data);

	console.log("by country then year", nestByCountryYear[0]);


	d3.csv("co2_emissions.csv", do_stuff); // fill in do_stuff below:

	}); // end d3.csv on illnesses


	function do_stuff(error, data) {

	var years = d3.keys(data[0]).slice(0, 50); // write some code to get an array of all the years from the columns in the data set. - done
	console.log("co2 data",data)
	// console.log("keys", years);

	var countries = data.map(function(d) {return d.countryName;});// write some code to get all the country names (consider map). - done

	// console.log("country names",countries);

	// what is another way to write data[0].countryName? - done

	console.log("First country name",countries[0]); // fill it in here) -done

	// how do you get the last object in the data array? - done

	console.log("last object in array",data[data.length-1]); // fill it in here) -done

	var totals = [];

	data.forEach(function(d) {
	var sum = 0;
	var yearsum = 0;

	years.forEach(function (y) {
	d[y] = +d[y];

	if (y) {
	sum = sum +d[y];
	}

	});//end years foreach

	d.total = sum;

	totals.push({
	country: d.countryName,
	total: d.total});

	}); //end data foreach

	// write a loop to calculate the total for each country across all the years.
	// make an object that has { country: countryName, total: totals} for each country and add it to the array totals. - done

	console.log(totals.length, totals[0], totals[0].country, totals[0].total);

	console.log("percent of total Algeria 1961", percentOfTotal("1961", "Algeria"));

	// TODO: Write a JS function that would calculate what percentage of the total country's year emissions are -- e.g., if Algeria's 1961 value is 6065.218, what percent of the total is that? - done

	function percentOfTotal(year, country) {
	var numerator = data[countries.indexOf(country)][year];
	var denominator = totals[countries.indexOf(country)]["total"];
	return numerator/denominator;
	}

	// Extra credit (5): for each country's data, calculate the percent of total emissions that each year is responsible for, using your function. Save this in an object along with the original value. console.log it too.

	} // end of do_stuff




	</script>
	</body>