Evidencia_R_A01770717
Carolina Esquivel González
2023-04-27
###DATA BASE
#The libraries are loaded, and subsequently the databases are loaded (File 4, File 6 and File 7).
library(readxl)## Warning: package 'readxl' was built under R version 4.2.3library(dplyr)## Warning: package 'dplyr' was built under R version 4.2.3##
## Attaching package: 'dplyr'## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, unionlibrary(ggplot2)## Warning: package 'ggplot2' was built under R version 4.2.3#library(tidyverse)
bd_7<- read_excel("C:\\Users\\User-1\\Desktop\\R_Evidencia\\Excel_7.xlsx")
bd_6 <- read.csv("C:\\Users\\User-1\\Downloads\\TEC 4TO\\R_Evidencia\\Excel_6.csv")
bd_5 <- read.csv("C:\\Users\\User-1\\Downloads\\TEC 4TO\\R_Evidencia\\Excel_5.csv")#To know the data of each database.
glimpse(bd_5)## Rows: 55,440
## Columns: 11
## $ X <int> 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, …
## $ Country <chr> "World", "World", "World", "World", "World…
## $ Energy_type <chr> "all_energy_types", "coal", "natural_gas",…
## $ Year <int> 1980, 1980, 1980, 1980, 1980, 1980, 1980, …
## $ Energy_consumption <dbl> 2.928998e+02, 7.865613e+01, 5.386522e+01, …
## $ Energy_production <dbl> 2.963372e+02, 8.011419e+01, 5.476105e+01, …
## $ GDP <dbl> 27770.91, 27770.91, 27770.91, 27770.91, 27…
## $ Population <dbl> 4298126.522, 4298126.522, 4298126.522, 429…
## $ Energy_intensity_per_capita <dbl> 68.145921, 68.145921, 68.145921, 68.145921…
## $ Energy_intensity_by_GDP <dbl> 10.547, 10.547, 10.547, 10.547, 10.547, 10…
## $ CO2_emission <dbl> 4946.627, 1409.790, 1081.593, 2455.244, 0.…glimpse(bd_6)## Rows: 17,432
## Columns: 122
## $ iso_code <chr> "AFG", "AFG", "AFG", "AFG", "A…
## $ country <chr> "Afghanistan", "Afghanistan", …
## $ year <int> 1900, 1901, 1902, 1903, 1904, …
## $ coal_prod_change_pct <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ coal_prod_change_twh <dbl> NA, 0, 0, 0, 0, 0, 0, 0, 0, 0,…
## $ gas_prod_change_pct <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ gas_prod_change_twh <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ oil_prod_change_pct <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ oil_prod_change_twh <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ energy_cons_change_pct <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ energy_cons_change_twh <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ biofuel_share_elec <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ biofuel_elec_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ biofuel_cons_change_pct <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ biofuel_share_energy <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ biofuel_cons_change_twh <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ biofuel_consumption <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ biofuel_cons_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ carbon_intensity_elec <int> NA, NA, NA, NA, NA, NA, NA, NA…
## $ coal_share_elec <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ coal_cons_change_pct <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ coal_share_energy <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ coal_cons_change_twh <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ coal_consumption <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ coal_elec_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ coal_cons_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ coal_production <dbl> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, …
## $ coal_prod_per_capita <dbl> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, …
## $ electricity_generation <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ biofuel_electricity <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ coal_electricity <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ fossil_electricity <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ gas_electricity <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ hydro_electricity <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ nuclear_electricity <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ oil_electricity <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ other_renewable_electricity <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ other_renewable_exc_biofuel_electricity <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ renewables_electricity <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ solar_electricity <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ wind_electricity <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ energy_per_gdp <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ energy_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ fossil_cons_change_pct <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ fossil_share_energy <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ fossil_cons_change_twh <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ fossil_fuel_consumption <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ fossil_energy_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ fossil_cons_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ fossil_share_elec <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ gas_share_elec <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ gas_cons_change_pct <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ gas_share_energy <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ gas_cons_change_twh <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ gas_consumption <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ gas_elec_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ gas_energy_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ gas_production <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ gas_prod_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ hydro_share_elec <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ hydro_cons_change_pct <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ hydro_share_energy <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ hydro_cons_change_twh <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ hydro_consumption <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ hydro_elec_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ hydro_energy_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ low_carbon_share_elec <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ low_carbon_electricity <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ low_carbon_elec_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ low_carbon_cons_change_pct <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ low_carbon_share_energy <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ low_carbon_cons_change_twh <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ low_carbon_consumption <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ low_carbon_energy_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ nuclear_share_elec <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ nuclear_cons_change_pct <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ nuclear_share_energy <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ nuclear_cons_change_twh <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ nuclear_consumption <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ nuclear_elec_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ nuclear_energy_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ oil_share_elec <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ oil_cons_change_pct <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ oil_share_energy <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ oil_cons_change_twh <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ oil_consumption <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ oil_elec_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ oil_energy_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ oil_production <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ oil_prod_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ other_renewables_elec_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ other_renewables_share_elec <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ other_renewables_cons_change_pct <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ other_renewables_share_energy <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ other_renewables_cons_change_twh <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ other_renewable_consumption <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ other_renewables_energy_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ per_capita_electricity <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ population <dbl> 5021241, 5053439, 5085403, 511…
## $ primary_energy_consumption <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ renewables_elec_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ renewables_share_elec <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ renewables_cons_change_pct <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ renewables_share_energy <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ renewables_cons_change_twh <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ renewables_consumption <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ renewables_energy_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ solar_share_elec <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ solar_cons_change_pct <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ solar_share_energy <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ solar_cons_change_twh <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ solar_consumption <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ solar_elec_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ solar_energy_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ gdp <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ wind_share_elec <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ wind_cons_change_pct <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ wind_share_energy <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ wind_cons_change_twh <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ wind_consumption <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ wind_elec_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…
## $ wind_energy_per_capita <dbl> NA, NA, NA, NA, NA, NA, NA, NA…glimpse(bd_7)## Rows: 6,241
## Columns: 11
## $ Entity <chr> "Afghanistan", "Afghanistan"…
## $ Code <chr> "AFG", "AFG", "AFG", "AFG", …
## $ Year <dbl> 2000, 2001, 2002, 2003, 2004…
## $ `Electricity from coal (TWh)` <dbl> 0.0000, 0.0000, 0.0000, 0.00…
## $ `Electricity from gas (TWh)` <dbl> 0.1550, 0.0940, 0.1320, 0.30…
## $ `Electricity from hydro (TWh)` <dbl> 0.31200, 0.49800, 0.55500, 0…
## $ `Electricity from other renewables (TWh)` <dbl> 0.0000000, 0.0000000, 0.0000…
## $ `Electricity from solar (TWh)` <dbl> 0.0000, 0.0000, 0.0000, 0.00…
## $ `Electricity from oil (TWh)` <dbl> 0.00000, 0.00000, 0.00000, 0…
## $ `Electricity from wind (TWh)` <dbl> 0e+00, 0e+00, 0e+00, 0e+00, …
## $ `Electricity from nuclear (TWh)` <dbl> 0.000, 0.000, 0.000, 0.000, …#To generate the filters for the databases (YEARS <- 2010-2017) (COUNTRIES).
bd_5_filter <- bd_5 %>% filter(Year>=2010 & Year<=2017) %>% filter(Country=="Mexico"|Country=="Venezuela"|Country=="Canada"|Country=="Haiti"|Country=="Brazil")
bd_5_filter## X Country Energy_type Year Energy_consumption
## 1 41736 Brazil all_energy_types 2010 11.415835000
## 2 41737 Brazil coal 2010 0.561311282
## 3 41738 Brazil natural_gas 2010 0.941554404
## 4 41739 Brazil petroleum_n_other_liquids 2010 5.376638699
## 5 41740 Brazil nuclear 2010 0.142657525
## 6 41741 Brazil renewables_n_other 2010 4.393673095
## 7 41796 Canada all_energy_types 2010 13.791381780
## 8 41797 Canada coal 2010 0.950776295
## 9 41798 Canada natural_gas 2010 3.552594711
## 10 41799 Canada petroleum_n_other_liquids 2010 4.801996547
## 11 41800 Canada nuclear 2010 0.965256101
## 12 41801 Canada renewables_n_other 2010 3.520758130
## 13 42138 Haiti all_energy_types 2010 0.030979543
## 14 42139 Haiti coal 2010 0.000000000
## 15 42140 Haiti natural_gas 2010 0.000000000
## 16 42141 Haiti petroleum_n_other_liquids 2010 0.029263462
## 17 42142 Haiti nuclear 2010 NA
## 18 42143 Haiti renewables_n_other 2010 0.001716080
## 19 42378 Mexico all_energy_types 2010 7.530859039
## 20 42379 Mexico coal 2010 0.539874291
## 21 42380 Mexico natural_gas 2010 2.349203019
## 22 42381 Mexico petroleum_n_other_liquids 2010 4.134500305
## 23 42382 Mexico nuclear 2010 0.056283480
## 24 42383 Mexico renewables_n_other 2010 0.450997943
## 25 42924 Venezuela all_energy_types 2010 3.109112545
## 26 42925 Venezuela coal 2010 0.007905060
## 27 42926 Venezuela natural_gas 2010 0.812814913
## 28 42927 Venezuela petroleum_n_other_liquids 2010 1.545535984
## 29 42928 Venezuela nuclear 2010 NA
## 30 42929 Venezuela renewables_n_other 2010 0.742856588
## 31 43122 Brazil all_energy_types 2011 11.893502440
## 32 43123 Brazil coal 2011 0.594257768
## 33 43124 Brazil natural_gas 2011 0.936323546
## 34 43125 Brazil petroleum_n_other_liquids 2011 5.563514710
## 35 43126 Brazil nuclear 2011 0.153232037
## 36 43127 Brazil renewables_n_other 2011 4.646174380
## 37 43182 Canada all_energy_types 2011 14.150167470
## 38 43183 Canada coal 2011 0.894573421
## 39 43184 Canada natural_gas 2011 3.680321941
## 40 43185 Canada petroleum_n_other_liquids 2011 4.852845607
## 41 43186 Canada nuclear 2011 0.997058377
## 42 43187 Canada renewables_n_other 2011 3.725368127
## 43 43524 Haiti all_energy_types 2011 0.032568058
## 44 43525 Haiti coal 2011 0.000000000
## 45 43526 Haiti natural_gas 2011 0.000000000
## 46 43527 Haiti petroleum_n_other_liquids 2011 0.031393394
## 47 43528 Haiti nuclear 2011 NA
## 48 43529 Haiti renewables_n_other 2011 0.001174664
## 49 43764 Mexico all_energy_types 2011 7.738480830
## 50 43765 Mexico coal 2011 0.592651490
## 51 43766 Mexico natural_gas 2011 2.414286583
## 52 43767 Mexico petroleum_n_other_liquids 2011 4.195109301
## 53 43768 Mexico nuclear 2011 0.093735345
## 54 43769 Mexico renewables_n_other 2011 0.442698111
## 55 44310 Venezuela all_energy_types 2011 3.135561030
## 56 44311 Venezuela coal 2011 0.008134489
## 57 44312 Venezuela natural_gas 2011 0.878265439
## 58 44313 Venezuela petroleum_n_other_liquids 2011 1.442559323
## 59 44314 Venezuela nuclear 2011 NA
## 60 44315 Venezuela renewables_n_other 2011 0.806601780
## 61 44508 Brazil all_energy_types 2012 12.204076370
## 62 44509 Brazil coal 2012 0.597451131
## 63 44510 Brazil natural_gas 2012 1.130238918
## 64 44511 Brazil petroleum_n_other_liquids 2012 5.835988554
## 65 44512 Brazil nuclear 2012 0.157115918
## 66 44513 Brazil renewables_n_other 2012 4.483281845
## 67 44568 Canada all_energy_types 2012 14.318351440
## 68 44569 Canada coal 2012 0.819152036
## 69 44570 Canada natural_gas 2012 3.864857492
## 70 44571 Canada petroleum_n_other_liquids 2012 4.954982195
## 71 44572 Canada nuclear 2012 1.006998771
## 72 44573 Canada renewables_n_other 2012 3.672360942
## 73 44910 Haiti all_energy_types 2012 0.035807396
## 74 44911 Haiti coal 2012 0.000000000
## 75 44912 Haiti natural_gas 2012 0.000000000
## 76 44913 Haiti petroleum_n_other_liquids 2012 0.033704360
## 77 44914 Haiti nuclear 2012 NA
## 78 44915 Haiti renewables_n_other 2012 0.002103036
## 79 45150 Mexico all_energy_types 2012 7.708254229
## 80 45151 Mexico coal 2012 0.527340007
## 81 45152 Mexico natural_gas 2012 2.510130826
## 82 45153 Mexico petroleum_n_other_liquids 2012 4.168877508
## 83 45154 Mexico nuclear 2012 0.084666780
## 84 45155 Mexico renewables_n_other 2012 0.417239108
## 85 45696 Venezuela all_energy_types 2012 3.399249698
## 86 45697 Venezuela coal 2012 0.008363917
## 87 45698 Venezuela natural_gas 2012 0.943024991
## 88 45699 Venezuela petroleum_n_other_liquids 2012 1.671849468
## 89 45700 Venezuela nuclear 2012 NA
## 90 45701 Venezuela renewables_n_other 2012 0.776011321
## 91 45894 Brazil all_energy_types 2013 12.574322550
## 92 45895 Brazil coal 2013 0.642566214
## 93 45896 Brazil natural_gas 2013 1.334578641
## 94 45897 Brazil petroleum_n_other_liquids 2013 6.108487702
## 95 45898 Brazil nuclear 2013 0.151678485
## 96 45899 Brazil renewables_n_other 2013 4.337011504
## 97 45954 Canada all_energy_types 2013 14.738479680
## 98 45955 Canada coal 2013 0.773400677
## 99 45956 Canada natural_gas 2013 4.115150439
## 100 45957 Canada petroleum_n_other_liquids 2013 4.903361803
## 101 45958 Canada nuclear 2013 1.096450701
## 102 45959 Canada renewables_n_other 2013 3.850116065
## 103 46296 Haiti all_energy_types 2013 0.037676343
## 104 46297 Haiti coal 2013 0.000000000
## 105 46298 Haiti natural_gas 2013 0.000000000
## 106 46299 Haiti petroleum_n_other_liquids 2013 0.036321521
## 107 46300 Haiti nuclear 2013 NA
## 108 46301 Haiti renewables_n_other 2013 0.001354822
## 109 46536 Mexico all_energy_types 2013 7.786554957
## 110 46537 Mexico coal 2013 0.537472337
## 111 46538 Mexico natural_gas 2013 2.620203332
## 112 46539 Mexico petroleum_n_other_liquids 2013 4.128185883
## 113 46540 Mexico nuclear 2013 0.114511015
## 114 46541 Mexico renewables_n_other 2013 0.386182390
## 115 47082 Venezuela all_energy_types 2013 3.217803300
## 116 47083 Venezuela coal 2013 0.008328597
## 117 47084 Venezuela natural_gas 2013 0.907478254
## 118 47085 Venezuela petroleum_n_other_liquids 2013 1.508929850
## 119 47086 Venezuela nuclear 2013 NA
## 120 47087 Venezuela renewables_n_other 2013 0.793066598
## 121 47280 Brazil all_energy_types 2014 12.805000840
## 122 47281 Brazil coal 2014 0.696759586
## 123 47282 Brazil natural_gas 2014 1.411696430
## 124 47283 Brazil petroleum_n_other_liquids 2014 6.300143609
## 125 47284 Brazil nuclear 2014 0.149793508
## 126 47285 Brazil renewables_n_other 2014 4.246607709
## 127 47340 Canada all_energy_types 2014 14.798053800
## 128 47341 Canada coal 2014 0.751454256
## 129 47342 Canada natural_gas 2014 4.275888143
## 130 47343 Canada petroleum_n_other_liquids 2014 4.853165921
## 131 47344 Canada nuclear 2014 1.114731584
## 132 47345 Canada renewables_n_other 2014 3.802813896
## 133 47682 Haiti all_energy_types 2014 0.040601258
## 134 47683 Haiti coal 2014 0.000000000
## 135 47684 Haiti natural_gas 2014 0.000000000
## 136 47685 Haiti petroleum_n_other_liquids 2014 0.039735848
## 137 47686 Haiti nuclear 2014 NA
## 138 47687 Haiti renewables_n_other 2014 0.000865410
## 139 47922 Mexico all_energy_types 2014 7.682433692
## 140 47923 Mexico coal 2014 0.516109708
## 141 47924 Mexico natural_gas 2014 2.550020102
## 142 47925 Mexico petroleum_n_other_liquids 2014 4.010070968
## 143 47926 Mexico nuclear 2014 0.093725280
## 144 47927 Mexico renewables_n_other 2014 0.512507634
## 145 48468 Venezuela all_energy_types 2014 3.057327846
## 146 48469 Venezuela coal 2014 0.007878911
## 147 48470 Venezuela natural_gas 2014 0.910434084
## 148 48471 Venezuela petroleum_n_other_liquids 2014 1.535509247
## 149 48472 Venezuela nuclear 2014 NA
## 150 48473 Venezuela renewables_n_other 2014 0.603505603
## 151 48666 Brazil all_energy_types 2015 12.558048010
## 152 48667 Brazil coal 2015 0.681610145
## 153 48668 Brazil natural_gas 2015 1.471739205
## 154 48669 Brazil petroleum_n_other_liquids 2015 6.093181139
## 155 48670 Brazil nuclear 2015 0.143879652
## 156 48671 Brazil renewables_n_other 2015 4.167637869
## 157 48726 Canada all_energy_types 2015 14.705685520
## 158 48727 Canada coal 2015 0.704390121
## 159 48728 Canada natural_gas 2015 4.251207033
## 160 48729 Canada petroleum_n_other_liquids 2015 4.958156188
## 161 48730 Canada nuclear 2015 1.081364715
## 162 48731 Canada renewables_n_other 2015 3.710567464
## 163 49068 Haiti all_energy_types 2015 0.046303908
## 164 49069 Haiti coal 2015 0.000000000
## 165 49070 Haiti natural_gas 2015 0.000000000
## 166 49071 Haiti petroleum_n_other_liquids 2015 0.045519528
## 167 49072 Haiti nuclear 2015 NA
## 168 49073 Haiti renewables_n_other 2015 0.000784380
## 169 49308 Mexico all_energy_types 2015 7.804190734
## 170 49309 Mexico coal 2015 0.561176790
## 171 49310 Mexico natural_gas 2015 2.736557814
## 172 49311 Mexico petroleum_n_other_liquids 2015 3.936013626
## 173 49312 Mexico nuclear 2015 0.112577025
## 174 49313 Mexico renewables_n_other 2015 0.457865480
## 175 49854 Venezuela all_energy_types 2015 3.060093494
## 176 49855 Venezuela coal 2015 0.005358025
## 177 49856 Venezuela natural_gas 2015 1.017381395
## 178 49857 Venezuela petroleum_n_other_liquids 2015 1.348470561
## 179 49858 Venezuela nuclear 2015 NA
## 180 49859 Venezuela renewables_n_other 2015 0.688883513
## 181 50052 Brazil all_energy_types 2016 12.368063170
## 182 50053 Brazil coal 2016 0.648622161
## 183 50054 Brazil natural_gas 2016 1.256183254
## 184 50055 Brazil petroleum_n_other_liquids 2016 5.874295310
## 185 50056 Brazil nuclear 2016 0.155049279
## 186 50057 Brazil renewables_n_other 2016 4.433913171
## 187 50112 Canada all_energy_types 2016 14.615077080
## 188 50113 Canada coal 2016 0.694743386
## 189 50114 Canada natural_gas 2016 4.071426084
## 190 50115 Canada petroleum_n_other_liquids 2016 5.015402839
## 191 50116 Canada nuclear 2016 1.081513854
## 192 50117 Canada renewables_n_other 2016 3.751990921
## 193 50454 Haiti all_energy_types 2016 0.048070381
## 194 50455 Haiti coal 2016 0.000000000
## 195 50456 Haiti natural_gas 2016 0.000000000
## 196 50457 Haiti petroleum_n_other_liquids 2016 0.047403000
## 197 50458 Haiti nuclear 2016 NA
## 198 50459 Haiti renewables_n_other 2016 0.000667381
## 199 50694 Mexico all_energy_types 2016 7.973903263
## 200 50695 Mexico coal 2016 0.499536498
## 201 50696 Mexico natural_gas 2016 2.844381592
## 202 50697 Mexico petroleum_n_other_liquids 2016 4.049421792
## 203 50698 Mexico nuclear 2016 0.103387680
## 204 50699 Mexico renewables_n_other 2016 0.477175701
## 205 51240 Venezuela all_energy_types 2016 2.934002412
## 206 51241 Venezuela coal 2016 0.004574828
## 207 51242 Venezuela natural_gas 2016 0.946326912
## 208 51243 Venezuela petroleum_n_other_liquids 2016 1.410394675
## 209 51244 Venezuela nuclear 2016 NA
## 210 51245 Venezuela renewables_n_other 2016 0.572705998
## 211 51438 Brazil all_energy_types 2017 12.505460280
## 212 51439 Brazil coal 2017 0.687332630
## 213 51440 Brazil natural_gas 2017 1.283290145
## 214 51441 Brazil petroleum_n_other_liquids 2017 5.952095181
## 215 51442 Brazil nuclear 2017 0.153846519
## 216 51443 Brazil renewables_n_other 2017 4.428895809
## 217 51498 Canada all_energy_types 2017 14.968773720
## 218 51499 Canada coal 2017 0.695581720
## 219 51500 Canada natural_gas 2017 4.352609719
## 220 51501 Canada petroleum_n_other_liquids 2017 4.994161406
## 221 51502 Canada nuclear 2017 1.075645649
## 222 51503 Canada renewables_n_other 2017 3.850775222
## 223 51840 Haiti all_energy_types 2017 0.047716252
## 224 51841 Haiti coal 2017 0.000000000
## 225 51842 Haiti natural_gas 2017 0.000054000
## 226 51843 Haiti petroleum_n_other_liquids 2017 0.046476267
## 227 51844 Haiti nuclear 2017 NA
## 228 51845 Haiti renewables_n_other 2017 0.001185989
## 229 52080 Mexico all_energy_types 2017 7.960064777
## 230 52081 Mexico coal 2017 0.518771153
## 231 52082 Mexico natural_gas 2017 2.861173018
## 232 52083 Mexico petroleum_n_other_liquids 2017 3.966391048
## 233 52084 Mexico nuclear 2017 0.106406375
## 234 52085 Mexico renewables_n_other 2017 0.507323182
## 235 52626 Venezuela all_energy_types 2017 2.870511562
## 236 52627 Venezuela coal 2017 0.003308469
## 237 52628 Venezuela natural_gas 2017 1.039568963
## 238 52629 Venezuela petroleum_n_other_liquids 2017 1.278319425
## 239 52630 Venezuela nuclear 2017 NA
## 240 52631 Venezuela renewables_n_other 2017 0.549314705
## Energy_production GDP Population Energy_intensity_per_capita
## 1 10.112689120 2846.7270 195941.80 58.261356
## 2 0.086277696 2846.7270 195941.80 58.261356
## 3 0.470403569 2846.7270 195941.80 58.261356
## 4 4.560610008 2846.7270 195941.80 58.261356
## 5 0.142657525 2846.7270 195941.80 58.261356
## 6 4.852740324 2846.7270 195941.80 58.261356
## 7 18.289494660 1433.9220 34004.90 405.570426
## 8 1.437011512 1433.9220 34004.90 405.570426
## 9 5.571873642 1433.9220 34004.90 405.570426
## 10 6.679306141 1433.9220 34004.90 405.570426
## 11 0.965256101 1433.9220 34004.90 405.570426
## 12 3.636047264 1433.9220 34004.90 405.570426
## 13 0.001716080 26.3337 9949.32 3.113735
## 14 0.000000000 26.3337 9949.32 3.113735
## 15 0.000000000 26.3337 9949.32 3.113735
## 16 0.000000000 26.3337 9949.32 3.113735
## 17 NA 26.3337 9949.32 3.113735
## 18 0.001716080 26.3337 9949.32 3.113735
## 19 8.859033573 1927.2260 114291.80 65.891508
## 20 0.323136892 1927.2260 114291.80 65.891508
## 21 1.845932154 1927.2260 114291.80 65.891508
## 22 6.188540823 1927.2260 114291.80 65.891508
## 23 0.056283480 1927.2260 114291.80 65.891508
## 24 0.445140224 1927.2260 114291.80 65.891508
## 25 7.256777116 507.9990 28439.93 109.322089
## 26 0.093263406 507.9990 28439.93 109.322089
## 27 0.757306726 507.9990 28439.93 109.322089
## 28 5.664614399 507.9990 28439.93 109.322089
## 29 NA 507.9990 28439.93 109.322089
## 30 0.741592584 507.9990 28439.93 109.322089
## 31 10.467051130 2963.3450 197752.50 60.143373
## 32 0.087711674 2963.3450 197752.50 60.143373
## 33 0.544756477 2963.3450 197752.50 60.143373
## 34 4.677433188 2963.3450 197752.50 60.143373
## 35 0.153232037 2963.3450 197752.50 60.143373
## 36 5.003917756 2963.3450 197752.50 60.143373
## 37 18.703230260 1479.0360 34339.32 412.068948
## 38 1.420607030 1479.0360 34339.32 412.068948
## 39 5.400081130 1479.0360 34339.32 412.068948
## 40 7.009860482 1479.0360 34339.32 412.068948
## 41 0.997058377 1479.0360 34339.32 412.068948
## 42 3.875623244 1479.0360 34339.32 412.068948
## 43 0.001174664 27.7910 10100.30 3.224464
## 44 0.000000000 27.7910 10100.30 3.224464
## 45 0.000000000 27.7910 10100.30 3.224464
## 46 0.000000000 27.7910 10100.30 3.224464
## 47 NA 27.7910 10100.30 3.224464
## 48 0.001174664 27.7910 10100.30 3.224464
## 49 8.898677169 1997.9960 115875.80 66.782545
## 50 0.412113555 1997.9960 115875.80 66.782545
## 51 1.810403663 1997.9960 115875.80 66.782545
## 52 6.144922426 1997.9960 115875.80 66.782545
## 53 0.093735345 1997.9960 115875.80 66.782545
## 54 0.437502180 1997.9960 115875.80 66.782545
## 55 7.545071639 529.2160 28887.85 108.542554
## 56 0.076829391 529.2160 28887.85 108.542554
## 57 0.797268014 529.2160 28887.85 108.542554
## 58 5.866149374 529.2160 28887.85 108.542554
## 59 NA 529.2160 28887.85 108.542554
## 60 0.804824860 529.2160 28887.85 108.542554
## 61 10.347849720 3011.0030 199528.20 61.164669
## 62 0.105413340 3011.0030 199528.20 61.164669
## 63 0.634278872 3011.0030 199528.20 61.164669
## 64 4.595127833 3011.0030 199528.20 61.164669
## 65 0.157115918 3011.0030 199528.20 61.164669
## 66 4.855913756 3011.0030 199528.20 61.164669
## 67 19.117303360 1505.0800 34714.22 412.463579
## 68 1.407525778 1505.0800 34714.22 412.463579
## 69 5.281211866 1505.0800 34714.22 412.463579
## 70 7.562017521 1505.0800 34714.22 412.463579
## 71 1.006998771 1505.0800 34714.22 412.463579
## 72 3.859549420 1505.0800 34714.22 412.463579
## 73 0.002103036 28.5882 10250.90 3.493098
## 74 0.000000000 28.5882 10250.90 3.493098
## 75 0.000000000 28.5882 10250.90 3.493098
## 76 0.000000000 28.5882 10250.90 3.493098
## 77 NA 28.5882 10250.90 3.493098
## 78 0.002103036 28.5882 10250.90 3.493098
## 79 8.704528879 2066.5480 117451.50 65.629253
## 80 0.332596205 2066.5480 117451.50 65.629253
## 81 1.759814277 2066.5480 117451.50 65.629253
## 82 6.123430821 2066.5480 117451.50 65.629253
## 83 0.084666780 2066.5480 117451.50 65.629253
## 84 0.404020796 2066.5480 117451.50 65.629253
## 85 7.583972301 558.9890 29360.82 115.775026
## 86 0.056231699 558.9890 29360.82 115.775026
## 87 0.872392166 558.9890 29360.82 115.775026
## 88 5.882221016 558.9890 29360.82 115.775026
## 89 NA 558.9890 29360.82 115.775026
## 90 0.773127420 558.9890 29360.82 115.775026
## 91 10.295419440 3107.7310 201272.50 62.474121
## 92 0.136928997 3107.7310 201272.50 62.474121
## 93 0.710985665 3107.7310 201272.50 62.474121
## 94 4.505808749 3107.7310 201272.50 62.474121
## 95 0.151678485 3107.7310 201272.50 62.474121
## 96 4.790017548 3107.7310 201272.50 62.474121
## 97 19.934672660 1540.1370 35082.95 420.103774
## 98 1.458580761 1540.1370 35082.95 420.103774
## 99 5.349782343 1540.1370 35082.95 420.103774
## 100 7.979768084 1540.1370 35082.95 420.103774
## 101 1.096450701 1540.1370 35082.95 420.103774
## 102 4.050090769 1540.1370 35082.95 420.103774
## 103 0.001354822 29.7913 10400.70 3.622481
## 104 0.000000000 29.7913 10400.70 3.622481
## 105 0.000000000 29.7913 10400.70 3.622481
## 106 0.000000000 29.7913 10400.70 3.622481
## 107 NA 29.7913 10400.70 3.622481
## 108 0.001354822 29.7913 10400.70 3.622481
## 109 8.614019747 2099.2580 119010.50 65.427462
## 110 0.320666491 2099.2580 119010.50 65.427462
## 111 1.758943467 2099.2580 119010.50 65.427462
## 112 6.042736670 2099.2580 119010.50 65.427462
## 113 0.114511015 2099.2580 119010.50 65.427462
## 114 0.377162105 2099.2580 119010.50 65.427462
## 115 7.539512103 566.4970 29781.08 108.048576
## 116 0.045774057 566.4970 29781.08 108.048576
## 117 0.837574790 566.4970 29781.08 108.048576
## 118 5.866149374 566.4970 29781.08 108.048576
## 119 NA 566.4970 29781.08 108.048576
## 120 0.790013882 566.4970 29781.08 108.048576
## 121 10.809245900 3124.0180 202989.00 63.082240
## 122 0.127824325 3124.0180 202989.00 63.082240
## 123 0.760454634 3124.0180 202989.00 63.082240
## 124 5.005801229 3124.0180 202989.00 63.082240
## 125 0.149793508 3124.0180 202989.00 63.082240
## 126 4.765372200 3124.0180 202989.00 63.082240
## 127 20.783997710 1584.3380 35437.45 417.582354
## 128 1.448868821 1584.3380 35437.45 417.582354
## 129 5.598649417 1584.3380 35437.45 417.582354
## 130 8.629165327 1584.3380 35437.45 417.582354
## 131 1.114731584 1584.3380 35437.45 417.582354
## 132 3.992582560 1584.3380 35437.45 417.582354
## 133 0.000865410 30.6369 10549.00 3.848825
## 134 0.000000000 30.6369 10549.00 3.848825
## 135 0.000000000 30.6369 10549.00 3.848825
## 136 0.000000000 30.6369 10549.00 3.848825
## 137 NA 30.6369 10549.00 3.848825
## 138 0.000865410 30.6369 10549.00 3.848825
## 139 8.384385753 2159.2310 120543.50 63.731630
## 140 0.323819965 2159.2310 120543.50 63.731630
## 141 1.627580050 2159.2310 120543.50 63.731630
## 142 5.837588198 2159.2310 120543.50 63.731630
## 143 0.093725280 2159.2310 120543.50 63.731630
## 144 0.501672260 2159.2310 120543.50 63.731630
## 145 7.347768268 544.4360 30043.00 101.765065
## 146 0.035630867 544.4360 30043.00 101.765065
## 147 0.839839647 544.4360 30043.00 101.765065
## 148 5.866149374 544.4360 30043.00 101.765065
## 149 NA 544.4360 30043.00 101.765065
## 150 0.606148380 544.4360 30043.00 101.765065
## 151 11.158554200 3013.5580 204683.50 61.353495
## 152 0.128090344 3013.5580 204683.50 61.353495
## 153 0.762584341 3013.5580 204683.50 61.353495
## 154 5.396806496 3013.5580 204683.50 61.353495
## 155 0.143879652 3013.5580 204683.50 61.353495
## 156 4.727193363 3013.5580 204683.50 61.353495
## 157 20.914467640 1594.7810 35702.90 411.890505
## 158 1.287114116 1594.7810 35702.90 411.890505
## 159 5.781002514 1594.7810 35702.90 411.890505
## 160 8.824457343 1594.7810 35702.90 411.890505
## 161 1.081364715 1594.7810 35702.90 411.890505
## 162 3.940528952 1594.7810 35702.90 411.890505
## 163 0.000784380 31.0020 10695.50 4.329289
## 164 0.000000000 31.0020 10695.50 4.329289
## 165 0.000000000 31.0020 10695.50 4.329289
## 166 0.000000000 31.0020 10695.50 4.329289
## 167 NA 31.0020 10695.50 4.329289
## 168 0.000784380 31.0020 10695.50 4.329289
## 169 7.699776976 2230.7430 122042.50 63.946500
## 170 0.241205327 2230.7430 122042.50 63.946500
## 171 1.471924672 2230.7430 122042.50 63.946500
## 172 5.432100890 2230.7430 122042.50 63.946500
## 173 0.112577025 2230.7430 122042.50 63.946500
## 174 0.441969062 2230.7430 122042.50 63.946500
## 175 7.411476554 510.5640 30081.82 101.725677
## 176 0.025088094 510.5640 30081.82 101.725677
## 177 0.998187692 510.5640 30081.82 101.725677
## 178 5.696311613 510.5640 30081.82 101.725677
## 179 NA 510.5640 30081.82 101.725677
## 180 0.691889155 510.5640 30081.82 101.725677
## 181 11.589707100 2907.9220 206369.00 59.931788
## 182 0.110099660 2907.9220 206369.00 59.931788
## 183 0.782655785 2907.9220 206369.00 59.931788
## 184 5.579731626 2907.9220 206369.00 59.931788
## 185 0.155049279 2907.9220 206369.00 59.931788
## 186 4.962170752 2907.9220 206369.00 59.931788
## 187 21.111175840 1610.7530 36109.48 404.743493
## 188 1.220241720 1610.7530 36109.48 404.743493
## 189 5.849182194 1610.7530 36109.48 404.743493
## 190 8.970339939 1610.7530 36109.48 404.743493
## 191 1.081513854 1610.7530 36109.48 404.743493
## 192 3.989898136 1610.7530 36109.48 404.743493
## 193 0.000667381 31.4576 10840.00 4.434537
## 194 0.000000000 31.4576 10840.00 4.434537
## 195 0.000000000 31.4576 10840.00 4.434537
## 196 0.000000000 31.4576 10840.00 4.434537
## 197 NA 31.4576 10840.00 4.434537
## 198 0.000667381 31.4576 10840.00 4.434537
## 199 7.347492210 2284.1770 123510.20 64.560686
## 200 0.290725037 2284.1770 123510.20 64.560686
## 201 1.337893831 2284.1770 123510.20 64.560686
## 202 5.169780732 2284.1770 123510.20 64.560686
## 203 0.103387680 2284.1770 123510.20 64.560686
## 204 0.445704930 2284.1770 123510.20 64.560686
## 205 6.821430541 423.5640 29851.25 98.287422
## 206 0.022839807 423.5640 29851.25 98.287422
## 207 1.056497665 423.5640 29851.25 98.287422
## 208 5.165794701 423.5640 29851.25 98.287422
## 209 NA 423.5640 29851.25 98.287422
## 210 0.576298368 423.5640 29851.25 98.287422
## 211 11.928930820 2955.1220 208039.80 60.110903
## 212 0.080813016 2955.1220 208039.80 60.110903
## 213 0.895518568 2955.1220 208039.80 60.110903
## 214 5.827698770 2955.1220 208039.80 60.110903
## 215 0.153846519 2955.1220 208039.80 60.110903
## 216 4.971053949 2955.1220 208039.80 60.110903
## 217 22.699568070 1659.7170 36545.25 409.595603
## 218 1.291085727 1659.7170 36545.25 409.595603
## 219 6.547925259 1659.7170 36545.25 409.595603
## 220 9.702707817 1659.7170 36545.25 409.595603
## 221 1.075645649 1659.7170 36545.25 409.595603
## 222 4.082203620 1659.7170 36545.25 409.595603
## 223 0.001185989 31.8198 10982.40 4.344793
## 224 0.000000000 31.8198 10982.40 4.344793
## 225 0.000000000 31.8198 10982.40 4.344793
## 226 0.000000000 31.8198 10982.40 4.344793
## 227 NA 31.8198 10982.40 4.344793
## 228 0.001185989 31.8198 10982.40 4.344793
## 229 6.679953923 2337.5760 124950.20 63.705899
## 230 0.276650911 2337.5760 124950.20 63.705899
## 231 1.150882150 2337.5760 124950.20 63.705899
## 232 4.672601858 2337.5760 124950.20 63.705899
## 233 0.106406375 2337.5760 124950.20 63.705899
## 234 0.473412629 2337.5760 124950.20 63.705899
## 235 6.174772282 357.1842 29402.48 97.628212
## 236 0.017760445 357.1842 29402.48 97.628212
## 237 1.039568963 357.1842 29402.48 97.628212
## 238 4.564691158 357.1842 29402.48 97.628212
## 239 NA 357.1842 29402.48 97.628212
## 240 0.552751716 357.1842 29402.48 97.628212
## Energy_intensity_by_GDP CO2_emission
## 1 4.010161 355.5356772
## 2 4.010161 43.5321401
## 3 4.010161 37.1099769
## 4 4.010161 274.8935602
## 5 4.010161 0.0000000
## 6 4.010161 0.0000000
## 7 9.617944 541.4511468
## 8 9.617944 90.4890590
## 9 9.617944 170.2092032
## 10 9.617944 280.7528847
## 11 9.617944 0.0000000
## 12 9.617944 0.0000000
## 13 1.176422 2.2000000
## 14 1.176422 0.0000000
## 15 1.176422 0.0000000
## 16 1.176422 2.2000000
## 17 1.176422 0.0000000
## 18 1.176422 0.0000000
## 19 3.907616 451.3660992
## 20 3.907616 42.4484330
## 21 3.907616 138.1524069
## 22 3.907616 270.7652593
## 23 3.907616 0.0000000
## 24 3.907616 0.0000000
## 25 6.120312 135.5891712
## 26 6.120312 0.7421906
## 27 6.120312 41.8469807
## 28 6.120312 93.0000000
## 29 6.120312 0.0000000
## 30 6.120312 0.0000000
## 31 4.013540 409.6489669
## 32 4.013540 58.6326494
## 33 4.013540 49.9557382
## 34 4.013540 301.0605793
## 35 4.013540 0.0000000
## 36 4.013540 0.0000000
## 37 9.567156 570.7765144
## 38 9.567156 92.2343014
## 39 9.567156 188.4888334
## 40 9.567156 290.0533796
## 41 9.567156 0.0000000
## 42 9.567156 0.0000000
## 43 1.171892 2.1000000
## 44 1.171892 0.0000000
## 45 1.171892 0.0000000
## 46 1.171892 2.1000000
## 47 1.171892 0.0000000
## 48 1.171892 0.0000000
## 49 3.873121 448.7092106
## 50 3.873121 52.6638833
## 51 3.873121 124.6408815
## 52 3.873121 271.4044458
## 53 3.873121 0.0000000
## 54 3.873121 0.0000000
## 55 5.924917 142.1568467
## 56 5.924917 0.7986927
## 57 5.924917 43.1252499
## 58 5.924917 98.2329040
## 59 5.924917 0.0000000
## 60 5.924917 0.0000000
## 61 4.053160 431.1746552
## 62 4.053160 62.9117277
## 63 4.053160 49.6782063
## 64 4.053160 318.5847212
## 65 4.053160 0.0000000
## 66 4.053160 0.0000000
## 67 9.513349 575.2903398
## 68 9.513349 87.8368314
## 69 9.513349 195.2656145
## 70 9.513349 292.1878939
## 71 9.513349 0.0000000
## 72 9.513349 0.0000000
## 73 1.252524 2.2243209
## 74 1.252524 0.0000000
## 75 1.252524 0.0000000
## 76 1.252524 2.2243209
## 77 1.252524 0.0000000
## 78 1.252524 0.0000000
## 79 3.730015 464.0099760
## 80 3.730015 57.6069406
## 81 3.730015 128.0939985
## 82 3.730015 278.3090369
## 83 3.730015 0.0000000
## 84 3.730015 0.0000000
## 85 6.081067 137.5088473
## 86 6.081067 0.8805206
## 87 6.081067 46.5978366
## 88 6.081067 90.0304900
## 89 6.081067 0.0000000
## 90 6.081067 0.0000000
## 91 4.046143 462.0285770
## 92 4.046143 61.3938494
## 93 4.046143 59.9667095
## 94 4.046143 340.6680182
## 95 4.046143 0.0000000
## 96 4.046143 0.0000000
## 97 9.569590 578.0237602
## 98 9.569590 80.3790827
## 99 9.569590 205.0564557
## 100 9.569590 292.5882218
## 101 9.569590 0.0000000
## 102 9.569590 0.0000000
## 103 1.264676 2.4187792
## 104 1.264676 0.0000000
## 105 1.264676 0.0000000
## 106 1.264676 2.4187792
## 107 1.264676 0.0000000
## 108 1.264676 0.0000000
## 109 3.709194 465.3757178
## 110 3.709194 51.5518307
## 111 3.709194 133.1791745
## 112 3.709194 280.6447126
## 113 3.709194 0.0000000
## 114 3.709194 0.0000000
## 115 5.680177 156.1344406
## 116 5.680177 0.9390290
## 117 5.680177 50.0337626
## 118 5.680177 105.1616490
## 119 5.680177 0.0000000
## 120 5.680177 0.0000000
## 121 4.098888 491.3201116
## 122 4.098888 66.7242590
## 123 4.098888 70.8082941
## 124 4.098888 353.7875585
## 125 4.098888 0.0000000
## 126 4.098888 0.0000000
## 127 9.340213 587.9922448
## 128 9.340213 76.4950908
## 129 9.340213 218.3361651
## 130 9.340213 293.1609888
## 131 9.340213 0.0000000
## 132 9.340213 0.0000000
## 133 1.325240 2.6022979
## 134 1.325240 0.0000000
## 135 1.325240 0.0000000
## 136 1.325240 2.6022979
## 137 1.325240 0.0000000
## 138 1.325240 0.0000000
## 139 3.557949 469.1396435
## 140 3.557949 52.4174124
## 141 3.557949 139.0192548
## 142 3.557949 277.7029763
## 143 3.557949 0.0000000
## 144 3.557949 0.0000000
## 145 5.615587 144.5658239
## 146 5.615587 0.8642417
## 147 5.615587 48.1477712
## 148 5.615587 95.5538110
## 149 5.615587 0.0000000
## 150 5.615587 0.0000000
## 151 4.167183 509.8223744
## 152 4.167183 71.8174748
## 153 4.167183 74.8999069
## 154 4.167183 363.1049926
## 155 4.167183 0.0000000
## 156 4.167183 0.0000000
## 157 9.221132 589.5617457
## 158 9.221132 75.0936480
## 159 9.221132 226.8643719
## 160 9.221132 287.6037257
## 161 9.221132 0.0000000
## 162 9.221132 0.0000000
## 163 1.493578 2.8666739
## 164 1.493578 0.0000000
## 165 1.493578 0.0000000
## 166 1.493578 2.8666739
## 167 1.493578 0.0000000
## 168 1.493578 0.0000000
## 169 3.498471 452.3393533
## 170 3.498471 50.7696655
## 171 3.498471 135.2955666
## 172 3.498471 266.2741212
## 173 3.498471 0.0000000
## 174 3.498471 0.0000000
## 175 5.993555 148.2471738
## 176 5.993555 0.7941611
## 177 5.993555 48.3045977
## 178 5.993555 99.1484150
## 179 5.993555 0.0000000
## 180 5.993555 0.0000000
## 181 4.253231 500.4373785
## 182 4.253231 71.9148959
## 183 4.253231 78.0855764
## 184 4.253231 350.4369061
## 185 4.253231 0.0000000
## 186 4.253231 0.0000000
## 187 9.073444 591.0276124
## 188 9.073444 71.4406387
## 189 9.073444 225.5548745
## 190 9.073444 294.0320992
## 191 9.073444 0.0000000
## 192 9.073444 0.0000000
## 193 1.528101 3.3160610
## 194 1.528101 0.0000000
## 195 1.528101 0.0000000
## 196 1.528101 3.3160610
## 197 1.528101 0.0000000
## 198 1.528101 0.0000000
## 199 3.490931 465.3204013
## 200 3.490931 55.6276577
## 201 3.490931 145.1926357
## 202 3.490931 264.5001079
## 203 3.490931 0.0000000
## 204 3.490931 0.0000000
## 205 6.926940 146.1236790
## 206 6.926940 0.5431135
## 207 6.926940 53.9788655
## 208 6.926940 91.6017000
## 209 6.926940 0.0000000
## 210 6.926940 0.0000000
## 211 4.231792 466.8026686
## 212 4.231792 64.7323774
## 213 4.231792 66.6488962
## 214 4.231792 335.4213950
## 215 4.231792 0.0000000
## 216 4.231792 0.0000000
## 217 9.018871 579.4420422
## 218 9.018871 70.7029144
## 219 9.018871 216.0162966
## 220 9.018871 292.7228312
## 221 9.018871 0.0000000
## 222 9.018871 0.0000000
## 223 1.499577 3.3571860
## 224 1.499577 0.0000000
## 225 1.499577 0.0000000
## 226 1.499577 3.3571860
## 227 1.499577 0.0000000
## 228 1.499577 0.0000000
## 229 3.405265 474.7494210
## 230 3.405265 50.8352230
## 231 3.405265 150.9134060
## 232 3.405265 273.0007921
## 233 3.405265 0.0000000
## 234 3.405265 0.0000000
## 235 8.036502 143.6672367
## 236 8.036502 0.4529062
## 237 8.036502 50.2089515
## 238 8.036502 93.0053790
## 239 8.036502 0.0000000
## 240 8.036502 0.0000000bd_6_filter <- bd_6 %>% filter(year>=2010 & year<=2017) %>% filter(country=="Mexico"|country=="Venezuela"|country=="Canada"|country=="Haiti"|country=="Brazil")
bd_6_filter## iso_code country year coal_prod_change_pct coal_prod_change_twh
## 1 BRA Brazil 2010 -10.217 -3.617
## 2 BRA Brazil 2011 0.081 0.026
## 3 BRA Brazil 2012 6.716 2.136
## 4 BRA Brazil 2013 24.205 8.217
## 5 BRA Brazil 2014 -0.802 -0.338
## 6 BRA Brazil 2015 -19.190 -8.026
## 7 BRA Brazil 2016 -7.848 -2.653
## 8 BRA Brazil 2017 -18.682 -5.819
## 9 CAN Canada 2010 6.883 26.532
## 10 CAN Canada 2011 0.107 0.441
## 11 CAN Canada 2012 0.185 0.764
## 12 CAN Canada 2013 1.716 7.092
## 13 CAN Canada 2014 -0.637 -2.678
## 14 CAN Canada 2015 -9.891 -41.306
## 15 CAN Canada 2016 1.138 4.281
## 16 CAN Canada 2017 -3.499 -13.316
## 17 HTI Haiti 2010 NA 0.000
## 18 HTI Haiti 2011 NA 0.000
## 19 HTI Haiti 2012 NA 0.000
## 20 HTI Haiti 2013 NA 0.000
## 21 HTI Haiti 2014 NA 0.000
## 22 HTI Haiti 2015 NA 0.000
## 23 HTI Haiti 2016 NA 0.000
## 24 HTI Haiti 2017 NA NA
## 25 MEX Mexico 2010 20.348 14.394
## 26 MEX Mexico 2011 27.993 23.832
## 27 MEX Mexico 2012 -20.770 -22.632
## 28 MEX Mexico 2013 -3.516 -3.036
## 29 MEX Mexico 2014 1.285 1.070
## 30 MEX Mexico 2015 -5.282 -4.456
## 31 MEX Mexico 2016 -11.652 -9.312
## 32 MEX Mexico 2017 21.275 15.021
## 33 VEN Venezuela 2010 -19.751 -5.497
## 34 VEN Venezuela 2011 -0.737 -0.165
## 35 VEN Venezuela 2012 -26.829 -5.948
## 36 VEN Venezuela 2013 -35.665 -5.786
## 37 VEN Venezuela 2014 -34.871 -3.639
## 38 VEN Venezuela 2015 0.132 0.009
## 39 VEN Venezuela 2016 -49.242 -3.352
## 40 VEN Venezuela 2017 -2.473 -0.085
## gas_prod_change_pct gas_prod_change_twh oil_prod_change_pct
## 1 22.348 27.436 5.284
## 2 14.689 22.064 2.318
## 3 15.127 26.059 -1.668
## 4 10.673 21.167 -1.996
## 5 6.370 13.981 11.613
## 6 1.957 4.568 7.952
## 7 1.340 3.191 3.032
## 8 12.676 30.578 4.491
## 9 -3.521 -54.598 4.627
## 10 0.990 14.803 5.662
## 11 -0.507 -7.661 7.253
## 12 1.075 16.152 6.818
## 13 4.655 70.713 7.570
## 14 1.110 17.641 3.613
## 15 6.873 110.486 1.390
## 16 2.210 37.973 8.419
## 17 NA 0.000 NA
## 18 NA 0.000 NA
## 19 NA 0.000 NA
## 20 NA 0.000 NA
## 21 NA 0.000 NA
## 22 NA 0.000 NA
## 23 NA 0.000 NA
## 24 NA NA NA
## 25 -2.672 -14.052 -0.725
## 26 1.800 9.212 -0.743
## 27 -2.397 -12.488 -0.458
## 28 3.221 16.379 -1.398
## 29 -2.264 -11.882 -3.347
## 30 -6.536 -33.529 -6.990
## 31 -8.959 -42.955 -4.834
## 32 -12.332 -53.830 -9.789
## 33 -4.228 -13.442 -6.434
## 34 -0.707 -2.153 -2.968
## 35 5.518 16.683 -1.542
## 36 -4.119 -13.142 -1.108
## 37 3.915 11.977 0.529
## 38 13.454 42.768 -2.271
## 39 3.254 11.737 -10.587
## 40 3.670 13.667 -11.112
## oil_prod_change_twh energy_cons_change_pct energy_cons_change_twh
## 1 64.837 10.049 278.543
## 2 29.952 4.566 139.287
## 3 -22.054 1.790 57.099
## 4 -25.945 3.783 122.839
## 5 147.940 2.234 75.273
## 6 113.067 -1.355 -46.679
## 7 46.531 -2.574 -87.473
## 8 71.021 1.218 40.328
## 9 85.112 2.125 75.179
## 10 108.974 4.603 166.290
## 11 147.481 -1.005 -37.964
## 12 148.705 3.069 114.810
## 13 176.345 1.082 41.715
## 14 90.549 -0.273 -10.643
## 15 36.088 -0.407 -15.826
## 16 221.641 1.240 48.001
## 17 0.000 -7.254 -0.710
## 18 0.000 2.193 0.199
## 19 0.000 13.303 1.235
## 20 0.000 5.153 0.542
## 21 0.000 7.738 0.856
## 22 0.000 4.133 0.493
## 23 0.000 23.563 2.924
## 24 NA NA NA
## 25 -12.350 2.926 57.723
## 26 -12.563 4.804 97.525
## 27 -7.678 0.594 12.644
## 28 -23.357 0.425 9.097
## 29 -55.129 -0.531 -11.424
## 30 -111.265 -0.115 -2.467
## 31 -71.577 1.263 26.978
## 32 -137.927 1.412 30.534
## 33 -116.431 -5.711 -56.007
## 34 -50.256 4.560 42.168
## 35 -25.333 4.100 39.640
## 36 -17.922 -2.477 -24.932
## 37 8.462 -3.359 -32.974
## 38 -36.531 -3.519 -33.384
## 39 -166.400 -9.263 -84.768
## 40 -156.159 -4.490 -37.281
## biofuel_share_elec biofuel_elec_per_capita biofuel_cons_change_pct
## 1 6.215 160.924 6.592
## 2 6.200 164.210 -8.789
## 3 6.566 178.863 -5.430
## 4 7.287 202.760 17.553
## 5 8.081 230.258 10.350
## 6 8.695 241.823 18.543
## 7 8.968 247.067 -9.155
## 8 9.090 252.793 4.962
## 9 1.564 268.303 2.822
## 10 1.508 268.624 56.227
## 11 1.595 281.198 17.185
## 12 1.559 282.772 12.452
## 13 1.393 248.598 5.557
## 14 1.447 256.807 -2.446
## 15 1.512 268.367 1.301
## 16 1.784 313.351 3.555
## 17 0.000 0.000 NA
## 18 0.000 0.000 NA
## 19 0.000 0.000 NA
## 20 0.000 0.000 NA
## 21 0.000 0.000 NA
## 22 0.000 0.000 NA
## 23 0.000 0.000 NA
## 24 0.000 0.000 NA
## 25 0.297 6.801 4.444
## 26 0.255 6.318 -7.447
## 27 0.402 9.977 15.517
## 28 0.470 11.125 0.000
## 29 0.500 11.882 54.726
## 30 0.465 11.234 6.109
## 31 0.506 12.438 6.061
## 32 0.709 17.343 5.714
## 33 0.000 0.000 NA
## 34 0.000 0.000 NA
## 35 0.000 0.000 NA
## 36 0.000 0.000 NA
## 37 0.000 0.000 NA
## 38 0.000 0.000 NA
## 39 0.000 0.000 NA
## 40 0.000 0.000 NA
## biofuel_share_energy biofuel_cons_change_twh biofuel_consumption
## 1 5.479 10.336 167.131
## 2 4.779 -14.689 152.441
## 3 4.440 -8.277 144.164
## 4 5.029 25.305 169.469
## 5 5.429 17.541 187.010
## 6 6.524 34.678 221.688
## 7 6.083 -20.295 201.393
## 8 6.308 9.993 211.387
## 9 0.271 0.269 9.806
## 10 0.405 5.513 15.319
## 11 0.480 2.633 17.952
## 12 0.524 2.235 20.187
## 13 0.547 1.122 21.309
## 14 0.535 -0.521 20.788
## 15 0.544 0.270 21.058
## 16 0.556 0.749 21.807
## 17 NA NA NA
## 18 NA NA NA
## 19 NA NA NA
## 20 NA NA NA
## 21 NA NA NA
## 22 NA NA NA
## 23 NA NA NA
## 24 NA NA NA
## 25 0.058 0.050 1.174
## 26 0.051 -0.087 1.086
## 27 0.059 0.169 1.255
## 28 0.058 0.000 1.255
## 29 0.091 0.687 1.942
## 30 0.096 0.119 2.060
## 31 0.101 0.125 2.185
## 32 0.105 0.125 2.310
## 33 0.000 0.000 0.000
## 34 0.000 0.000 0.000
## 35 0.000 0.000 0.000
## 36 0.000 0.000 0.000
## 37 0.000 0.000 0.000
## 38 0.000 0.000 0.000
## 39 0.000 0.000 0.000
## 40 0.000 0.000 0.000
## biofuel_cons_per_capita carbon_intensity_elec coal_share_elec
## 1 853.953 NA 2.166
## 2 771.797 NA 2.356
## 3 723.401 NA 2.566
## 4 842.980 NA 3.765
## 5 922.303 NA 4.466
## 6 1084.197 NA 4.545
## 7 976.863 NA 4.324
## 8 1017.093 NA 4.191
## 9 287.152 NA 12.882
## 10 443.531 NA 11.241
## 11 514.050 NA 9.909
## 12 571.920 NA 9.634
## 13 597.490 NA 9.609
## 14 577.001 NA 9.023
## 15 578.787 NA 9.109
## 16 593.671 NA 8.533
## 17 NA NA 0.000
## 18 NA NA 0.000
## 19 NA NA 0.000
## 20 NA NA 0.000
## 21 NA NA 0.000
## 22 NA NA 0.000
## 23 NA NA 0.000
## 24 NA NA 0.000
## 25 10.287 NA 11.660
## 26 9.389 NA 11.588
## 27 10.700 NA 11.542
## 28 10.560 NA 10.603
## 29 16.132 NA 11.001
## 30 16.907 NA 10.789
## 31 17.717 NA 10.677
## 32 18.512 NA 9.342
## 33 0.000 NA 0.000
## 34 0.000 NA 0.000
## 35 0.000 NA 0.000
## 36 0.000 NA 0.000
## 37 0.000 NA 0.000
## 38 0.000 NA 0.000
## 39 0.000 NA 0.000
## 40 0.000 NA 0.000
## coal_cons_change_pct coal_share_energy coal_cons_change_twh coal_consumption
## 1 30.177 5.514 38.991 168.198
## 2 6.821 5.633 11.472 179.670
## 3 -1.043 5.476 -1.873 177.797
## 4 7.788 5.687 13.847 191.644
## 5 6.326 5.915 12.123 203.767
## 6 0.594 6.032 1.211 204.978
## 7 -9.675 5.592 -19.831 185.147
## 8 5.469 5.827 10.125 195.272
## 9 5.451 7.972 14.889 288.024
## 10 -10.430 6.826 -30.041 257.983
## 11 -4.976 6.553 -12.837 245.146
## 12 -1.476 6.264 -3.618 241.528
## 13 -5.483 5.857 -13.244 228.284
## 14 1.314 5.950 2.999 231.283
## 15 -6.062 5.612 -14.020 217.263
## 16 -0.358 5.524 -0.779 216.484
## 17 NA NA NA NA
## 18 NA NA NA NA
## 19 NA NA NA NA
## 20 NA NA NA NA
## 21 NA NA NA NA
## 22 NA NA NA NA
## 23 NA NA NA NA
## 24 NA NA NA NA
## 25 23.694 7.296 28.372 148.119
## 26 15.669 8.052 23.208 171.327
## 27 -12.877 6.974 -22.061 149.266
## 28 -0.696 6.896 -1.039 148.227
## 29 -0.194 6.919 -0.288 147.939
## 30 -0.195 6.914 -0.288 147.651
## 31 -2.043 6.688 -3.017 144.633
## 32 22.208 8.059 32.120 176.753
## 33 -16.000 0.251 -0.441 2.318
## 34 2.930 0.247 0.068 2.386
## 35 2.847 0.244 0.068 2.454
## 36 -0.346 0.249 -0.008 2.445
## 37 -6.250 0.242 -0.153 2.292
## 38 -30.740 0.173 -0.705 1.588
## 39 -9.626 0.173 -0.153 1.435
## 40 2.942 0.186 0.042 1.477
## coal_elec_per_capita coal_cons_per_capita coal_production
## 1 56.073 859.406 31.786
## 2 62.400 909.652 31.811
## 3 69.915 892.163 33.948
## 4 104.764 953.280 42.165
## 5 127.255 1004.944 41.827
## 6 126.416 1002.474 33.801
## 7 119.133 898.059 31.148
## 8 116.538 939.555 25.329
## 9 2209.920 8434.574 412.009
## 10 2002.035 7469.324 412.451
## 11 1747.299 7019.824 413.214
## 12 1747.834 6842.742 420.306
## 13 1714.476 6400.971 417.629
## 14 1601.691 6419.715 376.323
## 15 1617.007 5971.543 380.604
## 16 1498.927 5893.602 367.288
## 17 0.000 NA 0.000
## 18 0.000 NA 0.000
## 19 0.000 NA 0.000
## 20 0.000 NA 0.000
## 21 0.000 NA 0.000
## 22 0.000 NA 0.000
## 23 0.000 NA 0.000
## 24 0.000 NA NA
## 25 266.891 1298.229 85.136
## 26 286.946 1480.852 108.967
## 27 286.291 1272.798 86.335
## 28 251.226 1247.416 83.299
## 29 261.504 1229.188 84.369
## 30 260.642 1211.661 79.913
## 31 262.214 1172.707 70.601
## 32 228.419 1416.551 85.622
## 33 0.000 81.497 22.335
## 34 0.000 82.584 22.171
## 35 0.000 83.567 16.223
## 36 0.000 82.103 10.437
## 37 0.000 76.301 6.797
## 38 0.000 52.777 6.806
## 39 0.000 48.066 3.455
## 40 0.000 50.235 3.369
## coal_prod_per_capita electricity_generation biofuel_electricity
## 1 162.409 506.748 31.495
## 2 161.058 523.120 32.434
## 3 170.347 542.895 35.645
## 4 209.739 559.372 40.762
## 5 206.284 577.739 46.688
## 6 165.306 568.688 49.446
## 7 151.083 567.965 50.936
## 8 121.870 577.962 52.539
## 9 12065.399 585.804 9.162
## 10 11941.591 615.165 9.278
## 11 11832.498 615.806 9.820
## 12 11907.710 640.339 9.981
## 13 11710.098 636.321 8.866
## 14 10445.569 639.504 9.252
## 15 10461.037 645.838 9.764
## 16 9999.131 645.224 11.510
## 17 0.000 0.561 0.000
## 18 0.000 0.653 0.000
## 19 0.000 1.047 0.000
## 20 0.000 1.001 0.000
## 21 0.000 0.977 0.000
## 22 0.000 0.983 0.000
## 23 0.000 1.024 0.000
## 24 NA 0.999 0.000
## 25 746.194 261.151 0.776
## 26 941.850 286.478 0.731
## 27 736.181 290.897 1.170
## 28 701.013 281.548 1.322
## 29 701.005 286.083 1.430
## 30 655.788 294.393 1.369
## 31 572.446 302.900 1.534
## 32 686.203 305.103 2.164
## 33 785.352 110.780 0.000
## 34 767.476 115.069 0.000
## 35 552.519 118.488 0.000
## 36 350.449 120.023 0.000
## 37 226.254 100.333 0.000
## 38 226.259 119.181 0.000
## 39 115.734 104.654 0.000
## 40 114.595 100.581 0.000
## coal_electricity fossil_electricity gas_electricity hydro_electricity
## 1 10.974 60.045 34.293 399.256
## 2 12.325 49.134 23.517 424.050
## 3 13.933 75.834 44.158 411.189
## 4 21.061 110.298 65.139 387.082
## 5 25.803 134.657 76.654 369.705
## 6 25.849 127.515 74.979 356.146
## 7 24.561 91.381 53.096 377.102
## 8 24.221 100.169 61.657 367.197
## 9 75.464 131.376 46.072 347.871
## 10 69.148 132.414 54.116 371.967
## 11 61.019 125.640 55.647 376.465
## 12 61.693 123.663 52.733 387.871
## 13 61.145 123.523 57.712 378.676
## 14 57.704 126.528 63.711 378.372
## 15 58.832 124.034 60.146 381.578
## 16 55.059 112.996 53.875 390.641
## 17 0.000 0.385 0.000 0.175
## 18 0.000 0.532 0.000 0.120
## 19 0.000 0.826 0.000 0.219
## 20 0.000 0.859 0.000 0.140
## 21 0.000 0.886 0.000 0.089
## 22 0.000 0.898 0.000 0.082
## 23 0.000 0.952 0.000 0.070
## 24 0.000 0.872 0.000 0.126
## 25 30.450 210.431 135.155 36.790
## 26 33.198 232.639 149.091 35.928
## 27 33.575 240.481 150.689 31.587
## 28 29.852 231.091 155.668 27.722
## 29 31.473 224.518 162.162 38.549
## 30 31.761 236.538 175.135 30.614
## 31 32.340 245.129 180.498 29.744
## 32 28.501 243.988 178.784 31.739
## 33 0.000 34.766 34.766 76.012
## 34 0.000 32.234 32.234 82.833
## 35 0.000 37.266 37.266 81.188
## 36 0.000 37.238 37.238 82.710
## 37 0.000 36.612 36.612 63.645
## 38 0.000 44.953 44.953 74.150
## 39 0.000 42.247 42.247 62.329
## 40 0.000 40.601 40.601 59.902
## nuclear_electricity oil_electricity other_renewable_electricity
## 1 13.774 14.778 31.495
## 2 14.795 13.292 32.434
## 3 15.170 17.742 35.645
## 4 14.645 24.098 40.762
## 5 14.463 32.200 46.688
## 6 13.892 26.687 49.446
## 7 14.970 13.725 50.936
## 8 14.854 14.292 52.539
## 9 85.501 9.840 12.166
## 10 88.318 9.150 11.814
## 11 89.060 8.974 12.571
## 12 96.971 9.236 12.437
## 13 98.588 4.666 11.120
## 14 95.637 5.112 9.404
## 15 95.650 5.056 9.961
## 16 95.131 4.063 11.719
## 17 0.000 0.385 0.000
## 18 0.000 0.532 0.000
## 19 0.000 0.826 0.000
## 20 0.000 0.859 0.000
## 21 0.000 0.886 0.000
## 22 0.000 0.898 0.000
## 23 0.000 0.952 0.000
## 24 0.000 0.872 0.000
## 25 5.592 44.825 7.070
## 26 9.313 50.350 6.923
## 27 8.412 56.217 6.681
## 28 11.377 45.570 7.084
## 29 9.312 30.882 7.132
## 30 11.185 29.641 7.364
## 31 10.272 32.292 7.356
## 32 10.572 36.703 7.817
## 33 0.000 0.000 0.000
## 34 0.000 0.000 0.000
## 35 0.000 0.000 0.000
## 36 0.000 0.000 0.000
## 37 0.000 0.000 0.000
## 38 0.000 0.000 0.000
## 39 0.000 0.000 0.000
## 40 0.000 0.000 0.000
## other_renewable_exc_biofuel_electricity renewables_electricity
## 1 0.000 432.929
## 2 0.000 459.191
## 3 0.000 451.891
## 4 0.000 434.429
## 5 0.000 428.619
## 6 0.000 427.281
## 7 0.000 461.613
## 8 0.000 462.938
## 9 3.004 368.927
## 10 2.536 394.433
## 11 2.751 401.106
## 12 2.456 419.705
## 13 2.254 414.210
## 14 0.152 417.339
## 15 0.197 426.154
## 16 0.209 437.096
## 17 0.000 0.176
## 18 0.000 0.121
## 19 0.000 0.221
## 20 0.000 0.142
## 21 0.000 0.091
## 22 0.000 0.085
## 23 0.000 0.071
## 24 0.000 0.127
## 25 6.294 45.128
## 26 6.192 44.526
## 27 5.511 42.004
## 28 5.762 39.080
## 29 5.702 52.253
## 30 5.995 46.670
## 31 5.822 47.499
## 32 5.653 50.543
## 33 0.000 76.014
## 34 0.000 82.835
## 35 0.000 81.222
## 36 0.000 82.785
## 37 0.000 63.721
## 38 0.000 74.228
## 39 0.000 62.407
## 40 0.000 59.980
## solar_electricity wind_electricity energy_per_gdp energy_per_capita
## 1 0.001 2.177 1.147 15585.781
## 2 0.002 2.705 1.074 16148.863
## 3 0.007 5.050 1.097 16291.789
## 4 0.005 6.580 1.108 16761.084
## 5 0.016 12.210 1.133 16989.477
## 6 0.059 21.630 1.069 16619.270
## 7 0.085 33.490 1.178 16058.664
## 8 0.832 42.370 NA 16123.593
## 9 0.253 8.637 2.599 105801.799
## 10 0.566 10.086 2.588 109418.617
## 11 0.872 11.198 2.580 107131.488
## 12 1.484 17.913 2.605 109245.998
## 13 2.099 22.315 2.548 109291.465
## 14 2.866 26.697 2.524 107894.862
## 15 3.992 30.623 2.466 106404.161
## 16 3.538 31.198 NA 106699.981
## 17 0.001 0.000 0.578 913.041
## 18 0.001 0.000 0.583 919.112
## 19 0.002 0.000 0.671 1026.039
## 20 0.002 0.000 0.681 1063.350
## 21 0.002 0.000 0.717 1129.559
## 22 0.003 0.000 0.734 1160.083
## 23 0.001 0.000 0.894 1414.389
## 24 0.001 0.000 NA NA
## 25 0.031 1.237 1.277 17794.833
## 26 0.041 1.634 1.237 18391.381
## 27 0.069 3.667 1.230 18251.570
## 28 0.106 4.168 1.214 18089.592
## 29 0.221 6.351 1.181 17765.011
## 30 0.239 8.453 1.148 17525.650
## 31 0.464 9.935 1.150 17534.790
## 32 1.074 9.913 NA 17576.573
## 33 0.002 0.000 2.064 32512.027
## 34 0.002 0.000 1.937 33467.535
## 35 0.004 0.030 1.985 34278.464
## 36 0.004 0.071 1.804 32957.863
## 37 0.005 0.071 1.842 31572.890
## 38 0.007 0.071 1.895 30422.200
## 39 0.007 0.071 2.097 27817.912
## 40 0.007 0.071 NA 26974.738
## fossil_cons_change_pct fossil_share_energy fossil_cons_change_twh
## 1 14.266 55.891 212.851
## 2 5.289 56.277 90.170
## 3 5.084 58.099 91.267
## 4 8.030 60.476 151.465
## 5 3.908 61.466 79.634
## 6 -3.273 60.271 -69.304
## 7 -7.330 57.328 -150.134
## 8 1.832 57.676 34.764
## 9 5.113 66.482 116.840
## 10 3.875 66.020 93.085
## 11 -2.139 65.263 -53.358
## 12 2.765 65.071 67.521
## 13 2.383 65.909 59.789
## 14 -1.014 65.419 -26.054
## 15 -1.173 64.916 -29.836
## 16 1.257 64.927 31.601
## 17 NA NA NA
## 18 NA NA NA
## 19 NA NA NA
## 20 NA NA NA
## 21 NA NA NA
## 22 NA NA NA
## 23 NA NA NA
## 24 NA NA NA
## 25 2.258 93.296 41.822
## 26 4.696 93.200 88.944
## 27 1.221 93.780 24.208
## 28 0.463 93.815 9.289
## 29 -1.940 92.487 -39.112
## 30 0.359 92.926 7.094
## 31 1.357 93.012 26.923
## 32 1.177 92.797 23.675
## 33 -4.063 78.382 -30.697
## 34 3.664 77.710 26.554
## 35 5.936 79.080 44.596
## 36 -3.510 78.243 -27.938
## 37 -2.584 78.871 -19.844
## 38 -2.495 79.708 -18.665
## 39 -7.437 81.312 -54.251
## 40 -4.497 81.306 -30.361
## fossil_fuel_consumption fossil_energy_per_capita fossil_cons_per_capita
## 1 1704.874 8711.048 306.801
## 2 1795.044 9088.141 248.760
## 3 1886.311 9465.298 380.524
## 4 2037.776 10136.376 548.647
## 5 2117.411 10442.735 664.106
## 6 2048.107 10016.564 623.629
## 7 1897.973 9206.175 443.247
## 8 1932.736 9299.423 481.967
## 9 2401.931 70338.846 3847.261
## 10 2495.016 72237.650 3833.754
## 11 2441.658 69917.476 3597.744
## 12 2509.179 71087.591 3503.489
## 13 2568.967 72032.509 3463.509
## 14 2542.913 70583.538 3512.026
## 15 2513.077 69072.841 3409.118
## 16 2544.678 69276.878 3076.240
## 17 NA NA 38.738
## 18 NA NA 52.677
## 19 NA NA 80.603
## 20 NA NA 82.604
## 21 NA NA 84.029
## 22 NA NA 83.929
## 23 NA NA 87.843
## 24 NA NA 79.432
## 25 1894.152 16601.827 1844.383
## 26 1983.096 17140.726 2010.793
## 27 2007.305 17116.365 2050.592
## 28 2016.594 16970.836 1944.765
## 29 1977.481 16430.404 1865.465
## 30 1984.575 16285.966 1941.094
## 31 2011.499 16309.492 1987.541
## 32 2035.174 16310.487 1955.395
## 33 724.756 25483.673 1222.430
## 34 751.310 26007.680 1115.811
## 35 795.905 27107.572 1269.245
## 36 767.967 25787.158 1250.398
## 37 748.124 24901.763 1218.655
## 38 729.458 24248.996 1494.338
## 39 675.207 22619.237 1415.275
## 40 644.846 21932.029 1380.907
## fossil_share_elec gas_share_elec gas_cons_change_pct gas_share_energy
## 1 11.849 6.767 33.423 9.041
## 2 9.392 4.495 -0.339 8.616
## 3 13.968 8.134 18.532 10.034
## 4 19.718 11.645 17.823 11.391
## 5 23.308 13.268 5.921 11.802
## 6 22.423 13.185 5.611 12.635
## 7 16.089 9.348 -13.622 11.202
## 8 17.331 10.668 1.467 11.230
## 9 22.427 7.865 1.981 24.435
## 10 21.525 8.797 10.478 25.807
## 11 20.403 9.036 -0.329 25.983
## 12 19.312 8.235 7.256 27.039
## 13 19.412 9.070 5.111 28.117
## 14 19.785 9.963 0.146 28.235
## 15 19.205 9.313 -3.250 27.429
## 16 17.513 8.350 2.953 27.893
## 17 68.662 0.000 NA NA
## 18 81.484 0.000 NA NA
## 19 78.897 0.000 NA NA
## 20 85.816 0.000 NA NA
## 21 90.690 0.000 NA NA
## 22 91.335 0.000 NA NA
## 23 93.035 0.000 NA NA
## 24 87.315 0.000 NA NA
## 25 80.578 51.754 1.344 32.530
## 26 81.207 52.043 7.213 33.278
## 27 82.669 51.802 4.018 34.411
## 28 82.079 55.290 5.623 36.192
## 29 78.480 56.684 1.354 36.878
## 30 80.348 59.490 2.453 37.826
## 31 80.927 59.590 2.782 38.393
## 32 79.969 58.598 3.617 39.228
## 33 31.383 31.383 -8.622 33.815
## 34 28.012 28.012 6.587 34.470
## 35 31.451 31.451 3.860 34.391
## 36 31.026 31.026 -6.665 32.914
## 37 36.491 36.491 5.327 35.872
## 38 37.718 37.718 8.851 40.472
## 39 40.368 40.368 0.541 44.845
## 40 40.367 40.367 3.670 48.676
## gas_cons_change_twh gas_consumption gas_elec_per_capita
## 1 69.082 275.768 175.220
## 2 -0.934 274.834 119.062
## 3 50.931 325.766 221.581
## 4 58.062 383.828 324.016
## 5 22.727 406.555 378.048
## 6 22.811 429.366 366.695
## 7 -58.487 370.879 257.542
## 8 5.441 376.321 296.664
## 9 17.148 882.810 1349.186
## 10 92.503 975.313 1566.802
## 11 -3.213 972.100 1593.467
## 12 70.539 1042.639 1493.979
## 13 53.289 1095.928 1618.214
## 14 1.603 1097.531 1768.431
## 15 -35.667 1061.864 1653.144
## 16 31.355 1093.219 1466.706
## 17 NA NA 0.000
## 18 NA NA 0.000
## 19 NA NA 0.000
## 20 NA NA 0.000
## 21 NA NA 0.000
## 22 NA NA 0.000
## 23 NA NA 0.000
## 24 NA NA 0.000
## 25 8.757 660.446 1184.607
## 26 47.640 708.085 1288.655
## 27 28.453 736.538 1284.935
## 28 41.413 777.951 1310.041
## 29 10.534 788.485 1347.368
## 30 19.345 807.830 1437.207
## 31 22.471 830.301 1463.498
## 32 30.035 860.336 1432.829
## 33 -29.500 312.668 1222.430
## 34 20.596 333.264 1115.811
## 35 12.864 346.129 1269.245
## 36 -23.070 323.058 1250.398
## 37 17.208 340.266 1218.655
## 38 30.116 370.383 1494.338
## 39 2.005 372.388 1415.275
## 40 13.667 386.054 1380.907
## gas_energy_per_capita gas_production gas_prod_per_capita hydro_share_elec
## 1 1409.036 150.206 767.475 78.788
## 2 1391.461 172.270 872.186 81.062
## 3 1634.655 198.329 995.191 75.740
## 4 1909.250 219.496 1091.825 69.199
## 5 2005.065 233.477 1151.471 63.992
## 6 2099.876 238.045 1164.194 62.626
## 7 1798.961 241.236 1170.122 66.395
## 8 1810.679 271.814 1307.844 63.533
## 9 25852.457 1495.912 43806.722 59.383
## 10 28238.014 1510.714 43739.380 60.466
## 11 27836.322 1503.053 43040.296 61.134
## 12 29539.028 1519.205 43040.619 60.573
## 13 30729.261 1589.917 44580.453 59.510
## 14 30464.135 1607.558 44620.924 59.167
## 15 29185.728 1718.044 47221.061 59.083
## 16 29762.036 1756.017 47806.181 60.544
## 17 NA 0.000 0.000 31.178
## 18 NA 0.000 0.000 18.378
## 19 NA 0.000 0.000 20.912
## 20 NA 0.000 0.000 13.984
## 21 NA 0.000 0.000 9.106
## 22 NA 0.000 0.000 8.360
## 23 NA 0.000 0.000 6.868
## 24 NA NA NA 12.585
## 25 5788.663 511.779 4485.627 14.088
## 26 6120.277 520.990 4503.136 12.541
## 27 6280.491 508.502 4336.019 10.858
## 28 6546.924 524.881 4417.185 9.846
## 29 6551.328 512.998 4262.377 13.475
## 30 6629.272 479.470 3934.660 10.399
## 31 6732.189 436.515 3539.317 9.820
## 32 6894.989 382.685 3066.949 10.403
## 33 10993.967 304.518 10707.371 68.615
## 34 11536.423 302.364 10466.777 71.986
## 35 11788.719 319.048 10866.372 68.520
## 36 10847.798 305.905 10271.822 68.912
## 37 11325.975 317.882 10580.903 63.434
## 38 12312.434 360.650 11988.910 62.216
## 39 12474.880 372.388 12474.880 59.557
## 40 13130.202 386.054 13130.202 59.556
## hydro_cons_change_pct hydro_share_energy hydro_cons_change_twh
## 1 2.514 34.472 25.782
## 2 5.562 34.800 58.487
## 3 -3.621 32.951 -40.188
## 4 -6.430 29.708 -68.787
## 5 -5.061 27.588 -50.665
## 6 -4.241 26.781 -40.305
## 7 5.258 28.934 47.849
## 8 -3.199 27.671 -30.646
## 9 -5.278 25.359 -51.048
## 10 6.275 25.764 57.487
## 11 0.596 26.180 5.802
## 12 2.409 26.013 23.598
## 13 -2.955 24.974 -29.642
## 14 -0.675 24.873 -6.574
## 15 0.251 25.038 2.425
## 16 1.773 25.170 17.186
## 17 NA NA NA
## 18 NA NA NA
## 19 NA NA NA
## 20 NA NA NA
## 21 NA NA NA
## 22 NA NA NA
## 23 NA NA NA
## 24 NA NA NA
## 25 38.201 4.772 26.780
## 26 -2.984 4.417 -2.891
## 27 -12.553 3.840 -11.799
## 28 -12.717 3.338 -10.453
## 29 37.966 4.629 27.237
## 30 -21.045 3.659 -20.830
## 31 -1.217 3.570 -0.951
## 32 3.137 3.630 2.422
## 33 -11.242 21.617 -25.316
## 34 7.811 22.289 15.613
## 35 -2.302 20.918 -4.961
## 36 1.428 21.756 3.006
## 37 -6.150 21.127 -13.134
## 38 -7.348 20.289 -14.727
## 39 -16.435 18.685 -30.516
## 40 -4.460 18.691 -6.920
## hydro_consumption hydro_elec_per_capita hydro_energy_per_capita
## 1 1051.523 2039.997 5372.755
## 2 1110.010 2146.925 5619.877
## 3 1069.822 2063.301 5368.246
## 4 1001.035 1925.436 4979.380
## 5 950.370 1823.327 4687.073
## 6 910.064 1741.784 4450.802
## 7 957.913 1829.145 4646.386
## 8 927.267 1766.780 4461.575
## 9 916.188 10187.156 26829.920
## 10 973.675 10769.478 28190.598
## 11 979.477 10780.167 28047.556
## 12 1003.075 10988.781 28418.130
## 13 973.432 10617.878 27294.539
## 14 966.859 10502.456 26837.059
## 15 969.284 10487.810 26641.110
## 16 986.469 10634.896 26855.855
## 17 NA 17.590 NA
## 18 NA 11.881 NA
## 19 NA 21.364 NA
## 20 NA 13.460 NA
## 21 NA 8.437 NA
## 22 NA 7.682 NA
## 23 NA 6.484 NA
## 24 NA 11.449 NA
## 25 96.884 322.456 849.170
## 26 93.994 310.541 812.425
## 27 82.194 269.344 700.874
## 28 71.741 233.297 603.747
## 29 98.979 320.294 822.389
## 30 78.148 251.227 641.306
## 31 77.198 241.168 625.928
## 32 79.619 254.366 638.092
## 33 199.880 2672.714 7028.128
## 34 215.493 2867.384 7459.587
## 35 210.531 2765.165 7170.434
## 36 213.537 2777.274 7170.245
## 37 200.404 2118.464 6670.556
## 38 185.677 2464.929 6172.359
## 39 155.160 2088.004 5197.830
## 40 148.241 2037.342 5041.858
## low_carbon_share_elec low_carbon_electricity low_carbon_elec_per_capita
## 1 88.151 446.703 2282.427
## 2 90.608 473.986 2399.747
## 3 86.032 467.061 2343.660
## 4 80.282 449.074 2233.799
## 5 76.692 443.082 2185.210
## 6 77.577 441.173 2157.621
## 7 83.911 476.583 2311.683
## 8 82.669 477.792 2298.913
## 9 77.573 454.428 13307.602
## 10 78.475 482.751 13976.983
## 11 79.597 490.166 14036.023
## 12 80.688 516.676 14637.964
## 13 80.588 512.798 14378.589
## 14 80.215 512.976 14238.654
## 15 80.795 521.804 14341.978
## 16 82.487 532.227 14489.470
## 17 31.338 0.176 17.680
## 18 18.516 0.121 11.970
## 19 21.103 0.221 21.559
## 20 14.184 0.142 13.653
## 21 9.310 0.091 8.626
## 22 8.665 0.085 7.963
## 23 6.965 0.071 6.577
## 24 12.685 0.127 11.540
## 25 19.422 50.720 444.550
## 26 18.793 53.839 465.353
## 27 17.331 50.416 429.899
## 28 17.921 50.457 424.627
## 29 21.520 61.565 511.528
## 30 19.652 57.855 474.774
## 31 19.073 57.771 468.415
## 32 20.031 61.115 489.793
## 33 68.617 76.014 2672.785
## 34 71.988 82.835 2867.454
## 35 68.549 81.222 2766.323
## 36 68.974 82.785 2779.792
## 37 63.509 63.721 2120.993
## 38 62.282 74.228 2467.522
## 39 59.632 62.407 2090.617
## 40 59.633 59.980 2039.995
## low_carbon_cons_change_pct low_carbon_share_energy
## 1 5.133 44.109
## 2 3.651 43.723
## 3 -2.450 41.901
## 4 -2.104 39.524
## 5 -0.327 38.534
## 6 1.704 39.729
## 7 4.641 42.672
## 8 0.394 42.324
## 9 -3.326 33.518
## 10 6.045 33.980
## 11 1.199 34.737
## 12 3.639 34.929
## 13 -1.342 34.091
## 14 1.160 34.581
## 15 1.042 35.084
## 16 1.207 35.073
## 17 NA NA
## 18 NA NA
## 19 NA NA
## 20 NA NA
## 21 NA NA
## 22 NA NA
## 23 NA NA
## 24 NA NA
## 25 13.228 6.704
## 26 6.304 6.800
## 27 -7.992 6.220
## 28 -0.144 6.185
## 29 20.828 7.513
## 30 -5.952 7.074
## 31 0.036 6.988
## 32 4.539 7.203
## 33 -11.239 21.618
## 34 7.811 22.290
## 35 -2.300 20.920
## 36 1.428 21.757
## 37 -6.148 21.129
## 38 -7.344 20.292
## 39 -16.433 18.688
## 40 -4.459 18.694
## low_carbon_cons_change_twh low_carbon_consumption
## 1 65.692 1345.482
## 2 49.117 1394.599
## 3 -34.168 1360.431
## 4 -28.626 1331.805
## 5 -4.361 1327.444
## 6 22.625 1350.069
## 7 62.661 1412.730
## 8 5.565 1418.295
## 9 -41.662 1210.989
## 10 73.204 1284.193
## 11 15.394 1299.588
## 12 47.290 1346.877
## 13 -18.074 1328.803
## 14 15.412 1344.215
## 15 14.010 1358.225
## 16 16.400 1374.625
## 17 NA NA
## 18 NA NA
## 19 NA NA
## 20 NA NA
## 21 NA NA
## 22 NA NA
## 23 NA NA
## 24 NA NA
## 25 15.902 136.114
## 26 8.581 144.695
## 27 -11.565 133.130
## 28 -0.192 132.938
## 29 27.688 160.627
## 30 -9.561 151.065
## 31 0.054 151.120
## 32 6.859 157.978
## 33 -25.309 199.886
## 34 15.614 215.500
## 35 -4.956 210.545
## 36 3.006 213.551
## 37 -13.130 200.421
## 38 -14.718 185.702
## 39 -30.517 155.186
## 40 -6.920 148.266
## low_carbon_energy_per_capita nuclear_share_elec nuclear_cons_change_pct
## 1 6874.733 2.718 11.400
## 2 7060.722 2.828 7.166
## 3 6826.491 2.794 1.800
## 4 6624.708 2.618 -4.251
## 5 6546.743 2.503 -1.057
## 6 6602.707 2.443 -4.760
## 7 6852.489 2.636 7.033
## 8 6824.170 2.570 -1.372
## 9 35462.953 14.595 0.012
## 10 37180.966 14.357 2.603
## 11 37214.012 14.462 0.746
## 12 38158.407 15.144 8.385
## 13 37258.956 15.493 3.092
## 14 37311.323 14.955 -5.665
## 15 37331.320 14.810 -0.963
## 16 37423.103 14.744 -0.715
## 17 NA 0.000 NA
## 18 NA 0.000 NA
## 19 NA 0.000 NA
## 20 NA 0.000 NA
## 21 NA 0.000 NA
## 22 NA 0.000 NA
## 23 NA 0.000 NA
## 24 NA 0.000 NA
## 25 1193.006 2.141 -44.356
## 26 1250.655 3.251 70.561
## 27 1135.204 2.892 -13.606
## 28 1118.756 4.041 33.744
## 29 1334.606 3.255 -18.480
## 30 1239.684 3.799 18.921
## 31 1225.297 3.391 -9.264
## 32 1266.085 3.465 2.382
## 33 7028.353 0.000 NA
## 34 7459.855 0.000 NA
## 35 7170.892 0.000 NA
## 36 7170.705 0.000 NA
## 37 6671.128 0.000 NA
## 38 6173.204 0.000 NA
## 39 5198.675 0.000 NA
## 40 5042.709 0.000 NA
## nuclear_share_energy nuclear_cons_change_twh nuclear_consumption
## 1 1.241 3.875 37.867
## 2 1.272 2.714 40.581
## 3 1.272 0.730 41.311
## 4 1.174 -1.756 39.555
## 5 1.136 -0.418 39.137
## 6 1.097 -1.863 37.274
## 7 1.205 2.622 39.896
## 8 1.174 -0.548 39.348
## 9 6.497 0.028 234.736
## 10 6.373 6.110 240.846
## 11 6.486 1.797 242.643
## 12 6.820 20.346 262.989
## 13 6.956 8.132 271.121
## 14 6.580 -15.360 255.761
## 15 6.543 -2.462 253.299
## 16 6.417 -1.812 251.487
## 17 NA NA NA
## 18 NA NA NA
## 19 NA NA NA
## 20 NA NA NA
## 21 NA NA NA
## 22 NA NA NA
## 23 NA NA NA
## 24 NA NA NA
## 25 0.755 -12.220 15.329
## 26 1.229 10.816 26.146
## 27 1.055 -3.557 22.588
## 28 1.405 7.622 30.211
## 29 1.152 -5.583 24.628
## 30 1.371 4.660 29.287
## 31 1.229 -2.713 26.574
## 32 1.241 0.633 27.207
## 33 0.000 0.000 0.000
## 34 0.000 0.000 0.000
## 35 0.000 0.000 0.000
## 36 0.000 0.000 0.000
## 37 0.000 0.000 0.000
## 38 0.000 0.000 0.000
## 39 0.000 0.000 0.000
## 40 0.000 0.000 0.000
## nuclear_elec_per_capita nuclear_energy_per_capita oil_share_elec
## 1 70.378 193.482 2.916
## 2 74.906 205.456 2.541
## 3 76.121 207.294 3.268
## 4 72.848 196.756 4.308
## 5 71.329 193.017 5.573
## 6 67.941 182.294 4.693
## 7 72.615 193.515 2.416
## 8 71.472 189.324 2.473
## 9 2503.836 6874.070 1.680
## 10 2557.051 6973.159 1.487
## 11 2550.255 6948.143 1.457
## 12 2747.294 7450.756 1.442
## 13 2764.356 7602.093 0.733
## 14 2654.592 7099.155 0.799
## 15 2628.980 6962.013 0.783
## 16 2589.873 6846.540 0.630
## 17 0.000 NA 68.662
## 18 0.000 NA 81.484
## 19 0.000 NA 78.897
## 20 0.000 NA 85.816
## 21 0.000 NA 90.690
## 22 0.000 NA 91.335
## 23 0.000 NA 93.035
## 24 0.000 NA 87.315
## 25 49.013 134.358 17.165
## 26 80.496 225.989 17.575
## 27 71.729 192.612 19.325
## 28 95.745 254.240 16.186
## 29 77.371 204.625 10.795
## 30 91.787 240.341 10.069
## 31 83.287 215.468 10.661
## 32 84.727 218.046 12.030
## 33 0.000 0.000 0.000
## 34 0.000 0.000 0.000
## 35 0.000 0.000 0.000
## 36 0.000 0.000 0.000
## 37 0.000 0.000 0.000
## 38 0.000 0.000 0.000
## 39 0.000 0.000 0.000
## 40 0.000 0.000 0.000
## oil_cons_change_pct oil_share_energy oil_cons_change_twh oil_consumption
## 1 9.063 41.336 104.779 1260.908
## 2 6.315 42.028 79.632 1340.540
## 3 3.149 42.589 42.209 1382.749
## 4 5.753 43.397 79.556 1462.305
## 5 3.063 43.749 44.784 1507.089
## 6 -6.192 41.604 -93.326 1413.763
## 7 -5.080 40.534 -71.816 1341.947
## 8 1.431 40.619 19.197 1361.144
## 9 7.398 34.075 84.804 1231.097
## 10 2.487 33.386 30.623 1261.720
## 11 -2.957 32.727 -37.309 1224.412
## 12 0.049 31.769 0.600 1225.011
## 13 1.612 31.935 19.743 1244.755
## 14 -2.463 31.234 -30.656 1214.099
## 15 1.635 31.874 19.851 1233.950
## 16 0.083 31.510 1.025 1234.975
## 17 NA NA NA NA
## 18 NA NA NA NA
## 19 NA NA NA NA
## 20 NA NA NA NA
## 21 NA NA NA NA
## 22 NA NA NA NA
## 23 NA NA NA NA
## 24 NA NA NA NA
## 25 0.434 53.470 4.692 1085.587
## 26 1.667 51.870 18.096 1103.684
## 27 1.614 52.396 17.817 1121.500
## 28 -2.772 50.728 -31.085 1090.415
## 29 -4.527 48.691 -49.358 1041.057
## 30 -1.149 48.187 -11.962 1029.095
## 31 0.726 47.931 7.469 1036.564
## 32 -3.712 45.509 -38.479 998.085
## 33 -0.184 44.317 -0.756 409.769
## 34 1.438 42.993 5.891 415.660
## 35 7.618 44.446 31.663 447.323
## 36 -1.086 45.080 -4.859 442.464
## 37 -8.339 42.757 -36.899 405.565
## 38 -11.854 39.063 -48.077 357.488
## 39 -15.694 36.294 -56.104 301.384
## 40 -14.623 32.444 -44.070 257.314
## oil_elec_per_capita oil_energy_per_capita oil_production oil_prod_per_capita
## 1 75.509 6442.606 1291.944 6601.183
## 2 67.298 6787.028 1321.896 6692.636
## 3 89.029 6938.480 1299.842 6522.464
## 4 119.867 7273.845 1273.897 6336.660
## 5 158.804 7432.725 1421.837 7012.276
## 6 130.519 6914.214 1534.904 7506.670
## 7 66.572 6509.155 1581.435 7670.797
## 8 68.765 6549.189 1652.455 7950.842
## 9 288.155 36051.814 1924.492 56357.396
## 10 264.917 36530.312 2033.466 58874.501
## 11 256.978 35061.330 2180.947 62451.960
## 12 261.676 34705.821 2329.653 66001.434
## 13 130.819 34902.277 2505.998 70266.873
## 14 141.904 33699.689 2596.547 72072.249
## 15 138.967 33915.569 2632.635 72358.943
## 16 110.607 33621.239 2854.276 77705.435
## 17 38.738 NA 0.000 0.000
## 18 52.677 NA 0.000 0.000
## 19 80.603 NA 0.000 0.000
## 20 82.604 NA 0.000 0.000
## 21 84.029 NA 0.000 0.000
## 22 83.929 NA 0.000 0.000
## 23 87.843 NA 0.000 0.000
## 24 79.432 NA NA NA
## 25 392.885 9514.934 1690.585 14817.606
## 26 435.193 9539.596 1678.022 14503.843
## 27 479.366 9563.076 1670.344 14243.090
## 28 383.498 9176.496 1646.987 13860.376
## 29 256.593 8649.888 1591.858 13226.352
## 30 243.245 8445.033 1480.593 12150.149
## 31 261.829 8404.597 1409.016 11424.485
## 32 294.146 7998.948 1271.089 10186.885
## 33 0.000 14408.210 1693.308 59539.676
## 34 0.000 14388.673 1643.052 56876.637
## 35 0.000 15235.286 1617.719 55097.555
## 36 0.000 14857.257 1599.797 53718.711
## 37 0.000 13499.487 1608.259 53531.918
## 38 0.000 11883.784 1571.729 52248.142
## 39 0.000 10096.291 1405.329 47078.125
## 40 0.000 8751.592 1249.170 42485.902
## other_renewables_elec_per_capita other_renewables_share_elec
## 1 160.924 6.215
## 2 164.210 6.200
## 3 178.863 6.566
## 4 202.760 7.287
## 5 230.258 8.081
## 6 241.823 8.695
## 7 247.067 8.968
## 8 252.793 9.090
## 9 356.273 2.077
## 10 342.048 1.920
## 11 359.974 2.041
## 12 352.353 1.942
## 13 311.799 1.748
## 14 261.026 1.471
## 15 273.782 1.542
## 16 319.041 1.816
## 17 0.000 0.000
## 18 0.000 0.000
## 19 0.000 0.000
## 20 0.000 0.000
## 21 0.000 0.000
## 22 0.000 0.000
## 23 0.000 0.000
## 24 0.000 0.000
## 25 61.967 2.707
## 26 59.838 2.417
## 27 56.969 2.297
## 28 59.616 2.516
## 29 59.258 2.493
## 30 60.431 2.501
## 31 59.643 2.429
## 32 62.648 2.562
## 33 0.000 0.000
## 34 0.000 0.000
## 35 0.000 0.000
## 36 0.000 0.000
## 37 0.000 0.000
## 38 0.000 0.000
## 39 0.000 0.000
## 40 0.000 0.000
## other_renewables_cons_change_pct other_renewables_share_energy
## 1 38.777 2.730
## 2 1.527 2.651
## 3 8.949 2.837
## 4 13.866 3.113
## 5 14.218 3.478
## 6 5.319 3.713
## 7 2.307 3.899
## 8 2.466 3.947
## 9 14.452 0.743
## 10 -1.418 0.700
## 11 6.206 0.751
## 12 0.507 0.733
## 13 -11.771 0.640
## 14 1.353 0.650
## 15 13.068 0.738
## 16 -5.043 0.692
## 17 NA NA
## 18 NA NA
## 19 NA NA
## 20 NA NA
## 21 NA NA
## 22 NA NA
## 23 NA NA
## 24 NA NA
## 25 -1.944 0.956
## 26 -1.666 0.897
## 27 -8.782 0.814
## 28 7.650 0.872
## 29 -3.119 0.849
## 30 3.645 0.881
## 31 -2.096 0.852
## 32 4.866 0.881
## 33 NA 0.000
## 34 NA 0.000
## 35 NA 0.000
## 36 NA 0.000
## 37 NA 0.000
## 38 NA 0.000
## 39 NA 0.000
## 40 NA 0.000
## other_renewables_cons_change_twh other_renewable_consumption
## 1 23.271 83.285
## 2 1.272 84.557
## 3 7.567 92.124
## 4 12.774 104.898
## 5 14.915 119.812
## 6 6.373 126.185
## 7 2.911 129.096
## 8 3.184 132.280
## 9 3.390 26.849
## 10 -0.381 26.469
## 11 1.643 28.111
## 12 0.142 28.254
## 13 -3.326 24.928
## 14 0.337 25.265
## 15 3.302 28.567
## 16 -1.441 27.126
## 17 NA NA
## 18 NA NA
## 19 NA NA
## 20 NA NA
## 21 NA NA
## 22 NA NA
## 23 NA NA
## 24 NA NA
## 25 -0.385 19.415
## 26 -0.323 19.091
## 27 -1.677 17.415
## 28 1.332 18.747
## 29 -0.585 18.162
## 30 0.662 18.824
## 31 -0.395 18.430
## 32 0.897 19.326
## 33 0.000 0.000
## 34 0.000 0.000
## 35 0.000 0.000
## 36 0.000 0.000
## 37 0.000 0.000
## 38 0.000 0.000
## 39 0.000 0.000
## 40 0.000 0.000
## other_renewables_energy_per_capita per_capita_electricity population
## 1 425.546 2589.229 195714000
## 2 428.104 2648.507 197515008
## 3 462.267 2724.184 199287008
## 4 521.787 2782.446 201036000
## 5 590.896 2849.317 202764000
## 6 617.128 2781.250 204472000
## 7 626.185 2754.930 206163008
## 8 636.471 2780.881 207834000
## 9 786.268 17154.864 34148000
## 10 766.342 17810.737 34539000
## 11 804.976 17633.767 34922000
## 12 800.460 18141.453 35297000
## 13 698.969 17842.098 35664000
## 14 701.285 17750.680 36027000
## 15 785.171 17751.096 36383000
## 16 738.490 17565.710 36732000
## 17 NA 56.418 9949000
## 18 NA 64.648 10100000
## 19 NA 102.162 10251000
## 20 NA 96.256 10401000
## 21 NA 92.655 10549000
## 22 NA 91.891 10696000
## 23 NA 94.420 10840000
## 24 NA 90.972 10982000
## 25 170.164 2288.933 114093000
## 26 165.013 2476.146 115695000
## 27 148.494 2480.491 117274000
## 28 157.765 2369.392 118827000
## 29 150.904 2376.994 120355000
## 30 154.476 2415.868 121858000
## 31 149.429 2455.956 123333000
## 32 154.887 2445.188 124777000
## 33 0.000 3895.214 28440000
## 34 0.000 3983.264 28888000
## 35 0.000 4035.568 29361000
## 36 0.000 4030.190 29781000
## 37 0.000 3339.649 30043000
## 38 0.000 3961.860 30082000
## 39 0.000 3505.891 29851000
## 40 0.000 3420.902 29402000
## primary_energy_consumption renewables_elec_per_capita renewables_share_elec
## 1 3050.355 2212.049 85.433
## 2 3189.643 2324.841 87.779
## 3 3246.742 2267.539 83.237
## 4 3369.581 2160.951 77.664
## 5 3444.854 2113.881 74.189
## 6 3398.175 2089.680 75.135
## 7 3310.703 2239.068 81.275
## 8 3351.031 2227.441 80.098
## 9 3612.920 10803.766 62.978
## 10 3779.210 11419.931 64.118
## 11 3741.246 11485.768 65.135
## 12 3856.056 11890.671 65.544
## 13 3897.771 11614.233 65.095
## 14 3887.128 11584.062 65.260
## 15 3871.303 11712.998 65.985
## 16 3919.304 11899.597 67.743
## 17 9.084 17.680 31.338
## 18 9.283 11.970 18.516
## 19 10.518 21.559 21.103
## 20 11.060 13.653 14.184
## 21 11.916 8.626 9.310
## 22 12.408 7.963 8.665
## 23 15.332 6.577 6.965
## 24 NA 11.540 12.685
## 25 2030.266 395.537 17.280
## 26 2127.791 384.857 15.543
## 27 2140.435 358.170 14.439
## 28 2149.532 328.881 13.880
## 29 2138.108 434.157 18.265
## 30 2135.641 382.987 15.853
## 31 2162.618 385.128 15.681
## 32 2193.152 405.067 16.566
## 33 924.642 2672.785 68.617
## 34 966.810 2867.454 71.988
## 35 1006.450 2766.323 68.549
## 36 981.518 2779.792 68.974
## 37 948.544 2120.993 63.509
## 38 915.161 2467.522 62.282
## 39 830.392 2090.617 59.632
## 40 793.111 2039.995 59.633
## renewables_cons_change_pct renewables_share_energy
## 1 4.962 42.868
## 2 3.549 42.450
## 3 -2.577 40.629
## 4 -2.037 38.350
## 5 -0.305 37.398
## 6 1.901 38.632
## 7 4.573 41.467
## 8 0.445 41.150
## 9 -4.095 27.021
## 10 6.873 27.608
## 11 1.303 28.251
## 12 2.549 28.109
## 13 -2.418 27.136
## 14 2.909 28.001
## 15 1.513 28.541
## 16 1.648 28.657
## 17 NA NA
## 18 NA NA
## 19 NA NA
## 20 NA NA
## 21 NA NA
## 22 NA NA
## 23 NA NA
## 24 NA NA
## 25 30.348 5.949
## 26 -1.851 5.571
## 27 -6.754 5.164
## 28 -7.069 4.779
## 29 32.388 6.361
## 30 -10.457 5.702
## 31 2.272 5.759
## 32 4.999 5.963
## 33 -11.239 21.618
## 34 7.811 22.290
## 35 -2.300 20.920
## 36 1.428 21.757
## 37 -6.148 21.129
## 38 -7.344 20.292
## 39 -16.433 18.688
## 40 -4.459 18.694
## renewables_cons_change_twh renewables_consumption
## 1 61.817 1307.614
## 2 46.403 1354.018
## 3 -34.898 1319.120
## 4 -26.870 1292.250
## 5 -3.943 1288.307
## 6 24.488 1312.795
## 7 60.040 1372.834
## 8 6.112 1378.947
## 9 -41.690 976.253
## 10 67.094 1043.347
## 11 13.597 1056.945
## 12 26.943 1083.888
## 13 -26.206 1057.682
## 14 30.771 1088.454
## 15 16.473 1104.927
## 16 18.212 1123.138
## 17 NA NA
## 18 NA NA
## 19 NA NA
## 20 NA NA
## 21 NA NA
## 22 NA NA
## 23 NA NA
## 24 NA NA
## 25 28.122 120.784
## 26 -2.236 118.549
## 27 -8.007 110.542
## 28 -7.814 102.728
## 29 33.271 135.999
## 30 -14.221 121.778
## 31 2.767 124.545
## 32 6.226 130.771
## 33 -25.309 199.886
## 34 15.614 215.500
## 35 -4.956 210.545
## 36 3.006 213.551
## 37 -13.130 200.421
## 38 -14.718 185.702
## 39 -30.517 155.186
## 40 -6.920 148.266
## renewables_energy_per_capita solar_share_elec solar_cons_change_pct
## 1 6681.251 0.000 NA
## 2 6855.265 0.000 NA
## 3 6619.196 0.001 NA
## 4 6427.952 0.001 386.196
## 5 6353.726 0.003 233.476
## 6 6420.413 0.010 264.181
## 7 6658.975 0.015 43.856
## 8 6634.846 0.144 869.874
## 9 28588.883 0.043 131.144
## 10 30207.807 0.092 123.491
## 11 30265.870 0.142 53.195
## 12 30707.651 0.232 69.100
## 13 29656.863 0.330 40.586
## 14 30212.169 0.448 35.757
## 15 30369.308 0.618 12.344
## 16 30576.563 0.548 8.804
## 17 NA 0.160 NA
## 18 NA 0.138 NA
## 19 NA 0.191 NA
## 20 NA 0.200 NA
## 21 NA 0.205 NA
## 22 NA 0.305 NA
## 23 NA 0.098 NA
## 24 NA 0.100 NA
## 25 1058.648 0.012 14.111
## 26 1024.666 0.014 31.451
## 27 942.592 0.024 67.273
## 28 864.516 0.038 52.698
## 29 1129.981 0.077 107.242
## 30 999.343 0.081 10.650
## 31 1009.830 0.153 1.944
## 32 1048.039 0.352 367.554
## 33 7028.353 0.002 NA
## 34 7459.855 0.002 20.399
## 35 7170.892 0.003 74.106
## 36 7170.705 0.003 1.822
## 37 6671.128 0.005 25.435
## 38 6173.204 0.006 29.414
## 39 5198.675 0.007 13.560
## 40 5042.709 0.007 -0.860
## solar_share_energy solar_cons_change_twh solar_consumption
## 1 0.000 0.000 0.000
## 2 0.000 0.000 0.000
## 3 0.000 0.003 0.003
## 4 0.000 0.010 0.012
## 5 0.001 0.029 0.041
## 6 0.004 0.108 0.149
## 7 0.006 0.065 0.214
## 8 0.062 1.865 2.080
## 9 0.018 0.376 0.663
## 10 0.039 0.818 1.481
## 11 0.061 0.788 2.269
## 12 0.100 1.568 3.837
## 13 0.138 1.557 5.395
## 14 0.188 1.929 7.324
## 15 0.213 0.904 8.228
## 16 0.228 0.724 8.952
## 17 NA NA NA
## 18 NA NA NA
## 19 NA NA NA
## 20 NA NA NA
## 21 NA NA NA
## 22 NA NA NA
## 23 NA NA NA
## 24 NA NA NA
## 25 0.004 0.010 0.081
## 26 0.005 0.025 0.106
## 27 0.008 0.071 0.178
## 28 0.013 0.094 0.271
## 29 0.026 0.291 0.562
## 30 0.029 0.060 0.622
## 31 0.029 0.012 0.634
## 32 0.135 2.332 2.966
## 33 0.001 0.006 0.006
## 34 0.001 0.001 0.008
## 35 0.001 0.006 0.013
## 36 0.001 0.000 0.014
## 37 0.002 0.003 0.017
## 38 0.002 0.005 0.022
## 39 0.003 0.003 0.025
## 40 0.003 0.000 0.025
## solar_elec_per_capita solar_energy_per_capita gdp wind_share_elec
## 1 0.005 0.000 2.660000e+12 0.430
## 2 0.010 0.000 2.970000e+12 0.517
## 3 0.035 0.013 2.960000e+12 0.930
## 4 0.025 0.061 3.040000e+12 1.176
## 5 0.079 0.202 3.040000e+12 2.113
## 6 0.289 0.729 3.180000e+12 3.803
## 7 0.412 1.040 2.810000e+12 5.896
## 8 4.003 10.006 NA 7.331
## 9 7.409 19.409 1.390000e+12 1.474
## 10 16.387 42.887 1.460000e+12 1.640
## 11 24.970 64.980 1.450000e+12 1.818
## 12 42.043 108.714 1.480000e+12 2.797
## 13 58.855 151.265 1.530000e+12 3.507
## 14 79.551 203.283 1.540000e+12 4.175
## 15 109.722 226.141 1.570000e+12 4.742
## 16 96.319 243.712 NA 4.835
## 17 0.090 NA 1.570513e+10 0.000
## 18 0.089 NA 1.593616e+10 0.000
## 19 0.195 NA 1.566880e+10 0.000
## 20 0.192 NA 1.625224e+10 0.000
## 21 0.190 NA 1.662778e+10 0.000
## 22 0.280 NA 1.690885e+10 0.000
## 23 0.092 NA 1.715510e+10 0.000
## 24 0.091 NA NA 0.000
## 25 0.272 0.708 1.590000e+12 0.474
## 26 0.354 0.918 1.720000e+12 0.570
## 27 0.588 1.515 1.740000e+12 1.261
## 28 0.892 2.284 1.770000e+12 1.480
## 29 1.836 4.673 1.810000e+12 2.220
## 30 1.961 5.107 1.860000e+12 2.871
## 31 3.762 5.144 1.880000e+12 3.280
## 32 8.607 23.773 NA 3.249
## 33 0.070 0.226 4.480000e+11 0.000
## 34 0.069 0.267 4.990000e+11 0.000
## 35 0.136 0.458 5.070000e+11 0.025
## 36 0.134 0.460 5.440000e+11 0.059
## 37 0.166 0.572 5.150000e+11 0.071
## 38 0.233 0.739 4.830000e+11 0.060
## 39 0.234 0.845 3.960000e+11 0.068
## 40 0.238 0.851 NA 0.071
## wind_cons_change_pct wind_share_energy wind_cons_change_twh wind_consumption
## 1 74.734 0.186 2.427 5.675
## 2 23.510 0.220 1.334 7.009
## 3 85.576 0.401 5.998 13.008
## 4 29.431 0.500 3.828 16.836
## 5 84.571 0.902 14.238 31.074
## 6 76.057 1.610 23.634 54.708
## 7 53.940 2.544 29.510 84.218
## 8 25.785 3.161 21.716 105.933
## 9 30.550 0.630 5.323 22.747
## 10 16.073 0.699 3.656 26.403
## 11 10.348 0.779 2.732 29.136
## 12 -2.061 0.740 -0.601 28.535
## 13 14.310 0.837 4.083 32.618
## 14 109.142 1.755 35.600 68.219
## 15 14.031 2.009 9.572 77.790
## 16 1.277 2.010 0.994 78.784
## 17 NA NA NA NA
## 18 NA NA NA NA
## 19 NA NA NA NA
## 20 NA NA NA NA
## 21 NA NA NA NA
## 22 NA NA NA NA
## 23 NA NA NA NA
## 24 NA NA NA NA
## 25 106.507 0.159 1.666 3.231
## 26 32.213 0.201 1.041 4.272
## 27 122.405 0.444 5.229 9.500
## 28 12.771 0.498 1.213 10.713
## 29 52.650 0.765 5.641 16.354
## 30 35.275 1.036 5.769 22.123
## 31 17.971 1.207 3.976 26.099
## 32 1.727 1.211 0.451 26.549
## 33 NA 0.000 0.000 0.000
## 34 NA 0.000 0.000 0.000
## 35 NA 0.000 0.000 0.000
## 36 NA 0.000 0.000 0.000
## 37 NA 0.000 0.000 0.000
## 38 NA 0.000 0.003 0.003
## 39 -100.000 0.000 -0.003 0.000
## 40 NA 0.000 0.000 0.000
## wind_elec_per_capita wind_energy_per_capita
## 1 11.123 28.997
## 2 13.695 35.488
## 3 25.340 65.271
## 4 32.730 83.745
## 5 60.218 153.252
## 6 105.785 267.557
## 7 162.444 408.500
## 8 203.865 509.701
## 9 252.928 666.134
## 10 292.018 764.450
## 11 320.657 834.307
## 12 507.494 808.427
## 13 625.701 914.601
## 14 741.028 1893.541
## 15 841.684 2138.099
## 16 849.341 2144.836
## 17 0.000 NA
## 18 0.000 NA
## 19 0.000 NA
## 20 0.000 NA
## 21 0.000 NA
## 22 0.000 NA
## 23 0.000 NA
## 24 0.000 NA
## 25 10.842 28.317
## 26 14.123 36.921
## 27 31.269 81.009
## 28 35.076 90.160
## 29 52.769 135.882
## 30 69.368 181.548
## 31 80.554 211.612
## 32 79.446 212.775
## 33 0.000 0.000
## 34 0.000 0.000
## 35 1.022 0.000
## 36 2.384 0.000
## 37 2.363 0.000
## 38 2.360 0.106
## 39 2.378 0.000
## 40 2.415 0.000bd_7_filter <- bd_7 %>% filter(Year>=2010 & Year<=2017) %>% filter(Entity=="Mexico"|Entity=="Venezuela"|Entity=="Canada"|Entity=="Haiti"|Entity=="Brazil")
bd_7_filter## # A tibble: 40 × 11
## Entity Code Year Electric…¹ Elect…² Elect…³ Elect…⁴ Elect…⁵ Elect…⁶ Elect…⁷
## <chr> <chr> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 Brazil BRA 2010 11.0 34.3 399. 31.5 0.001 14.8 2.18
## 2 Brazil BRA 2011 12.3 23.5 424. 32.4 0.002 13.3 2.70
## 3 Brazil BRA 2012 13.9 44.2 411. 35.6 0.007 17.7 5.05
## 4 Brazil BRA 2013 21.1 65.1 387. 40.8 0.005 24.1 6.58
## 5 Brazil BRA 2014 25.8 76.7 370. 46.7 0.016 32.2 12.2
## 6 Brazil BRA 2015 25.8 75.0 356. 49.4 0.059 26.7 21.6
## 7 Brazil BRA 2016 24.6 53.1 377. 50.9 0.085 13.7 33.5
## 8 Brazil BRA 2017 24.2 61.7 367. 52.5 0.832 14.3 42.4
## 9 Canada CAN 2010 75.5 46.1 348. 12.2 0.253 9.84 8.64
## 10 Canada CAN 2011 69.1 54.1 372. 11.8 0.566 9.15 10.1
## # … with 30 more rows, 1 more variable: `Electricity from nuclear (TWh)` <dbl>,
## # and abbreviated variable names ¹`Electricity from coal (TWh)`,
## # ²`Electricity from gas (TWh)`, ³`Electricity from hydro (TWh)`,
## # ⁴`Electricity from other renewables (TWh)`,
## # ⁵`Electricity from solar (TWh)`, ⁶`Electricity from oil (TWh)`,
## # ⁷`Electricity from wind (TWh)`#EXCEL 5
#Table of population of countries during the 7 years
population_5 <- group_by(bd_5_filter,Year,Country,Population)%>% distinct(Population)
population_5## # A tibble: 40 × 3
## # Groups: Year, Country, Population [40]
## Year Country Population
## <int> <chr> <dbl>
## 1 2010 Brazil 195942.
## 2 2010 Canada 34005.
## 3 2010 Haiti 9949.
## 4 2010 Mexico 114292.
## 5 2010 Venezuela 28440.
## 6 2011 Brazil 197752.
## 7 2011 Canada 34339.
## 8 2011 Haiti 10100.
## 9 2011 Mexico 115876.
## 10 2011 Venezuela 28888.
## # … with 30 more rows#Population graph
ggplot(data = population_5, aes(x = Year, y = Population, fill = Country)) +
geom_bar(stat = "identity", position="dodge") +
labs(title = "POPULATION", x = "Country", y = "Population") +
theme(axis.text.x = element_text(angle = 90, vjust = 0.5))
#Graph of consumption of all energies. #Only 4 Countries
consumption_5 <- group_by(bd_5_filter,Year,Country,Energy_type,Energy_consumption)%>%
filter(Energy_type == "all_energy_types", Country!="Haiti")
consumption_5## # A tibble: 32 × 11
## # Groups: Year, Country, Energy_type, Energy_consumption [32]
## X Country Energy_…¹ Year Energ…² Energ…³ GDP Popul…⁴ Energ…⁵ Energ…⁶
## <int> <chr> <chr> <int> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 41736 Brazil all_ener… 2010 11.4 10.1 2847. 195942. 58.3 4.01
## 2 41796 Canada all_ener… 2010 13.8 18.3 1434. 34005. 406. 9.62
## 3 42378 Mexico all_ener… 2010 7.53 8.86 1927. 114292. 65.9 3.91
## 4 42924 Venezuela all_ener… 2010 3.11 7.26 508. 28440. 109. 6.12
## 5 43122 Brazil all_ener… 2011 11.9 10.5 2963. 197752. 60.1 4.01
## 6 43182 Canada all_ener… 2011 14.2 18.7 1479. 34339. 412. 9.57
## 7 43764 Mexico all_ener… 2011 7.74 8.90 1998. 115876. 66.8 3.87
## 8 44310 Venezuela all_ener… 2011 3.14 7.55 529. 28888. 109. 5.92
## 9 44508 Brazil all_ener… 2012 12.2 10.3 3011. 199528. 61.2 4.05
## 10 44568 Canada all_ener… 2012 14.3 19.1 1505. 34714. 412. 9.51
## # … with 22 more rows, 1 more variable: CO2_emission <dbl>, and abbreviated
## # variable names ¹Energy_type, ²Energy_consumption, ³Energy_production,
## # ⁴Population, ⁵Energy_intensity_per_capita, ⁶Energy_intensity_by_GDPggplot(data = consumption_5, aes(x = Year, y =Energy_consumption , fill = Country)) +
geom_bar(stat = "identity", position="dodge") +
labs(title = "ENERGY CONSUMPTION", x = "Country", y = "Consumption") +
theme(axis.text.x = element_text(angle = 90, vjust = 0.5))
#Graph of production of all energies. #Only 4 Countries
production_5 <- group_by(bd_5_filter,Year,Country,Energy_type,Energy_production)%>%
filter(Energy_type == "all_energy_types", Country!="Haiti")
production_5## # A tibble: 32 × 11
## # Groups: Year, Country, Energy_type, Energy_production [32]
## X Country Energy_…¹ Year Energ…² Energ…³ GDP Popul…⁴ Energ…⁵ Energ…⁶
## <int> <chr> <chr> <int> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 41736 Brazil all_ener… 2010 11.4 10.1 2847. 195942. 58.3 4.01
## 2 41796 Canada all_ener… 2010 13.8 18.3 1434. 34005. 406. 9.62
## 3 42378 Mexico all_ener… 2010 7.53 8.86 1927. 114292. 65.9 3.91
## 4 42924 Venezuela all_ener… 2010 3.11 7.26 508. 28440. 109. 6.12
## 5 43122 Brazil all_ener… 2011 11.9 10.5 2963. 197752. 60.1 4.01
## 6 43182 Canada all_ener… 2011 14.2 18.7 1479. 34339. 412. 9.57
## 7 43764 Mexico all_ener… 2011 7.74 8.90 1998. 115876. 66.8 3.87
## 8 44310 Venezuela all_ener… 2011 3.14 7.55 529. 28888. 109. 5.92
## 9 44508 Brazil all_ener… 2012 12.2 10.3 3011. 199528. 61.2 4.05
## 10 44568 Canada all_ener… 2012 14.3 19.1 1505. 34714. 412. 9.51
## # … with 22 more rows, 1 more variable: CO2_emission <dbl>, and abbreviated
## # variable names ¹Energy_type, ²Energy_consumption, ³Energy_production,
## # ⁴Population, ⁵Energy_intensity_per_capita, ⁶Energy_intensity_by_GDPggplot(data = production_5, aes(x = Year, y =Energy_production , fill = Country)) +
geom_bar(stat = "identity", position="dodge") +
labs(title = "ENERGY PRODUCTION", x = "Country", y = "Production") +
theme(axis.text.x = element_text(angle = 90, vjust = 0.5))
#Haiti #Production and Consumption
pro_cons_hai_5 <- group_by(bd_5_filter,Year,Country,Energy_type,Energy_production, Energy_consumption)%>%
filter(Energy_type =="all_energy_types", Country=="Haiti") %>% select(Year,Country,Energy_type,Energy_production, Energy_consumption)
pro_cons_hai_5## # A tibble: 8 × 5
## # Groups: Year, Country, Energy_type, Energy_production, Energy_consumption
## # [8]
## Year Country Energy_type Energy_production Energy_consumption
## <int> <chr> <chr> <dbl> <dbl>
## 1 2010 Haiti all_energy_types 0.00172 0.0310
## 2 2011 Haiti all_energy_types 0.00117 0.0326
## 3 2012 Haiti all_energy_types 0.00210 0.0358
## 4 2013 Haiti all_energy_types 0.00135 0.0377
## 5 2014 Haiti all_energy_types 0.000865 0.0406
## 6 2015 Haiti all_energy_types 0.000784 0.0463
## 7 2016 Haiti all_energy_types 0.000667 0.0481
## 8 2017 Haiti all_energy_types 0.00119 0.0477ggplot(pro_cons_hai_5, aes(x = Year)) +
geom_line(aes(y = Energy_production, color = "Production", lwd=0.5)) +
geom_line(aes(y = Energy_consumption, color = "Consumption", lwd=0.5)) +
labs(title = "PRODUCTION AND CONSUMPTION BY HAITI", x = "YEAR", y = "ALL_ENERGY") 
#Production and Consumption depends on energy_type #Canada
type_can_5 <- group_by(bd_5_filter,Year,Country,Energy_type,Energy_production, Energy_consumption)%>%
filter(Energy_type !="all_energy_types", Country=="Canada") %>% select(Year,Country,Energy_type,Energy_production, Energy_consumption)
type_can_5## # A tibble: 40 × 5
## # Groups: Year, Country, Energy_type, Energy_production, Energy_consumption
## # [40]
## Year Country Energy_type Energy_production Energy_consumption
## <int> <chr> <chr> <dbl> <dbl>
## 1 2010 Canada coal 1.44 0.951
## 2 2010 Canada natural_gas 5.57 3.55
## 3 2010 Canada petroleum_n_other_liquids 6.68 4.80
## 4 2010 Canada nuclear 0.965 0.965
## 5 2010 Canada renewables_n_other 3.64 3.52
## 6 2011 Canada coal 1.42 0.895
## 7 2011 Canada natural_gas 5.40 3.68
## 8 2011 Canada petroleum_n_other_liquids 7.01 4.85
## 9 2011 Canada nuclear 0.997 0.997
## 10 2011 Canada renewables_n_other 3.88 3.73
## # … with 30 more rowsggplot(type_can_5, aes(x = Year)) +
geom_line(aes(y = Energy_production, color = Energy_type)) +
labs(title = "Production & Energy Type of Canada", x = "Year", y = "Energy") 
ggplot(type_can_5, aes(x = Year)) +
geom_line(aes(y = Energy_consumption, color = Energy_type)) +
labs(title = "Consumption & Energy Type of Canada", x = "Year", y = "Energy") 
#Mexico
type_mex_5 <- group_by(bd_5_filter,Year,Country,Energy_type,Energy_production, Energy_consumption)%>%
filter(Energy_type !="all_energy_types", Country=="Mexico") %>% select(Year,Country,Energy_type,Energy_production, Energy_consumption)
type_mex_5## # A tibble: 40 × 5
## # Groups: Year, Country, Energy_type, Energy_production, Energy_consumption
## # [40]
## Year Country Energy_type Energy_production Energy_consumption
## <int> <chr> <chr> <dbl> <dbl>
## 1 2010 Mexico coal 0.323 0.540
## 2 2010 Mexico natural_gas 1.85 2.35
## 3 2010 Mexico petroleum_n_other_liquids 6.19 4.13
## 4 2010 Mexico nuclear 0.0563 0.0563
## 5 2010 Mexico renewables_n_other 0.445 0.451
## 6 2011 Mexico coal 0.412 0.593
## 7 2011 Mexico natural_gas 1.81 2.41
## 8 2011 Mexico petroleum_n_other_liquids 6.14 4.20
## 9 2011 Mexico nuclear 0.0937 0.0937
## 10 2011 Mexico renewables_n_other 0.438 0.443
## # … with 30 more rowsggplot(type_mex_5, aes(x = Year)) +
geom_line(aes(y = Energy_production, color = Energy_type)) +
labs(title = "Production & Energy Type of Mexico", x = "Year", y = "Energy") 
ggplot(type_mex_5, aes(x = Year)) +
geom_line(aes(y = Energy_consumption, color = Energy_type)) +
labs(title = "Consumption & Energy Type of Mexico", x = "Year", y = "Energy") 
#Venezuela
type_ven_5 <- group_by(bd_5_filter,Year,Country,Energy_type,Energy_production, Energy_consumption)%>%
filter(Energy_type !="all_energy_types",Energy_type !="nuclear", Country=="Venezuela") %>% select(Year,Country,Energy_type,Energy_production, Energy_consumption)
type_ven_5## # A tibble: 32 × 5
## # Groups: Year, Country, Energy_type, Energy_production, Energy_consumption
## # [32]
## Year Country Energy_type Energy_production Energy_consumpt…¹
## <int> <chr> <chr> <dbl> <dbl>
## 1 2010 Venezuela coal 0.0933 0.00791
## 2 2010 Venezuela natural_gas 0.757 0.813
## 3 2010 Venezuela petroleum_n_other_liquids 5.66 1.55
## 4 2010 Venezuela renewables_n_other 0.742 0.743
## 5 2011 Venezuela coal 0.0768 0.00813
## 6 2011 Venezuela natural_gas 0.797 0.878
## 7 2011 Venezuela petroleum_n_other_liquids 5.87 1.44
## 8 2011 Venezuela renewables_n_other 0.805 0.807
## 9 2012 Venezuela coal 0.0562 0.00836
## 10 2012 Venezuela natural_gas 0.872 0.943
## # … with 22 more rows, and abbreviated variable name ¹Energy_consumptionggplot(type_ven_5, aes(x = Year)) +
geom_line(aes(y = Energy_production, color = Energy_type)) +
labs(title = "Production & Energy Type of Venezuela", x = "Year", y = "Energy") 
ggplot(type_ven_5, aes(x = Year)) +
geom_line(aes(y = Energy_consumption, color = Energy_type)) +
labs(title = "Consumption & Energy Type of Venezuela", x = "Year", y = "Energy") 
#Brazil
type_bra_5 <- group_by(bd_5_filter,Year,Country,Energy_type,Energy_production, Energy_consumption)%>%
filter(Energy_type !="all_energy_types", Country=="Brazil") %>% select(Year,Country,Energy_type,Energy_production, Energy_consumption)
type_bra_5## # A tibble: 40 × 5
## # Groups: Year, Country, Energy_type, Energy_production, Energy_consumption
## # [40]
## Year Country Energy_type Energy_production Energy_consumption
## <int> <chr> <chr> <dbl> <dbl>
## 1 2010 Brazil coal 0.0863 0.561
## 2 2010 Brazil natural_gas 0.470 0.942
## 3 2010 Brazil petroleum_n_other_liquids 4.56 5.38
## 4 2010 Brazil nuclear 0.143 0.143
## 5 2010 Brazil renewables_n_other 4.85 4.39
## 6 2011 Brazil coal 0.0877 0.594
## 7 2011 Brazil natural_gas 0.545 0.936
## 8 2011 Brazil petroleum_n_other_liquids 4.68 5.56
## 9 2011 Brazil nuclear 0.153 0.153
## 10 2011 Brazil renewables_n_other 5.00 4.65
## # … with 30 more rowsggplot(type_bra_5, aes(x = Year)) +
geom_line(aes(y = Energy_production, color = Energy_type)) +
labs(title = "Production & Energy Type of Brazil", x = "Year", y = "Energy") 
ggplot(type_bra_5, aes(x = Year)) +
geom_line(aes(y = Energy_consumption, color = Energy_type)) +
labs(title = "Consumption & Energy Type of Brazil", x = "Year", y = "Energy") 
#Haiti
type_hai_5 <- group_by(bd_5_filter,Year,Country,Energy_type,Energy_production, Energy_consumption)%>%
filter(Energy_type !="all_energy_types",Energy_type !="coal",Energy_type !="nuclear",Energy_type !="natural_gas", Country=="Haiti") %>% select(Year,Country,Energy_type,Energy_production, Energy_consumption)
type_hai_5## # A tibble: 16 × 5
## # Groups: Year, Country, Energy_type, Energy_production, Energy_consumption
## # [16]
## Year Country Energy_type Energy_production Energy_consumption
## <int> <chr> <chr> <dbl> <dbl>
## 1 2010 Haiti petroleum_n_other_liquids 0 0.0293
## 2 2010 Haiti renewables_n_other 0.00172 0.00172
## 3 2011 Haiti petroleum_n_other_liquids 0 0.0314
## 4 2011 Haiti renewables_n_other 0.00117 0.00117
## 5 2012 Haiti petroleum_n_other_liquids 0 0.0337
## 6 2012 Haiti renewables_n_other 0.00210 0.00210
## 7 2013 Haiti petroleum_n_other_liquids 0 0.0363
## 8 2013 Haiti renewables_n_other 0.00135 0.00135
## 9 2014 Haiti petroleum_n_other_liquids 0 0.0397
## 10 2014 Haiti renewables_n_other 0.000865 0.000865
## 11 2015 Haiti petroleum_n_other_liquids 0 0.0455
## 12 2015 Haiti renewables_n_other 0.000784 0.000784
## 13 2016 Haiti petroleum_n_other_liquids 0 0.0474
## 14 2016 Haiti renewables_n_other 0.000667 0.000667
## 15 2017 Haiti petroleum_n_other_liquids 0 0.0465
## 16 2017 Haiti renewables_n_other 0.00119 0.00119ggplot(type_hai_5, aes(x = Year)) +
geom_line(aes(y = Energy_production, color = Energy_type)) +
labs(title = "Production & Energy Type of Haiti", x = "Year", y = "Energy") 
ggplot(type_hai_5, aes(x = Year)) +
geom_line(aes(y = Energy_consumption, color = Energy_type)) +
labs(title = "Consumption & Energy Type of Haiti", x = "Year", y = "Energy") 
#EXCEL 6
#Graph of renewable energies #Renewable_Energy_Canada
energy_can_6 <- group_by(bd_6_filter,year,country,solar_electricity,wind_electricity,hydro_electricity,other_renewable_electricity)%>%
filter(country=="Canada")
energy_can_6## # A tibble: 8 × 122
## # Groups: year, country, solar_electricity, wind_electricity,
## # hydro_electricity, other_renewable_electricity [8]
## iso_code country year coal_…¹ coal_…² gas_p…³ gas_p…⁴ oil_p…⁵ oil_p…⁶ energ…⁷
## <chr> <chr> <int> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 CAN Canada 2010 6.88 26.5 -3.52 -54.6 4.63 85.1 2.12
## 2 CAN Canada 2011 0.107 0.441 0.99 14.8 5.66 109. 4.60
## 3 CAN Canada 2012 0.185 0.764 -0.507 -7.66 7.25 147. -1.00
## 4 CAN Canada 2013 1.72 7.09 1.08 16.2 6.82 149. 3.07
## 5 CAN Canada 2014 -0.637 -2.68 4.66 70.7 7.57 176. 1.08
## 6 CAN Canada 2015 -9.89 -41.3 1.11 17.6 3.61 90.5 -0.273
## 7 CAN Canada 2016 1.14 4.28 6.87 110. 1.39 36.1 -0.407
## 8 CAN Canada 2017 -3.50 -13.3 2.21 38.0 8.42 222. 1.24
## # … with 112 more variables: energy_cons_change_twh <dbl>,
## # biofuel_share_elec <dbl>, biofuel_elec_per_capita <dbl>,
## # biofuel_cons_change_pct <dbl>, biofuel_share_energy <dbl>,
## # biofuel_cons_change_twh <dbl>, biofuel_consumption <dbl>,
## # biofuel_cons_per_capita <dbl>, carbon_intensity_elec <int>,
## # coal_share_elec <dbl>, coal_cons_change_pct <dbl>, coal_share_energy <dbl>,
## # coal_cons_change_twh <dbl>, coal_consumption <dbl>, …ggplot(energy_can_6, aes(x = year)) +
geom_line(aes(y = solar_electricity, color = "Solar_electricity")) +
geom_line(aes(y = wind_electricity, color = "Wind_electricity")) +
geom_line(aes(y = hydro_electricity, color = "Hydro_electricity")) +
geom_line(aes(y = other_renewable_electricity, color = "Other_renewable_electricity")) +
labs(title = "Renewable Energy by Canada", x = "Year", y = "Energy)") 
#Renewable_Energy_Mexico
energy_mex_6 <- group_by(bd_6_filter,year,country,solar_electricity,wind_electricity,hydro_electricity,other_renewable_electricity)%>%
filter(country=="Mexico")
energy_mex_6## # A tibble: 8 × 122
## # Groups: year, country, solar_electricity, wind_electricity,
## # hydro_electricity, other_renewable_electricity [8]
## iso_code country year coal_…¹ coal_…² gas_p…³ gas_p…⁴ oil_p…⁵ oil_p…⁶ energ…⁷
## <chr> <chr> <int> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 MEX Mexico 2010 20.3 14.4 -2.67 -14.1 -0.725 -12.4 2.93
## 2 MEX Mexico 2011 28.0 23.8 1.8 9.21 -0.743 -12.6 4.80
## 3 MEX Mexico 2012 -20.8 -22.6 -2.40 -12.5 -0.458 -7.68 0.594
## 4 MEX Mexico 2013 -3.52 -3.04 3.22 16.4 -1.40 -23.4 0.425
## 5 MEX Mexico 2014 1.28 1.07 -2.26 -11.9 -3.35 -55.1 -0.531
## 6 MEX Mexico 2015 -5.28 -4.46 -6.54 -33.5 -6.99 -111. -0.115
## 7 MEX Mexico 2016 -11.7 -9.31 -8.96 -43.0 -4.83 -71.6 1.26
## 8 MEX Mexico 2017 21.3 15.0 -12.3 -53.8 -9.79 -138. 1.41
## # … with 112 more variables: energy_cons_change_twh <dbl>,
## # biofuel_share_elec <dbl>, biofuel_elec_per_capita <dbl>,
## # biofuel_cons_change_pct <dbl>, biofuel_share_energy <dbl>,
## # biofuel_cons_change_twh <dbl>, biofuel_consumption <dbl>,
## # biofuel_cons_per_capita <dbl>, carbon_intensity_elec <int>,
## # coal_share_elec <dbl>, coal_cons_change_pct <dbl>, coal_share_energy <dbl>,
## # coal_cons_change_twh <dbl>, coal_consumption <dbl>, …ggplot(energy_mex_6, aes(x = year)) +
geom_line(aes(y = solar_electricity, color = "Solar_electricity")) +
geom_line(aes(y = wind_electricity, color = "Wind_electricity")) +
geom_line(aes(y = hydro_electricity, color = "Hydro_electricity")) +
geom_line(aes(y = other_renewable_electricity, color = "Other_renewable_electricity")) +
labs(title = "Renewable Energy by Mexico", x = "Year", y = "Energy)") 
#Renewable_Energy_Venezuela
energy_ven_6 <- group_by(bd_6_filter,year,country,solar_electricity,wind_electricity,hydro_electricity)%>%
filter(country=="Venezuela")
energy_ven_6## # A tibble: 8 × 122
## # Groups: year, country, solar_electricity, wind_electricity,
## # hydro_electricity [8]
## iso_code country year coal_…¹ coal_…² gas_p…³ gas_p…⁴ oil_p…⁵ oil_p…⁶ energ…⁷
## <chr> <chr> <int> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 VEN Venezu… 2010 -19.8 -5.50 -4.23 -13.4 -6.43 -116. -5.71
## 2 VEN Venezu… 2011 -0.737 -0.165 -0.707 -2.15 -2.97 -50.3 4.56
## 3 VEN Venezu… 2012 -26.8 -5.95 5.52 16.7 -1.54 -25.3 4.1
## 4 VEN Venezu… 2013 -35.7 -5.79 -4.12 -13.1 -1.11 -17.9 -2.48
## 5 VEN Venezu… 2014 -34.9 -3.64 3.92 12.0 0.529 8.46 -3.36
## 6 VEN Venezu… 2015 0.132 0.009 13.5 42.8 -2.27 -36.5 -3.52
## 7 VEN Venezu… 2016 -49.2 -3.35 3.25 11.7 -10.6 -166. -9.26
## 8 VEN Venezu… 2017 -2.47 -0.085 3.67 13.7 -11.1 -156. -4.49
## # … with 112 more variables: energy_cons_change_twh <dbl>,
## # biofuel_share_elec <dbl>, biofuel_elec_per_capita <dbl>,
## # biofuel_cons_change_pct <dbl>, biofuel_share_energy <dbl>,
## # biofuel_cons_change_twh <dbl>, biofuel_consumption <dbl>,
## # biofuel_cons_per_capita <dbl>, carbon_intensity_elec <int>,
## # coal_share_elec <dbl>, coal_cons_change_pct <dbl>, coal_share_energy <dbl>,
## # coal_cons_change_twh <dbl>, coal_consumption <dbl>, …ggplot(energy_ven_6, aes(x = year)) +
geom_line(aes(y = solar_electricity, color = "Solar_electricity")) +
geom_line(aes(y = wind_electricity, color = "Wind_electricity")) +
geom_line(aes(y = hydro_electricity, color = "Hydro_electricity")) +
labs(title = "Renewable Energy by Venezuela", x = "Year", y = "Energy)") 
#Renewable_Energy_Brazil
energy_bra_6 <- group_by(bd_6_filter,year,country,solar_electricity,wind_electricity,hydro_electricity,other_renewable_electricity)%>%
filter(country=="Brazil")
energy_bra_6## # A tibble: 8 × 122
## # Groups: year, country, solar_electricity, wind_electricity,
## # hydro_electricity, other_renewable_electricity [8]
## iso_code country year coal_…¹ coal_…² gas_p…³ gas_p…⁴ oil_p…⁵ oil_p…⁶ energ…⁷
## <chr> <chr> <int> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 BRA Brazil 2010 -10.2 -3.62 22.3 27.4 5.28 64.8 10.0
## 2 BRA Brazil 2011 0.081 0.026 14.7 22.1 2.32 30.0 4.57
## 3 BRA Brazil 2012 6.72 2.14 15.1 26.1 -1.67 -22.1 1.79
## 4 BRA Brazil 2013 24.2 8.22 10.7 21.2 -2.00 -25.9 3.78
## 5 BRA Brazil 2014 -0.802 -0.338 6.37 14.0 11.6 148. 2.23
## 6 BRA Brazil 2015 -19.2 -8.03 1.96 4.57 7.95 113. -1.36
## 7 BRA Brazil 2016 -7.85 -2.65 1.34 3.19 3.03 46.5 -2.57
## 8 BRA Brazil 2017 -18.7 -5.82 12.7 30.6 4.49 71.0 1.22
## # … with 112 more variables: energy_cons_change_twh <dbl>,
## # biofuel_share_elec <dbl>, biofuel_elec_per_capita <dbl>,
## # biofuel_cons_change_pct <dbl>, biofuel_share_energy <dbl>,
## # biofuel_cons_change_twh <dbl>, biofuel_consumption <dbl>,
## # biofuel_cons_per_capita <dbl>, carbon_intensity_elec <int>,
## # coal_share_elec <dbl>, coal_cons_change_pct <dbl>, coal_share_energy <dbl>,
## # coal_cons_change_twh <dbl>, coal_consumption <dbl>, …ggplot(energy_bra_6, aes(x = year)) +
geom_line(aes(y = solar_electricity, color = "Solar_electricity")) +
geom_line(aes(y = wind_electricity, color = "Wind_electricity")) +
geom_line(aes(y = hydro_electricity, color = "Hydro_electricity")) +
geom_line(aes(y = other_renewable_electricity, color = "Other_renewable_electricity")) +
labs(title = "Renewable Energy by Brazil", x = "Year", y = "Energy)") 
#Renewable_Energy_Haiti
energy_hai_6 <- group_by(bd_6_filter,year,country,solar_electricity,wind_electricity,hydro_electricity,other_renewable_electricity)%>%
filter(country=="Haiti")
energy_hai_6## # A tibble: 8 × 122
## # Groups: year, country, solar_electricity, wind_electricity,
## # hydro_electricity, other_renewable_electricity [8]
## iso_code country year coal_…¹ coal_…² gas_p…³ gas_p…⁴ oil_p…⁵ oil_p…⁶ energ…⁷
## <chr> <chr> <int> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 HTI Haiti 2010 NA 0 NA 0 NA 0 -7.25
## 2 HTI Haiti 2011 NA 0 NA 0 NA 0 2.19
## 3 HTI Haiti 2012 NA 0 NA 0 NA 0 13.3
## 4 HTI Haiti 2013 NA 0 NA 0 NA 0 5.15
## 5 HTI Haiti 2014 NA 0 NA 0 NA 0 7.74
## 6 HTI Haiti 2015 NA 0 NA 0 NA 0 4.13
## 7 HTI Haiti 2016 NA 0 NA 0 NA 0 23.6
## 8 HTI Haiti 2017 NA NA NA NA NA NA NA
## # … with 112 more variables: energy_cons_change_twh <dbl>,
## # biofuel_share_elec <dbl>, biofuel_elec_per_capita <dbl>,
## # biofuel_cons_change_pct <dbl>, biofuel_share_energy <dbl>,
## # biofuel_cons_change_twh <dbl>, biofuel_consumption <dbl>,
## # biofuel_cons_per_capita <dbl>, carbon_intensity_elec <int>,
## # coal_share_elec <dbl>, coal_cons_change_pct <dbl>, coal_share_energy <dbl>,
## # coal_cons_change_twh <dbl>, coal_consumption <dbl>, …ggplot(energy_hai_6, aes(x = year)) +
geom_line(aes(y = solar_electricity, color = "Solar_electricity")) +
geom_line(aes(y = hydro_electricity, color = "Hydro_electricity")) +
geom_line(aes(y = other_renewable_electricity, color = "Other_renewable_electricity")) +
labs(title = "Renewable Energy by Haiti", x = "Year", y = "Energy)") 
#EXCEL 7 #COAL_CMB
coal_cmb_7 <- group_by(bd_7_filter,Entity,Year, `Electricity from coal (TWh)`) %>%
filter(Entity!="Haiti" & Entity!="Venezuela")
coal_cmb_7## # A tibble: 24 × 11
## # Groups: Entity, Year, Electricity from coal (TWh) [24]
## Entity Code Year Electric…¹ Elect…² Elect…³ Elect…⁴ Elect…⁵ Elect…⁶ Elect…⁷
## <chr> <chr> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 Brazil BRA 2010 11.0 34.3 399. 31.5 0.001 14.8 2.18
## 2 Brazil BRA 2011 12.3 23.5 424. 32.4 0.002 13.3 2.70
## 3 Brazil BRA 2012 13.9 44.2 411. 35.6 0.007 17.7 5.05
## 4 Brazil BRA 2013 21.1 65.1 387. 40.8 0.005 24.1 6.58
## 5 Brazil BRA 2014 25.8 76.7 370. 46.7 0.016 32.2 12.2
## 6 Brazil BRA 2015 25.8 75.0 356. 49.4 0.059 26.7 21.6
## 7 Brazil BRA 2016 24.6 53.1 377. 50.9 0.085 13.7 33.5
## 8 Brazil BRA 2017 24.2 61.7 367. 52.5 0.832 14.3 42.4
## 9 Canada CAN 2010 75.5 46.1 348. 12.2 0.253 9.84 8.64
## 10 Canada CAN 2011 69.1 54.1 372. 11.8 0.566 9.15 10.1
## # … with 14 more rows, 1 more variable: `Electricity from nuclear (TWh)` <dbl>,
## # and abbreviated variable names ¹`Electricity from coal (TWh)`,
## # ²`Electricity from gas (TWh)`, ³`Electricity from hydro (TWh)`,
## # ⁴`Electricity from other renewables (TWh)`,
## # ⁵`Electricity from solar (TWh)`, ⁶`Electricity from oil (TWh)`,
## # ⁷`Electricity from wind (TWh)`ggplot(data = coal_cmb_7, aes(x = Year, y = `Electricity from coal (TWh)`, fill = Entity)) +
geom_bar(stat = "identity", position="dodge") +
labs(title = "Electricity_from_COAL", x = "Year-Country", y = "Electricity (TWh)") +
theme(axis.text.x = element_text(angle = 90, vjust = 0.5))
#GAS_CMVB
gas_CMVB_7 <- group_by(bd_7_filter,Entity,Year, `Electricity from gas (TWh)`) %>%
filter(Entity!="Haiti")
gas_CMVB_7## # A tibble: 32 × 11
## # Groups: Entity, Year, Electricity from gas (TWh) [32]
## Entity Code Year Electric…¹ Elect…² Elect…³ Elect…⁴ Elect…⁵ Elect…⁶ Elect…⁷
## <chr> <chr> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 Brazil BRA 2010 11.0 34.3 399. 31.5 0.001 14.8 2.18
## 2 Brazil BRA 2011 12.3 23.5 424. 32.4 0.002 13.3 2.70
## 3 Brazil BRA 2012 13.9 44.2 411. 35.6 0.007 17.7 5.05
## 4 Brazil BRA 2013 21.1 65.1 387. 40.8 0.005 24.1 6.58
## 5 Brazil BRA 2014 25.8 76.7 370. 46.7 0.016 32.2 12.2
## 6 Brazil BRA 2015 25.8 75.0 356. 49.4 0.059 26.7 21.6
## 7 Brazil BRA 2016 24.6 53.1 377. 50.9 0.085 13.7 33.5
## 8 Brazil BRA 2017 24.2 61.7 367. 52.5 0.832 14.3 42.4
## 9 Canada CAN 2010 75.5 46.1 348. 12.2 0.253 9.84 8.64
## 10 Canada CAN 2011 69.1 54.1 372. 11.8 0.566 9.15 10.1
## # … with 22 more rows, 1 more variable: `Electricity from nuclear (TWh)` <dbl>,
## # and abbreviated variable names ¹`Electricity from coal (TWh)`,
## # ²`Electricity from gas (TWh)`, ³`Electricity from hydro (TWh)`,
## # ⁴`Electricity from other renewables (TWh)`,
## # ⁵`Electricity from solar (TWh)`, ⁶`Electricity from oil (TWh)`,
## # ⁷`Electricity from wind (TWh)`ggplot(data = gas_CMVB_7, aes(x = Year, y = `Electricity from gas (TWh)`, fill = Entity)) +
geom_bar(stat = "identity", position="dodge") +
labs(title = "Electricity_from_GAS", x = "Year-Country", y = "Electricity (TWh)") +
theme(axis.text.x = element_text(angle = 90, vjust = 0.5))
#OIL_CHMB
oil_CHMB_7 <- group_by(bd_7_filter,Entity,Year, `Electricity from oil (TWh)`) %>%
filter(Entity!="Venezuela")
oil_CHMB_7## # A tibble: 32 × 11
## # Groups: Entity, Year, Electricity from oil (TWh) [32]
## Entity Code Year Electric…¹ Elect…² Elect…³ Elect…⁴ Elect…⁵ Elect…⁶ Elect…⁷
## <chr> <chr> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 Brazil BRA 2010 11.0 34.3 399. 31.5 0.001 14.8 2.18
## 2 Brazil BRA 2011 12.3 23.5 424. 32.4 0.002 13.3 2.70
## 3 Brazil BRA 2012 13.9 44.2 411. 35.6 0.007 17.7 5.05
## 4 Brazil BRA 2013 21.1 65.1 387. 40.8 0.005 24.1 6.58
## 5 Brazil BRA 2014 25.8 76.7 370. 46.7 0.016 32.2 12.2
## 6 Brazil BRA 2015 25.8 75.0 356. 49.4 0.059 26.7 21.6
## 7 Brazil BRA 2016 24.6 53.1 377. 50.9 0.085 13.7 33.5
## 8 Brazil BRA 2017 24.2 61.7 367. 52.5 0.832 14.3 42.4
## 9 Canada CAN 2010 75.5 46.1 348. 12.2 0.253 9.84 8.64
## 10 Canada CAN 2011 69.1 54.1 372. 11.8 0.566 9.15 10.1
## # … with 22 more rows, 1 more variable: `Electricity from nuclear (TWh)` <dbl>,
## # and abbreviated variable names ¹`Electricity from coal (TWh)`,
## # ²`Electricity from gas (TWh)`, ³`Electricity from hydro (TWh)`,
## # ⁴`Electricity from other renewables (TWh)`,
## # ⁵`Electricity from solar (TWh)`, ⁶`Electricity from oil (TWh)`,
## # ⁷`Electricity from wind (TWh)`ggplot(data = oil_CHMB_7, aes(x = Year, y = `Electricity from oil (TWh)`, fill = Entity)) +
geom_bar(stat = "identity", position="dodge") +
labs(title = "Electricity_from_OIL", x = "Year-Country", y = "Electricity (TWh)") +
theme(axis.text.x = element_text(angle = 90, vjust = 0.5))
#NUCLEAR_MCB
nuclear_MCB_7 <- group_by(bd_7_filter,Entity,Year, `Electricity from nuclear (TWh)`) %>%
filter(Entity!="Venezuela" & Entity!="Haiti")
nuclear_MCB_7## # A tibble: 24 × 11
## # Groups: Entity, Year, Electricity from nuclear (TWh) [24]
## Entity Code Year Electric…¹ Elect…² Elect…³ Elect…⁴ Elect…⁵ Elect…⁶ Elect…⁷
## <chr> <chr> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 Brazil BRA 2010 11.0 34.3 399. 31.5 0.001 14.8 2.18
## 2 Brazil BRA 2011 12.3 23.5 424. 32.4 0.002 13.3 2.70
## 3 Brazil BRA 2012 13.9 44.2 411. 35.6 0.007 17.7 5.05
## 4 Brazil BRA 2013 21.1 65.1 387. 40.8 0.005 24.1 6.58
## 5 Brazil BRA 2014 25.8 76.7 370. 46.7 0.016 32.2 12.2
## 6 Brazil BRA 2015 25.8 75.0 356. 49.4 0.059 26.7 21.6
## 7 Brazil BRA 2016 24.6 53.1 377. 50.9 0.085 13.7 33.5
## 8 Brazil BRA 2017 24.2 61.7 367. 52.5 0.832 14.3 42.4
## 9 Canada CAN 2010 75.5 46.1 348. 12.2 0.253 9.84 8.64
## 10 Canada CAN 2011 69.1 54.1 372. 11.8 0.566 9.15 10.1
## # … with 14 more rows, 1 more variable: `Electricity from nuclear (TWh)` <dbl>,
## # and abbreviated variable names ¹`Electricity from coal (TWh)`,
## # ²`Electricity from gas (TWh)`, ³`Electricity from hydro (TWh)`,
## # ⁴`Electricity from other renewables (TWh)`,
## # ⁵`Electricity from solar (TWh)`, ⁶`Electricity from oil (TWh)`,
## # ⁷`Electricity from wind (TWh)`ggplot(data = nuclear_MCB_7, aes(x = Year, y = `Electricity from nuclear (TWh)`, fill = Entity)) +
geom_bar(stat = "identity", position="dodge") +
labs(title = "Electricity_from_NUCLEAR", x = "Year-Country", y = "Electricity (TWh)") +
theme(axis.text.x = element_text(angle = 90, vjust = 0.5))