HW10

Questions for Final Project

In the final paper, I will be looking at the current state of investments in sustainable energy, and which areas are lacking in energy access.

Question 1:

How much was money was invested in sustainable energy over the past few years, and where is the money going?

Show the code
options(repos = c(CRAN = "https://cran.rstudio.com/"))
library(tidyverse)
library(janitor)
library(countrycode)
library(dplyr)
library(ggplot2)
library(lubridate)
library(readxl)
library(xfun)
library(esquisse)
library(stringr)
install.packages("readxl")
library(readxl)

total_invest_long_1 <- read_excel("C:/Users/alyss/OneDrive - Johns Hopkins/Desktop/MIEF Courses/Sustainable Finance/03_data_processed/long_investment_1.xlsx")

#graph of investment amounts per region

ggplot(total_invest_long_1, aes(x = region, y = Investment_Amount, fill = Investment_Type)) +
  geom_bar(stat = "identity", position = "dodge") +
  scale_fill_manual(values = c("total_clean_investment" = "forestgreen", "total_investment" = "darkblue"),
                    labels = c("total_clean_investment" = "Investments in Clean Energy", "total_investment" = "Total Energy Investments")) +
  labs(title = "Comparison of Energy Investments by Region (2015-2023)",
       x = "",
       y = "Investment (USD billions)",
       caption = "Data: International Energy Agency",
       fill = "Investment Type") +
  theme_minimal() +
  theme(axis.text.x = element_text(size = 6), 
        axis.text.y = element_text(size = 6),  # Smaller y-axis title
        axis.title.y = element_text(size = 6),  # Smaller y-axis title
        plot.title = element_text(size = 8, hjust = 0.5),
        legend.title = element_text(size = 7),  # Adjust legend title size
        legend.text = element_text(size = 6),   # Adjust legend text size
        legend.key.size = unit(0.5, "cm"),
        plot.caption = element_text(size=6))   

I’m interested in looking at emerging markets, which show significantly less investment in overall energy or clean energy from 2015-2023. It looks like majority of money invested in energy projects is going to developed countries, and traditional energy sources.

Question 2:

Which areas of the world have the lowest access to energy or electricity?

Show the code
wide_WB_Electricity_1 <- read_excel("C:/Users/alyss/OneDrive - Johns Hopkins/Desktop/MIEF Courses/Sustainable Finance/03_data_processed/wide_WB_electric_1.xlsx")

filtered_electric <- wide_WB_Electricity_1 %>%
  filter(country_name %in% c("Africa Eastern and Southern",     
"Africa Western and Central", "Middle East & North Africa", "Central Europe and the Baltics", "East Asia & Pacific (excluding high income)", "South Asia (IDA & IBRD)", "Latin America & Caribbean"))


filtered_electric_2021 <- filtered_electric %>%
  filter(year == 2021)

ggplot(filtered_electric_2021, aes(x = country_name, y = access_to_electricity_percent_of_population, fill = country_name)) +
 geom_bar(stat = "identity", width = 0.5)+
  coord_flip() + 
  labs(title="Access to Electricity in 2021 by Region", y="Access to Electricity (% of population)", x="Region") +
  theme_minimal()

I’m surprised by the high rates of access to electricity across emerging markets, and it looks like the African continent, excluding North Africa, has the lowest rates of electricity access.

Further Questions:

I also have data from Our World in Data that breaks down access to energy in many different forms and categories. This dataset has over 100 different variables from biofuel consumption, to solar energy. to coal consumption. My next question will be around which areas have the highest and lowest clean energy consumption and coal consumption, with the goal of finding potential regions that would benefit from clean energy investment. I plan to create different visualizations for the final paper that outline these findings.

Show the code
merged_WB_OWID_1 <- read_excel("C:/Users/alyss/OneDrive - Johns Hopkins/Desktop/MIEF Courses/Sustainable Finance/03_data_processed/merged_OWID_WB.xlsx")

summary(merged_WB_OWID_1)
   country               year        iso_code           population       
 Length:23995       Min.   :1900   Length:23995       Min.   :1.833e+03  
 Class :character   1st Qu.:1950   Class :character   1st Qu.:1.726e+06  
 Mode  :character   Median :1988   Mode  :character   Median :6.990e+06  
                    Mean   :1977                      Mean   :1.049e+08  
                    3rd Qu.:2006                      3rd Qu.:2.558e+07  
                    Max.   :2023                      Max.   :7.975e+09  
                                                      NA's   :5771       
      gdp            biofuel_cons_change_pct biofuel_cons_change_twh
 Min.   :1.642e+08   Min.   :-100.000        Min.   :-50.843        
 1st Qu.:1.368e+10   1st Qu.:  -0.617        1st Qu.:  0.000        
 Median :4.174e+10   Median :   8.179        Median :  0.000        
 Mean   :3.578e+11   Mean   :  46.092        Mean   :  2.719        
 3rd Qu.:1.741e+11   3rd Qu.:  26.509        3rd Qu.:  0.862        
 Max.   :1.136e+14   Max.   :5659.328        Max.   :141.131        
 NA's   :12857       NA's   :22248           NA's   :21308          
 biofuel_cons_per_capita biofuel_consumption biofuel_elec_per_capita
 Min.   :   0.00         Min.   :   0.000    Min.   :   0.000       
 1st Qu.:   0.00         1st Qu.:   0.000    1st Qu.:   0.000       
 Median :  15.48         Median :   0.673    Median :   0.135       
 Mean   : 133.56         Mean   :  38.068    Mean   :  63.043       
 3rd Qu.: 165.27         3rd Qu.:  13.630    3rd Qu.:  34.992       
 Max.   :2588.51         Max.   :1199.207    Max.   :2514.102       
 NA's   :21693           NA's   :21228       NA's   :18717          
 biofuel_electricity biofuel_share_elec biofuel_share_energy
 Min.   :  0.00      Min.   : 0.000     Min.   :0.000       
 1st Qu.:  0.00      1st Qu.: 0.000     1st Qu.:0.000       
 Median :  0.01      Median : 0.066     Median :0.056       
 Mean   : 10.90      Mean   : 1.853     Mean   :0.420       
 3rd Qu.:  0.68      3rd Qu.: 1.568     3rd Qu.:0.561       
 Max.   :675.11      Max.   :71.429     Max.   :7.486       
 NA's   :18466       NA's   :18501      NA's   :21324       
 carbon_intensity_elec coal_cons_change_pct coal_cons_change_twh
 Min.   :   0.0        Min.   : -100.00     Min.   :-1472.539   
 1st Qu.: 285.2        1st Qu.:   -4.55     1st Qu.:   -1.678   
 Median : 487.3        Median :    1.22     Median :    0.167   
 Mean   : 443.6        Mean   :   24.18     Mean   :   31.797   
 3rd Qu.: 627.2        3rd Qu.:    7.06     3rd Qu.:    8.391   
 Max.   :1000.0        Max.   :55400.00     Max.   : 2649.768   
 NA's   :18828         NA's   :18737        NA's   :18680       
 coal_cons_per_capita coal_consumption   coal_elec_per_capita
 Min.   :    0.0      Min.   :    0.00   Min.   :   0.0      
 1st Qu.:  491.9      1st Qu.:   10.07   1st Qu.:   0.0      
 Median : 3097.4      Median :   69.47   Median :   0.0      
 Mean   : 6283.0      Mean   : 1880.50   Mean   : 710.3      
 3rd Qu.: 9125.2      3rd Qu.:  641.99   3rd Qu.: 809.0      
 Max.   :96169.9      Max.   :44858.12   Max.   :9478.4      
 NA's   :19329        NA's   :18575      NA's   :18167       
 coal_electricity   coal_prod_change_pct coal_prod_change_twh
 Min.   :    0.00   Min.   : -100.00     Min.   :-2441.891   
 1st Qu.:    0.00   1st Qu.:   -3.91     1st Qu.:    0.000   
 Median :    0.26   Median :    2.24     Median :    0.000   
 Mean   :  328.18   Mean   :   18.83     Mean   :   16.599   
 3rd Qu.:   36.74   3rd Qu.:    9.14     3rd Qu.:    0.818   
 Max.   :10212.22   Max.   :44965.75     Max.   : 3352.484   
 NA's   :17574      NA's   :14338        NA's   :7756        
 coal_prod_per_capita coal_production    coal_share_elec   coal_share_energy
 Min.   :     0.00    Min.   :    0.00   Min.   :  0.000   Min.   : 0.000   
 1st Qu.:     0.00    1st Qu.:    0.00   1st Qu.:  0.000   1st Qu.: 4.705   
 Median :    28.44    Median :    1.28   Median :  0.976   Median :16.693   
 Mean   :  3434.14    Mean   :  969.43   Mean   : 17.120   Mean   :20.586   
 3rd Qu.:  2053.73    3rd Qu.:  112.00   3rd Qu.: 31.808   3rd Qu.:30.775   
 Max.   :151662.27    Max.   :48490.00   Max.   :100.000   Max.   :89.139   
 NA's   :9277         NA's   :7501       NA's   :17609     NA's   :19208    
 electricity_demand  electricity_generation electricity_share_energy
 Min.   :    0.000   Min.   :    0.00       Min.   : 1.04           
 1st Qu.:    1.305   1st Qu.:    2.17       1st Qu.:12.08           
 Median :   11.140   Median :   20.97       Median :15.21           
 Mean   :  594.708   Mean   :  772.73       Mean   :15.91           
 3rd Qu.:   87.400   3rd Qu.:  151.67       3rd Qu.:18.33           
 Max.   :28660.980   Max.   :28660.98       Max.   :72.21           
 NA's   :18332       NA's   :16800          NA's   :20126           
 energy_cons_change_pct energy_cons_change_twh energy_per_capita
 Min.   :-100.000       Min.   :-6069.188      Min.   :     0   
 1st Qu.:  -0.475       1st Qu.:   -0.050      1st Qu.:  3105   
 Median :   2.407       Median :    0.773      Median : 13599   
 Mean   :   4.034       Mean   :   86.829      Mean   : 25752   
 3rd Qu.:   6.246       3rd Qu.:   16.078      3rd Qu.: 36868   
 Max.   :1553.105       Max.   : 8906.781      Max.   :657539   
 NA's   :12376          NA's   :12183          NA's   :13391    
 energy_per_gdp   fossil_cons_change_pct fossil_cons_change_twh
 Min.   : 0.078   Min.   :-46.222        Min.   :-6659.281     
 1st Qu.: 0.861   1st Qu.: -0.663        1st Qu.:   -2.385     
 Median : 1.326   Median :  2.216        Median :   10.182     
 Mean   : 1.829   Mean   :  2.338        Mean   :  117.976     
 3rd Qu.: 2.235   3rd Qu.:  5.503        3rd Qu.:   58.974     
 Max.   :25.253   Max.   : 98.637        Max.   : 7138.688     
 NA's   :16784    NA's   :19021          NA's   :19138         
 fossil_elec_per_capita fossil_electricity fossil_energy_per_capita
 Min.   :    0.0        Min.   :    0.00   Min.   :   188.5        
 1st Qu.:  201.2        1st Qu.:    0.47   1st Qu.: 11708.7        
 Median : 1257.7        Median :    9.98   Median : 25652.0        
 Mean   : 2311.1        Mean   :  542.13   Mean   : 30736.5        
 3rd Qu.: 3430.4        3rd Qu.:  126.55   3rd Qu.: 40542.9        
 Max.   :21698.0        Max.   :17559.97   Max.   :262585.7        
 NA's   :18049          NA's   :17456      NA's   :19780           
 fossil_fuel_consumption fossil_share_elec fossil_share_energy
 Min.   :    11.57       Min.   :  0.00    Min.   : 25.70     
 1st Qu.:   199.28       1st Qu.: 42.35    1st Qu.: 79.78     
 Median :   661.17       Median : 70.46    Median : 89.09     
 Mean   :  6403.13       Mean   : 64.77    Mean   : 85.23     
 3rd Qu.:  2942.16       3rd Qu.: 93.95    3rd Qu.: 94.96     
 Max.   :137236.67       Max.   :100.00    Max.   :100.00     
 NA's   :19033           NA's   :17602     NA's   :19208      
 gas_cons_change_pct gas_cons_change_twh gas_consumption    gas_elec_per_capita
 Min.   :  -95.245   Min.   :-1351.460   Min.   :    0.00   Min.   :    0.00   
 1st Qu.:   -0.343   1st Qu.:   -0.055   1st Qu.:   26.61   1st Qu.:    0.00   
 Median :    4.022   Median :    3.490   Median :  123.67   Median :   65.72   
 Mean   :   19.099   Mean   :   39.071   Mean   : 1478.56   Mean   :  845.74   
 3rd Qu.:    9.976   3rd Qu.:   22.215   3rd Qu.:  582.98   3rd Qu.:  786.81   
 Max.   :15300.000   Max.   : 2188.346   Max.   :40670.66   Max.   :21246.99   
 NA's   :18909       NA's   :18884       NA's   :18780      NA's   :18160      
 gas_electricity    gas_energy_per_capita gas_prod_change_pct 
 Min.   :   0.000   Min.   :     0        Min.   :-1.000e+02  
 1st Qu.:   0.000   1st Qu.:  1257        1st Qu.: 0.000e+00  
 Median :   2.255   Median :  5298        Median : 4.000e+00  
 Mean   : 174.514   Mean   : 10912        Mean   : 1.194e+14  
 3rd Qu.:  44.200   3rd Qu.: 11157        3rd Qu.: 1.100e+01  
 Max.   :6443.600   Max.   :287469        Max.   : 9.323e+17  
 NA's   :17567      NA's   :19527         NA's   :16188       
 gas_prod_change_twh gas_prod_per_capita gas_production     gas_share_elec   
 Min.   :-1147.562   Min.   :     0.0    Min.   :    0.00   Min.   :  0.000  
 1st Qu.:    0.000   1st Qu.:     0.0    1st Qu.:    0.00   1st Qu.:  0.000  
 Median :    0.000   Median :     0.0    Median :    0.00   Median :  8.615  
 Mean   :   17.738   Mean   :  6411.5    Mean   :  612.40   Mean   : 18.523  
 3rd Qu.:    1.218   3rd Qu.:   725.9    3rd Qu.:   55.11   3rd Qu.: 25.950  
 Max.   : 2093.074   Max.   :852961.6    Max.   :40534.20   Max.   :100.000  
 NA's   :7479        NA's   :9099        NA's   :7224       NA's   :17602    
 gas_share_energy greenhouse_gas_emissions hydro_cons_change_pct
 Min.   : 0.00    Min.   :    0.00         Min.   : -81.250     
 1st Qu.: 7.97    1st Qu.:    0.25         1st Qu.:  -3.660     
 Median :17.81    Median :    2.80         Median :   2.778     
 Mean   :20.37    Mean   :  290.06         Mean   :   5.675     
 3rd Qu.:27.35    3rd Qu.:   30.59         3rd Qu.:  10.438     
 Max.   :92.92    Max.   :12543.72         Max.   :1750.000     
 NA's   :19208    NA's   :18682            NA's   :18913        
 hydro_cons_change_twh hydro_consumption   hydro_elec_per_capita
 Min.   :-325.864      Min.   :    0.000   Min.   :    0.00     
 1st Qu.:  -0.735      1st Qu.:    5.447   1st Qu.:    7.08     
 Median :   0.304      Median :   35.347   Median :  139.97     
 Mean   :   9.314      Mean   :  444.171   Mean   :  983.45     
 3rd Qu.:   6.064      3rd Qu.:  209.084   3rd Qu.:  709.97     
 Max.   : 509.323      Max.   :11448.027   Max.   :40897.94     
 NA's   :18621         NA's   :18516       NA's   :16137        
 hydro_electricity  hydro_energy_per_capita hydro_share_elec 
 Min.   :   0.000   Min.   :     0.0        Min.   :  0.000  
 1st Qu.:   0.100   1st Qu.:   176.3        1st Qu.:  0.659  
 Median :   3.838   Median :   731.5        Median : 14.020  
 Mean   : 119.982   Mean   :  3857.6        Mean   : 25.712  
 3rd Qu.:  31.482   3rd Qu.:  2541.0        3rd Qu.: 43.386  
 Max.   :4339.530   Max.   :112095.5        Max.   :100.000  
 NA's   :15132      NA's   :19270           NA's   :17006    
 hydro_share_energy low_carbon_cons_change_pct low_carbon_cons_change_twh
 Min.   : 0.000     Min.   : -88.179           Min.   :-422.710          
 1st Qu.: 2.109     1st Qu.:  -0.455           1st Qu.:  -0.059          
 Median : 5.914     Median :   4.242           Median :   1.460          
 Mean   : 9.448     Mean   :   9.627           Mean   :  31.295          
 3rd Qu.:11.715     3rd Qu.:  10.874           3rd Qu.:  13.694          
 Max.   :72.310     Max.   :7518.203           Max.   :1449.670          
 NA's   :19208      NA's   :18830              NA's   :18621             
 low_carbon_consumption low_carbon_elec_per_capita low_carbon_electricity
 Min.   :    0.00       Min.   :    0.00           Min.   :    0.00      
 1st Qu.:   11.22       1st Qu.:   22.41           1st Qu.:    0.17      
 Median :   60.84       Median :  239.24           Median :    6.32      
 Mean   :  890.40       Mean   : 1508.73           Mean   :  276.23      
 3rd Qu.:  378.21       3rd Qu.: 1410.02           3rd Qu.:   54.92      
 Max.   :30551.01       Max.   :56030.79           Max.   :11101.01      
 NA's   :18516          NA's   :16990              NA's   :16176         
 low_carbon_energy_per_capita low_carbon_share_elec low_carbon_share_energy
 Min.   :     0               Min.   :  0.000       Min.   : 0.000         
 1st Qu.:   338               1st Qu.:  5.944       1st Qu.: 5.043         
 Median :  1726               Median : 29.570       Median :10.905         
 Mean   :  6151               Mean   : 35.522       Mean   :14.767         
 3rd Qu.:  5880               3rd Qu.: 59.303       3rd Qu.:20.224         
 Max.   :151653               Max.   :100.000       Max.   :74.302         
 NA's   :19270                NA's   :17237         NA's   :19208          
 net_elec_imports  net_elec_imports_share_demand nuclear_cons_change_pct
 Min.   :-77.030   Min.   :-844.207              Min.   : -100.000      
 1st Qu.:  0.000   1st Qu.:  -0.014              1st Qu.:   -1.280      
 Median :  0.000   Median :   0.000              Median :    3.232      
 Mean   :  0.131   Mean   :   0.604              Mean   :   33.618      
 3rd Qu.:  0.450   3rd Qu.:   2.410              3rd Qu.:   14.137      
 Max.   : 66.670   Max.   : 100.000              Max.   :11200.001      
 NA's   :18606     NA's   :18751                 NA's   :21528          
 nuclear_cons_change_twh nuclear_consumption nuclear_elec_per_capita
 Min.   :-553.346        Min.   :   0.00     Min.   :   0.0         
 1st Qu.:   0.000        1st Qu.:   0.00     1st Qu.:   0.0         
 Median :   0.000        Median :   0.00     Median :   0.0         
 Mean   :   6.147        Mean   : 254.87     Mean   : 307.9         
 3rd Qu.:   0.000        3rd Qu.:  35.58     3rd Qu.:   0.0         
 Max.   : 664.981        Max.   :7653.72     Max.   :8931.6         
 NA's   :17291           NA's   :17153       NA's   :15340          
 nuclear_electricity nuclear_energy_per_capita nuclear_share_elec
 Min.   :   0.00     Min.   :    0.0           Min.   : 0.000    
 1st Qu.:   0.00     1st Qu.:    0.0           1st Qu.: 0.000    
 Median :   0.00     Median :    0.0           Median : 0.000    
 Mean   :  87.45     Mean   : 1177.3           Mean   : 5.855    
 3rd Qu.:   3.71     3rd Qu.:  191.5           3rd Qu.: 2.544    
 Max.   :2749.57     Max.   :25344.0           Max.   :88.138    
 NA's   :14439       NA's   :17803             NA's   :17036     
 nuclear_share_energy oil_cons_change_pct oil_cons_change_twh
 Min.   : 0.000       Min.   : -73.921    Min.   :-4903.199  
 1st Qu.: 0.000       1st Qu.:  -1.184    1st Qu.:   -1.883  
 Median : 0.165       Median :   2.350    Median :    3.897  
 Mean   : 3.686       Mean   :   3.070    Mean   :   37.199  
 3rd Qu.: 4.537       3rd Qu.:   6.469    3rd Qu.:   23.008  
 Max.   :42.191       Max.   :1553.105    Max.   : 2740.012  
 NA's   :19344        NA's   :18350       NA's   :18386      
 oil_consumption    oil_elec_per_capita oil_electricity   
 Min.   :    0.10   Min.   :    0.00    Min.   :   0.000  
 1st Qu.:   83.87   1st Qu.:   33.44    1st Qu.:   0.150  
 Median :  220.75   Median :  155.67    Median :   1.699  
 Mean   : 2442.66   Mean   :  812.27    Mean   :  49.483  
 3rd Qu.: 1137.85   3rd Qu.:  544.78    3rd Qu.:  14.575  
 Max.   :53512.84   Max.   :13773.77    Max.   :1364.684  
 NA's   :18282      NA's   :18160       NA's   :17567     
 oil_energy_per_capita oil_prod_change_pct oil_prod_change_twh
 Min.   :   119        Min.   : -100.000   Min.   :-3531.891  
 1st Qu.:  5083        1st Qu.:   -2.863   1st Qu.:    0.000  
 Median : 11874        Median :    1.853   Median :    0.000  
 Mean   : 15777        Mean   :   21.613   Mean   :   24.073  
 3rd Qu.: 21151        3rd Qu.:   10.508   3rd Qu.:    1.804  
 Max.   :141187        Max.   :26472.602   Max.   : 2795.154  
 NA's   :19036         NA's   :14157       NA's   :6847       
 oil_prod_per_capita oil_production     oil_share_elec    oil_share_energy
 Min.   :      0     Min.   :    0.00   Min.   :  0.000   Min.   : 7.068  
 1st Qu.:      0     1st Qu.:    0.00   1st Qu.:  2.409   1st Qu.:33.678  
 Median :      5     Median :    1.26   Median :  9.426   Median :42.212  
 Mean   :  25367     Mean   : 1227.63   Mean   : 29.300   Mean   :44.272  
 3rd Qu.:   2452     3rd Qu.:  189.34   3rd Qu.: 50.584   3rd Qu.:53.074  
 Max.   :3493139     Max.   :52190.70   Max.   :100.000   Max.   :99.968  
 NA's   :8626        NA's   :6590       NA's   :17602     NA's   :19208   
 other_renewable_consumption other_renewable_electricity
 Min.   :   0.000            Min.   :  0.00             
 1st Qu.:   0.000            1st Qu.:  0.00             
 Median :   1.408            Median :  0.06             
 Mean   :  48.543            Mean   : 13.42             
 3rd Qu.:  17.577            3rd Qu.:  2.01             
 Max.   :2413.808            Max.   :771.91             
 NA's   :19017               NA's   :15847              
 other_renewable_exc_biofuel_electricity other_renewables_cons_change_pct
 Min.   : 0.000                          Min.   : -100.00                
 1st Qu.: 0.000                          1st Qu.:    0.00                
 Median : 0.000                          Median :    5.31                
 Mean   : 2.062                          Mean   :   33.84                
 3rd Qu.: 0.000                          3rd Qu.:   14.42                
 Max.   :96.800                          Max.   :21131.33                
 NA's   :18585                           NA's   :20446                   
 other_renewables_cons_change_twh other_renewables_elec_per_capita
 Min.   :-20.055                  Min.   :    0.00                
 1st Qu.:  0.000                  1st Qu.:    0.00                
 Median :  0.016                  Median :    1.06                
 Mean   :  2.985                  Mean   :  106.89                
 3rd Qu.:  0.923                  3rd Qu.:   44.57                
 Max.   :152.614                  Max.   :16291.21                
 NA's   :19122                    NA's   :16783                   
 other_renewables_elec_per_capita_exc_biofuel
 Min.   :    0.00                            
 1st Qu.:    0.00                            
 Median :    0.00                            
 Mean   :   66.19                            
 3rd Qu.:    0.00                            
 Max.   :16291.21                            
 NA's   :18836                               
 other_renewables_energy_per_capita other_renewables_share_elec
 Min.   :    0.0                    Min.   : 0.000             
 1st Qu.:    0.0                    1st Qu.: 0.000             
 Median :   39.1                    Median : 0.199             
 Mean   :  478.6                    Mean   : 2.387             
 3rd Qu.:  264.9                    3rd Qu.: 1.932             
 Max.   :43229.6                    Max.   :71.429             
 NA's   :19702                      NA's   :17091              
 other_renewables_share_elec_exc_biofuel other_renewables_share_energy
 Min.   : 0.000                          Min.   : 0.000               
 1st Qu.: 0.000                          1st Qu.: 0.013               
 Median : 0.000                          Median : 0.243               
 Mean   : 0.754                          Mean   : 0.854               
 3rd Qu.: 0.000                          3rd Qu.: 0.858               
 Max.   :48.400                          Max.   :21.583               
 NA's   :18726                           NA's   :19687                
 per_capita_electricity primary_energy_consumption renewables_cons_change_pct
 Min.   :    0.0        Min.   :     0.00          Min.   : -92.641          
 1st Qu.:  579.1        1st Qu.:     7.77          1st Qu.:  -1.265          
 Median : 2372.2        Median :    83.94          Median :   4.393          
 Mean   : 3879.2        Mean   :  4311.41          Mean   :   9.300          
 3rd Qu.: 5581.0        3rd Qu.:   761.69          3rd Qu.:  11.601          
 Max.   :56030.8        Max.   :167787.67          Max.   :7518.203          
 NA's   :17545          NA's   :11918              NA's   :18837             
 renewables_cons_change_twh renewables_consumption renewables_elec_per_capita
 Min.   :-289.297           Min.   :    0.000      Min.   :    0.00          
 1st Qu.:  -0.141           1st Qu.:    7.582      1st Qu.:   21.44          
 Median :   0.993           Median :   45.166      Median :  199.40          
 Mean   :  23.636           Mean   :  572.145      Mean   : 1160.59          
 3rd Qu.:  10.059           3rd Qu.:  260.884      3rd Qu.:  888.93          
 Max.   :1524.703           Max.   :23848.668      Max.   :56030.79          
 NA's   :18621              NA's   :18516          NA's   :16990             
 renewables_electricity renewables_energy_per_capita renewables_share_elec
 Min.   :   0.00        Min.   :     0.0             Min.   :  0.000      
 1st Qu.:   0.18        1st Qu.:   248.6             1st Qu.:  3.768      
 Median :   4.93        Median :  1045.5             Median : 18.360      
 Mean   : 168.64        Mean   :  4609.8             Mean   : 30.038      
 3rd Qu.:  41.83        3rd Qu.:  3489.5             3rd Qu.: 51.571      
 Max.   :8468.98        Max.   :151652.6             Max.   :100.000      
 NA's   :16066          NA's   :19270                NA's   :17161        
 renewables_share_energy solar_cons_change_pct solar_cons_change_twh
 Min.   : 0.000          Min.   :-100.00       Min.   : -4.940      
 1st Qu.: 3.408          1st Qu.:  10.07       1st Qu.:  0.000      
 Median : 7.038          Median :  28.29       Median :  0.000      
 Mean   :11.186          Mean   : 117.55       Mean   :  4.619      
 3rd Qu.:14.741          3rd Qu.:  64.87       3rd Qu.:  0.033      
 Max.   :74.302          Max.   :9900.00       Max.   :676.408      
 NA's   :19208           NA's   :21871         NA's   :19418        
 solar_consumption  solar_elec_per_capita solar_electricity 
 Min.   :   0.000   Min.   :   0.000      Min.   :   0.000  
 1st Qu.:   0.000   1st Qu.:   0.000      1st Qu.:   0.000  
 Median :   0.000   Median :   0.000      Median :   0.000  
 Mean   :  21.548   Mean   :  19.507      Mean   :   7.038  
 3rd Qu.:   0.205   3rd Qu.:   0.493      3rd Qu.:   0.020  
 Max.   :3448.237   Max.   :1483.722      Max.   :1310.020  
 NA's   :19312      NA's   :16963         NA's   :16039     
 solar_energy_per_capita solar_share_elec solar_share_energy
 Min.   :   0.000        Min.   : 0.000   Min.   :0.000     
 1st Qu.:   0.000        1st Qu.: 0.000   1st Qu.:0.000     
 Median :   0.000        Median : 0.000   Median :0.000     
 Mean   :  71.555        Mean   : 0.626   Mean   :0.210     
 3rd Qu.:   4.418        3rd Qu.: 0.096   3rd Qu.:0.018     
 Max.   :3868.360        Max.   :40.000   Max.   :7.586     
 NA's   :19985           NA's   :17146    NA's   :19960     
 wind_cons_change_pct wind_cons_change_twh wind_consumption  
 Min.   :  -100.00    Min.   :-51.208      Min.   :   0.000  
 1st Qu.:     4.03    1st Qu.:  0.000      1st Qu.:   0.000  
 Median :    20.00    Median :  0.000      Median :   0.005  
 Mean   :   267.54    Mean   :  7.314      Mean   :  53.423  
 3rd Qu.:    47.97    3rd Qu.:  0.315      3rd Qu.:   2.358  
 Max.   :242384.84    Max.   :665.413      Max.   :5487.600  
 NA's   :21582        NA's   :19356        NA's   :19251     
 wind_elec_per_capita wind_electricity   wind_energy_per_capita
 Min.   :   0.000     Min.   :   0.000   Min.   :   0.000      
 1st Qu.:   0.000     1st Qu.:   0.000   1st Qu.:   0.000      
 Median :   0.000     Median :   0.000   Median :   0.051      
 Mean   :  62.770     Mean   :  17.530   Mean   : 232.109      
 3rd Qu.:   2.099     3rd Qu.:   0.139   3rd Qu.:  45.523      
 Max.   :3218.151     Max.   :2098.460   Max.   :8422.012      
 NA's   :16925        NA's   :15995      NA's   :19930         
 wind_share_elec  wind_share_energy country_name      
 Min.   : 0.000   Min.   : 0.000    Length:23995      
 1st Qu.: 0.000   1st Qu.: 0.000    Class :character  
 Median : 0.000   Median : 0.003    Mode  :character  
 Mean   : 1.401   Mean   : 0.651                      
 3rd Qu.: 0.372   3rd Qu.: 0.268                      
 Max.   :56.840   Max.   :26.157                      
 NA's   :17110    NA's   :19894                       
 access_to_electricity_percent_of_population
 Min.   :  0.534                            
 1st Qu.: 68.435                            
 Median : 98.291                            
 Mean   : 80.758                            
 3rd Qu.:100.000                            
 Max.   :100.000                            
 NA's   :16647