Skip to content

Commit

Permalink
Merge branch 'main' of https://github.com/BingQuanChua/SASPICIOUS
Browse files Browse the repository at this point in the history
  • Loading branch information
@LiewKuanYung
LiewKuanYung committed Feb 1, 2022
2 parents 4d4e27c + 912753d commit 9eb6d13
Show file tree
Hide file tree
Showing 8 changed files with 393,828 additions and 38 deletions.
639 changes: 601 additions & 38 deletions eda_Henry.ipynb
View file

Large diffs are not rendered by default.

169,829 changes: 169,829 additions & 0 deletions eda_Ryan_capital.ipynb
View file

Large diffs are not rendered by default.

223,286 changes: 223,286 additions & 0 deletions eda_Ryan_kt.ipynb
View file

Large diffs are not rendered by default.

28 changes: 28 additions & 0 deletions output/sector_by_world.csv
View file
Original file line number Diff line number Diff line change
@@ -0,0 +1,28 @@
Entity,Code,Year,"Agriculture (GHG Emissions, CAIT)","Land-Use Change and Forestry (GHG Emissions, CAIT)","Waste (GHG Emissions, CAIT)","Industry (GHG Emissions, CAIT)","Manufacturing/Construction energy (GHG Emissions, CAIT)","Transport (GHG Emissions, CAIT)","Electricity & Heat (GHG Emissions, CAIT)","Buildings (GHG Emissions, CAIT)","Fugitive from energy production (GHG Emissions, CAIT)","Other Fuel Combustion (GHG Emissions, CAIT)","Bunker Fuels (GHG Emissions, CAIT)"
World,OWID_WRL,1990,5029150000,4196640000,1364400000,1011040000,3953600000,4595400000,8604100000,2604700000,2253380000,1354930000,630600000
World,OWID_WRL,1991,5013560000,4196650000,1395180000,1015010000,3869500000,4638700000,8741400000,2630400000,2261860000,1363190000,638100000
World,OWID_WRL,1992,4991320000,4196620000,1418280000,1031600000,3734800000,4745900000,8904000000,2523800000,2165360000,1273960000,674900000
World,OWID_WRL,1993,4962590000,4196650000,1444390000,1045740000,3685100000,4786900000,8953400000,2582300000,2129690000,1292770000,667100000
World,OWID_WRL,1994,5000420000,4196660000,1470960000,1153320000,3704300000,4884300000,9051000000,2500300000,2063050000,1263400000,694300000
World,OWID_WRL,1995,5057440000,4196670000,1476510000,1226400000,3931000000,5017100000,9243900000,2575900000,2073700000,1213920000,718500000
World,OWID_WRL,1996,5050880000,3671010000,1478310000,1278710000,3821200000,5220200000,9600000000,2647000000,2106340000,1151390000,740200000
World,OWID_WRL,1997,4980670000,4637860000,1474360000,1320850000,3846600000,5298900000,9867000000,2624800000,2091650000,1199710000,766700000
World,OWID_WRL,1998,5034790000,4071090000,1466280000,1323980000,3845200000,5419100000,10091400000,2471700000,2076100000,1177090000,791100000
World,OWID_WRL,1999,5089100000,3697770000,1464470000,1330340000,3692500000,5579000000,10137400000,2542800000,2089090000,1187710000,828500000
World,OWID_WRL,2000,5082240000,3513150000,1466760000,1389170000,3865400000,5756800000,10554200000,2534100000,2134250000,1124750000,854000000
World,OWID_WRL,2001,5149920000,3988260000,1452910000,1415160000,3887600000,5788200000,10814000000,2558800000,2179350000,1145760000,821600000
World,OWID_WRL,2002,5186940000,4958310000,1447970000,1480660000,3883900000,5927400000,10999000000,2554500000,2228840000,1157070000,860400000
World,OWID_WRL,2003,5177990000,4611360000,1443660000,1557020000,4066700000,6061400000,11622200000,2637300000,2319230000,1181720000,869900000
World,OWID_WRL,2004,5286640000,4934890000,1431880000,1656510000,4506200000,6338300000,11999700000,2678600000,2393240000,1226150000,948100000
World,OWID_WRL,2005,5323840000,4675410000,1422660000,1739830000,4922800000,6472700000,12389800000,2683500000,2481800000,1242290000,994200000
World,OWID_WRL,2006,5372790000,3905650000,1433850000,1870580000,5168400000,6619200000,12879200000,2647400000,2567020000,1259510000,1046600000
World,OWID_WRL,2007,5460190000,3406890000,1441860000,1997860000,5446300000,6826900000,13454900000,2640000000,2639990000,1269430000,1095500000
World,OWID_WRL,2008,5473290000,3369510000,1446930000,2044580000,5599200000,6835300000,13458300000,2706300000,2746400000,1272570000,1103400000
World,OWID_WRL,2009,5467330000,3691120000,1454290000,2095210000,5575900000,6701900000,13266000000,2656200000,2739150000,1289200000,1050800000
World,OWID_WRL,2010,5542990000,3341700000,1465130000,2230080000,6036200000,6987000000,14140300000,2706700000,2793840000,1308320000,1120300000
World,OWID_WRL,2011,5678140000,3400350000,1467310000,2379510000,6272200000,7091400000,14720500000,2655100000,2830660000,1307280000,1136700000
World,OWID_WRL,2012,5693470000,3466950000,1476630000,2458410000,6259700000,7161300000,15018900000,2607600000,2853290000,1352630000,1093200000
World,OWID_WRL,2013,5633180000,3366680000,1484040000,2563160000,6296500000,7357000000,15292500000,2713000000,2860380000,1395160000,1101600000
World,OWID_WRL,2014,5678150000,3576820000,1514260000,2678420000,6327500000,7478800000,15226500000,2667200000,2877380000,1415770000,1138900000
World,OWID_WRL,2015,5742440000,3912400000,1543590000,2689620000,6255100000,7697700000,15020500000,2680600000,2880050000,1432890000,1194000000
World,OWID_WRL,2016,5795510000,3217070000,1560850000,2771080000,6109300000,7866000000,15005300000,2720700000,2883170000,1429150000,1240100000
28 changes: 28 additions & 0 deletions output/sector_merge_china.csv
View file
Original file line number Diff line number Diff line change
@@ -0,0 +1,28 @@
Country Name,Year,Urban population (% of total population),Population growth (annual %),Methane emissions (kt of CO2 equivalent),CO2 intensity (kg per kg of oil equivalent energy use),Energy use (kg of oil equivalent per capita),Entity,Code,Agriculture,Land-Use Change and Forestry,Waste,Industry,Manufacturing/Construction energy,Transport,Buildings,Fugitive from energy production,Other Fuel Combustion,Bunker Fuels,Electricity & Heat
China,1990,26.442,1.467303211,730340.0,2.496159351,766.9953294,China,CHN,588430000.0,-318410000.0,194710000.0,94350000.0,745200000.0,94200000.0,384700000.0,156910000.0,236300000.0,5600000.0,725400000.0
China,1991,27.312,1.364434008,743070.0,2.714992962,736.8518014,China,CHN,598580000.0,-318410000.0,199460000.0,112600000.0,778800000.0,100700000.0,383300000.0,162830000.0,239060000.0,7300000.0,794300000.0
China,1992,28.2,1.225536228,751660.0,2.75799281,752.6286625,China,CHN,603320000.0,-318410000.0,204210000.0,135160000.0,807800000.0,111200000.0,360000000.0,168760000.0,232830000.0,11300000.0,877700000.0
China,1993,29.103,1.149619431,757560.0,2.846293049,788.1287236,China,CHN,590480000.0,-318410000.0,208960000.0,157020000.0,861500000.0,125800000.0,370400000.0,174680000.0,237600000.0,9900000.0,997700000.0
China,1994,30.024,1.130260632,773650.0,2.841380181,816.16289,China,CHN,610470000.0,-318410000.0,213710000.0,180080000.0,903400000.0,116400000.0,341300000.0,180600000.0,246260000.0,10900000.0,1082900000.0
China,1995,30.961,1.086509151,798450.0,2.953697109,866.8343743,China,CHN,669600000.0,-318410000.0,205550000.0,204110000.0,1070200000.0,127500000.0,365700000.0,194050000.0,242200000.0,11200000.0,1185700000.0
China,1996,31.916,1.048141514,823860.0,2.855147947,881.6537374,China,CHN,712510000.0,-320280000.0,197380000.0,219900000.0,968700000.0,170000000.0,313800000.0,207490000.0,180670000.0,12400000.0,1330300000.0
China,1997,32.883,1.023450024,791730.0,2.917630452,871.7563238,China,CHN,644660000.0,-320390000.0,189200000.0,237400000.0,961100000.0,146300000.0,352600000.0,220940000.0,229540000.0,10100000.0,1328100000.0
China,1998,33.867,0.959550406,813830.0,2.993571612,869.3586073,China,CHN,667140000.0,-320090000.0,181030000.0,253390000.0,1023800000.0,140500000.0,298700000.0,234380000.0,240510000.0,10600000.0,1409600000.0
China,1999,34.865,0.865851393,825690.0,2.861456423,878.5245355,China,CHN,687290000.0,-320300000.0,172860000.0,277780000.0,871500000.0,157600000.0,305300000.0,247830000.0,246580000.0,10800000.0,1432800000.0
China,2000,35.877,0.787956593,829610.0,2.94607047,898.9873131,China,CHN,675770000.0,-320040000.0,164690000.0,301370000.0,906400000.0,248700000.0,274100000.0,261270000.0,188650000.0,13800000.0,1575300000.0
China,2001,37.093,0.726380638,824170.0,2.9854598,928.8114337,China,CHN,664550000.0,-337710000.0,156220000.0,344630000.0,961300000.0,254500000.0,277800000.0,274720000.0,195080000.0,15600000.0,1661200000.0
China,2002,38.425,0.669999568,819890.0,3.020203061,984.8107146,China,CHN,671440000.0,-337770000.0,147740000.0,387290000.0,999500000.0,276700000.0,283600000.0,288160000.0,205810000.0,17400000.0,1840500000.0
China,2003,39.776,0.622860936,815910.0,3.062691392,1118.431773,China,CHN,660520000.0,-331320000.0,139270000.0,452750000.0,1138700000.0,313400000.0,308500000.0,301610000.0,223740000.0,17000000.0,2178700000.0
China,2004,41.144,0.593932815,829700.0,3.116235385,1268.132904,China,CHN,679290000.0,-334550000.0,130790000.0,504420000.0,1500200000.0,371200000.0,352600000.0,315050000.0,237160000.0,22700000.0,2376100000.0
China,2005,42.522,0.58812499,837670.0,3.202627207,1393.691324,China,CHN,687140000.0,-336720000.0,122320000.0,552880000.0,1934300000.0,397300000.0,365500000.0,328500000.0,252190000.0,26400000.0,2553300000.0
China,2006,43.868,0.558374367,883360.0,3.237935735,1515.173678,China,CHN,689250000.0,-393830000.0,128340000.0,632320000.0,2080900000.0,434800000.0,384100000.0,370740000.0,257640000.0,30700000.0,2899700000.0
China,2007,45.199,0.522271866,921560.0,3.252784275,1630.171029,China,CHN,680710000.0,-392450000.0,134370000.0,698160000.0,2271000000.0,468600000.0,398300000.0,412970000.0,258400000.0,34000000.0,3172500000.0
China,2008,46.539,0.512386932,973580.0,3.246815182,1672.90412,China,CHN,692800000.0,-386930000.0,140390000.0,730000000.0,2406400000.0,507100000.0,383200000.0,455210000.0,258750000.0,33300000.0,3210000000.0
China,2009,47.88,0.497381401,1018910.0,3.258679169,1778.433519,China,CHN,700730000.0,-391230000.0,146410000.0,808640000.0,2596100000.0,517100000.0,391600000.0,497440000.0,264300000.0,35900000.0,3458200000.0
China,2010,49.226,0.482959689,1063830.0,3.239419267,1954.722556,China,CHN,711250000.0,-391660000.0,152440000.0,885580000.0,2795400000.0,568800000.0,416400000.0,539680000.0,269050000.0,43500000.0,3841700000.0
China,2011,50.511,0.479150454,1106190.0,3.308332359,2086.486904,China,CHN,709960000.0,-309910000.0,158460000.0,975360000.0,2997500000.0,621900000.0,440700000.0,581910000.0,277120000.0,47000000.0,4328300000.0
China,2012,51.765,0.487231118,1151100.0,3.274925199,2155.164788,China,CHN,711820000.0,-310150000.0,164480000.0,1002330000.0,3029800000.0,686100000.0,457200000.0,624150000.0,285290000.0,47200000.0,4455400000.0
China,2013,53.013,0.493709634,1178020.0,3.306811614,2213.759327,China,CHN,714780000.0,-309850000.0,169550000.0,1058980000.0,3026800000.0,741100000.0,476600000.0,647720000.0,297460000.0,44700000.0,4747800000.0
China,2014,54.259,0.506311592,1206210.0,3.242644147,2236.729908,China,CHN,716930000.0,-307070000.0,174620000.0,1112430000.0,3026900000.0,770600000.0,487000000.0,671300000.0,298020000.0,44700000.0,4641500000.0
China,2015,55.5,0.508136747,1237520.0,1.956382066310752,1944.0352966184469,China,CHN,727460000.0,-309770000.0,179680000.0,1090680000.0,2976800000.0,827200000.0,510500000.0,694870000.0,300490000.0,53100000.0,4586200000.0
China,2016,56.736,0.541478512,1242150.0,1.9664394335700663,2038.733724982156,China,CHN,730600000.0,-309980000.0,185650000.0,1122480000.0,2842400000.0,843500000.0,525100000.0,693380000.0,299640000.0,57100000.0,4644100000.0
28 changes: 28 additions & 0 deletions output/sector_merge_india.csv
View file
Original file line number Diff line number Diff line change
@@ -0,0 +1,28 @@
Entity,Code,Year,Agriculture ,Land-Use Change and Forestry ,Waste ,Industry ,Manufacturing/Construction energy ,Transport ,Electricity & Heat ,Buildings ,Fugitive from energy production ,Other Fuel Combustion ,Bunker Fuels
India,IND,1990,566640000.0,-42470000.0,24540000.0,26450000.0,148000000.0,64400000.00000001,232000000.0,56400000.0,36520000.0,70590000.0,5100000.0
India,IND,1991,574020000.0,-42470000.0,25190000.0,29000000.0,152100000.0,66900000.00000001,258900000.0,59300000.0,39080000.0,75850000.0,4900000.0
India,IND,1992,580520000.0,-42470000.0,25850000.0,30060000.0,155100000.0,68500000.0,278600000.0,58600000.0,38630000.0,76410000.0,5000000.0
India,IND,1993,587230000.0,-42470000.0,26500000.0,31900000.0,152700000.0,68600000.0,306700000.0,58900000.0,35060000.0,76060000.0,5400000.0
India,IND,1994,595230000.0,-42470000.0,27160000.0,34290000.0,162400000.0,70800000.0,319800000.0,63500000.0,35270000.0,81420000.0,5800000.0
India,IND,1995,599650000.0,-42470000.0,32900000.0,37750000.0,155700000.0,78300000.0,364900000.0,65400000.00000001,37000000.0,84950000.0,6300000.0
India,IND,1996,607050000.0,-48480000.0,38650000.0,41940000.0,155400000.0,83800000.0,388200000.0,67300000.0,36490000.0,88880000.0,6600000.0
India,IND,1997,612420000.0,-48710000.0,44390000.0,46360000.0,169900000.0,85800000.0,402100000.0,72900000.0,36970000.0,93610000.0,6600000.0
India,IND,1998,619680000.0,-48670000.0,50140000.0,49880000.0,177800000.0,88800000.0,418200000.0,70400000.0,37340000.0,84440000.0,6700000.0
India,IND,1999,623280000.0,-47070000.0,55880000.0,55600000.0,184200000.0,93300000.0,459600000.0,73400000.0,37760000.0,91070000.0,7000000.0
India,IND,2000,617940000.0,-48420000.0,61620000.0,57490000.0,187500000.0,95100000.0,491200000.0,72700000.0,38180000.0,90700000.0,7200000.0
India,IND,2001,623080000.0,-166250000.0,62890000.0,59210000.0,188400000.0,94900000.0,505300000.0,71300000.0,37620000.0,92800000.0,7300000.0
India,IND,2002,607100000.0,-167130000.0,64170000.0,63090000.0,202300000.0,97700000.0,513600000.0,74700000.0,40060000.0,96010000.0,7400000.0
India,IND,2003,618870000.0,-163370000.0,65440000.0,66099999.99999999,189600000.0,99500000.0,536400000.0,76700000.0,43540000.0,101410000.0,8000000.0
India,IND,2004,628600000.0,-159940000.0,66709999.99999999,68610000.0,202200000.0,108000000.0,584700000.0,79000000.0,45550000.0,105310000.0,9100000.0
India,IND,2005,647850000.0,-163600000.0,67980000.0,72540000.0,231500000.0,114700000.0,599600000.0,80000000.0,47940000.0,104910000.0,10500000.0
India,IND,2006,662580000.0,-124250000.0,69250000.0,76400000.0,257800000.0,119700000.0,638800000.0,81300000.0,50110000.0,105160000.0,12300000.0
India,IND,2007,679900000.0,-121720000.0,70530000.0,81150000.0,290000000.0,141800000.0,701200000.0,81600000.0,52560000.0,101800000.0,13900000.0
India,IND,2008,687490000.0,-124400000.0,71800000.0,86190000.0,315900000.0,162000000.0,721300000.0,83300000.0,55000000.0,112250000.0,13800000.0
India,IND,2009,681790000.0,-113780000.0,73070000.0,98630000.0,367500000.0,177300000.0,791000000.0,89600000.0,57660000.0,132890000.0,14700000.0
India,IND,2010,691650000.0,-115040000.0,74340000.0,105420000.0,414200000.0,191300000.0,821000000.0,92800000.0,60050000.0,122230000.0,15600000.0
India,IND,2011,701900000.0,126750000.0,75450000.0,111410000.0,449700000.0,207200000.0,866300000.0,96700000.0,59040000.0,105870000.0,16500000.0
India,IND,2012,696000000.0,133590000.0,76560000.0,117190000.0,433000000.0,219200000.0,995100000.0,96600000.0,58350000.0,118110000.0,15800000.0
India,IND,2013,698360000.0,127370000.0,77670000.0,120950000.0,473800000.0,223700000.0,1004700000.0,98400000.0,57070000.0,112340000.0,16399999.999999998
India,IND,2014,699800000.0,126910000.0,78780000.0,125520000.0,506900000.0,233000000.0,1117000000.0,102900000.0,56110000.0,116880000.0,17100000.0
India,IND,2015,700100000.0,124290000.0,79890000.0,130190000.0,507500000.0,254500000.0,1101800000.0,106900000.0,55200000.0,116720000.0,18500000.0
India,IND,2016,704160000.0,126430000.0,80980000.0,130610000.0,533800000.0,265300000.0,1111300000.0,109200000.0,54950000.0,119040000.0,20400000.0
28 changes: 28 additions & 0 deletions output/sector_merge_usa.csv
View file
Original file line number Diff line number Diff line change
@@ -0,0 +1,28 @@
Entity,Code,Year,Agriculture ,Land-Use Change and Forestry ,Waste ,Industry ,Manufacturing/Construction energy ,Transport ,Electricity & Heat ,Buildings ,Fugitive from energy production ,Other Fuel Combustion ,Bunker Fuels
United States,USA,1990,358270000.0,-291160000.0,199340000.0,164710000.0,604500000.0,1427000000.0,2159800000.0,545500000.0,360760000.0,140960000.0,130800000.0
United States,USA,1991,359280000.0,-291160000.0,201900000.0,154310000.0,566900000.0,1399700000.0,2179900000.0,555200000.0,361500000.0,140410000.0,137100000.0
United States,USA,1992,366210000.0,-291160000.0,202080000.0,157310000.0,517700000.00000006,1430700000.0,2276900000.0,565000000.0,357230000.0,127200000.0,144000000.0
United States,USA,1993,369970000.0,-291160000.0,200220000.0,160570000.0,532500000.0,1454200000.0,2335500000.0,585500000.0,345680000.0,126240000.0,132400000.0
United States,USA,1994,375870000.0,-291160000.0,200520000.0,165510000.0,534900000.0,1506900000.0,2360800000.0,575900000.0,348300000.0,128980000.0,130100000.0
United States,USA,1995,376920000.0,-291160000.0,195750000.0,187540000.0,486800000.0,1537800000.0,2423400000.0,580100000.0,342930000.0,130590000.0,137900000.0
United States,USA,1996,380440000.0,-356840000.0,192390000.0,197280000.0,486000000.0,1577200000.0,2504000000.0,616400000.0,338990000.0,133450000.0,134600000.0
United States,USA,1997,378940000.0,-372990000.0,183260000.0,198510000.0,506800000.0,1602100000.0,2738600000.0,600000000.0,333330000.0,133930000.0,126700000.0
United States,USA,1998,377480000.0,-363890000.0,173820000.0,209710000.0,512800000.0,1640400000.0,2800100000.0,548600000.0,317320000.0,129430000.0,126500000.0
United States,USA,1999,374370000.0,-340470000.0,167630000.0,206140000.0,499400000.0,1686200000.0,2769600000.0,567400000.0,311080000.0,124150000.0,140500000.0
United States,USA,2000,367550000.0,-364570000.0,164690000.0,208700000.0,567200000.0,1717800000.0,2801300000.0,599100000.0,306020000.0,127130000.0,147500000.0
United States,USA,2001,367880000.0,-368260000.0,159810000.0,192090000.0,540100000.0,1720000000.0,2812800000.0,581700000.0,306050000.0,127450000.0,114300000.0
United States,USA,2002,366490000.0,-325460000.0,157990000.0,202070000.0,490900000.0,1741600000.0,2679800000.0,582900000.0,296070000.0,129300000.0,138900000.0
United States,USA,2003,371380000.0,-353280000.0,160860000.0,191490000.0,485500000.0,1766800000.0,2707700000.0,605700000.0,294030000.0,123080000.0,123100000.0
United States,USA,2004,373080000.0,-287550000.0,158530000.0,199030000.0,511700000.0,1788700000.0,2742100000.0,590300000.0,292060000.0,132320000.0,141200000.0
United States,USA,2005,372170000.0,-324600000.0,156440000.0,204420000.0,477400000.0,1807700000.0,2791200000.0,572000000.0,292090000.0,128870000.0,151500000.0
United States,USA,2006,375410000.0,-318530000.0,154350000.0,208390000.0,495900000.0,1806000000.0,2722900000.0,517600000.0,296160000.0,130780000.0,158300000.0
United States,USA,2007,378830000.0,-196560000.0,152340000.0,221720000.0,486100000.0,1806400000.0,2789400000.0,549000000.0,291600000.0,122310000.0,168100000.0
United States,USA,2008,377590000.0,-352600000.0,150220000.0,208910000.0,474800000.0,1708300000.0,2719600000.0,556300000.0,307440000.0,116890000.0,154100000.0
United States,USA,2009,371720000.0,-328640000.0,147450000.0,190550000.0,407600000.0,1622500000.0,2489100000.0,551400000.0,303420000.0,110750000.0,141200000.0
United States,USA,2010,373600000.0,-330760000.0,148270000.0,204590000.0,466400000.0,1679800000.0,2609600000.0,545000000.0,303230000.0,112080000.0,148800000.0
United States,USA,2011,375400000.0,20940000.0,139230000.0,217000000.0,435800000.0,1633600000.0,2488700000.0,522200000.00000006,297040000.0,105950000.0,145600000.0
United States,USA,2012,371670000.0,-32460000.0,140310000.0,210150000.0,438600000.0,1597500000.0,2360200000.0,460600000.0,289480000.0,100030000.0,119400000.0
United States,USA,2013,370840000.0,-52230000.0,136430000.0,209350000.0,434900000.0,1646900000.0,2378500000.0,528000000.0,298470000.0,105150000.0,118300000.0
United States,USA,2014,370750000.0,-31250000.0,136100000.0,219360000.0,437300000.0,1639800000.0,2376200000.0,545100000.0,303060000.0,101340000.0,119000000.0
United States,USA,2015,370360000.0,-30760000.0,135200000.0,221220000.0,424900000.0,1700000000.0,2234000000.0,512600000.0,301360000.0,97580000.0,124500000.0
United States,USA,2016,380930000.0,-73790000.0,131030000.0,222020000.0,433600000.0,1711200000.0,2145500000.0,496500000.0,291970000.0,94530000.0,127600000.0
Binary file added plot/world-ghg.png
View file
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.

0 comments on commit 9eb6d13

Please sign in to comment.