Created on Mon Jun 1 21:54:13 2026

Data Processing

Importing dataset

## New names:
## • `Total Number of deaths` -> `Total Number of deaths...3`
## • `Total number of people affected` -> `Total number of people affected...4`
## • `Total Number of deaths` -> `Total Number of deaths...6`
## • `Total number of people affected` -> `Total number of people affected...7`

Component 1 - Water Availability

## [1] "code"                                      
## [2] "countryc1"                                 
## [3] "Total renewable water resources per capita"
## [4] "Interannual variability"                   
## [5] "Water Independence"
Total
(N=186)
Total renewable water resources per capita
Mean (SD) 16900 (45500)
Median [Min, Max] 3450 [0, 447000]
Interannual variability
Mean (SD) 1.77 (0.893)
Median [Min, Max] 1.50 [0.600, 4.90]
Water Independence
Mean (SD) 35.6 (30.7)
Median [Min, Max] 29.8 [0.300, 100]
##      code            countryc1        
##  Length:186         Length:186        
##  Class :character   Class :character  
##  Mode  :character   Mode  :character  
##                                       
##                                       
##                                       
##                                       
##  Total renewable water resources per capita Interannual variability
##  Min.   :     0                             Min.   :0.600          
##  1st Qu.:  1283                             1st Qu.:1.100          
##  Median :  3447                             Median :1.500          
##  Mean   : 16910                             Mean   :1.771          
##  3rd Qu.: 14416                             3rd Qu.:2.400          
##  Max.   :446950                             Max.   :4.900          
##  NA's   :1                                  NA's   :25             
##  Water Independence
##  Min.   :  0.30    
##  1st Qu.:  7.30    
##  Median : 29.80    
##  Mean   : 35.61    
##  3rd Qu.: 60.90    
##  Max.   :100.00    
##  NA's   :63
## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.

Component 2 - Ambient Water Quality

##      code            countryc2        
##  Length:186         Length:186        
##  Class :character   Class :character  
##  Mode  :character   Mode  :character  
##                                       
##                                       
##                                       
##                                       
##  Proportion of water bodies with good ambient water quality
##  Min.   :  4.50                                            
##  1st Qu.: 50.00                                            
##  Median : 69.61                                            
##  Mean   : 64.10                                            
##  3rd Qu.: 83.80                                            
##  Max.   :100.00                                            
##  NA's   :68

Component 3 - Drinking water Access

##      code            countryc3        
##  Length:186         Length:186        
##  Class :character   Class :character  
##  Mode  :character   Mode  :character  
##  Proportion of HH using safely managed drinking water services
##  Length:186                                                   
##  Class :character                                             
##  Mode  :character                                             
##  Proportion using Basic drinking water services
##  Length:186                                    
##  Class :character                              
##  Mode  :character

Component 4 - Sanitation and Hygiene

##      code            countryc4        
##  Length:186         Length:186        
##  Class :character   Class :character  
##  Mode  :character   Mode  :character  
##                                       
##                                       
##                                       
##                                       
##  Proportion using safely managed sanitation services
##  Min.   : 0.00                                      
##  1st Qu.:27.75                                      
##  Median :56.50                                      
##  Mean   :56.10                                      
##  3rd Qu.:84.25                                      
##  Max.   :99.00                                      
##  NA's   :62                                         
##  Proportion having Basic sanitation access
##  Min.   :10.00                            
##  1st Qu.:63.75                            
##  Median :92.00                            
##  Mean   :78.66                            
##  3rd Qu.:99.00                            
##  Max.   :99.50                            
##  NA's   :2                                
##  Proportion having basic hygiene access
##  Min.   : 0.00                         
##  1st Qu.:23.50                         
##  Median :58.00                         
##  Mean   :55.64                         
##  3rd Qu.:86.00                         
##  Max.   :99.00                         
##  NA's   :91

Component 6 - Health of Water-Dependent Ecosystem

##      code            countryc6        
##  Length:186         Length:186        
##  Class :character   Class :character  
##  Mode  :character   Mode  :character  
##                                       
##                                       
##                                       
##                                       
##  % Change in extent of water-related ecosystems over time
##  Min.   :-58.052                                         
##  1st Qu.:  1.439                                         
##  Median :  9.302                                         
##  Mean   : 16.236                                         
##  3rd Qu.: 17.602                                         
##  Max.   :299.552                                         
##  NA's   :6

Component 7 - Water Productivity

##      code            countryc7         Water use efficiency
##  Length:186         Length:186         Min.   :   0.60     
##  Class :character   Class :character   1st Qu.:   6.95     
##  Mode  :character   Mode  :character   Median :  14.65     
##                                        Mean   :  50.66     
##                                        3rd Qu.:  50.12     
##                                        Max.   :1362.00     
##                                        NA's   :18

Component 8 - Water Governance & Enabling Environment

##      code            countryc8         Degree of IWRM Implementation
##  Length:186         Length:186         Min.   : 12.00               
##  Class :character   Class :character   1st Qu.: 40.00               
##  Mode  :character   Mode  :character   Median : 55.50               
##                                        Mean   : 56.70               
##                                        3rd Qu.: 70.25               
##                                        Max.   :100.00               
##                                        NA's   :2                    
##  WGI_Voice & Accountability WGI_\r\nGovernment Effectiveness
##  Min.   :16.77              Min.   : 9.09                   
##  1st Qu.:38.64              1st Qu.:37.37                   
##  Median :54.63              Median :49.45                   
##  Mean   :53.53              Mean   :51.06                   
##  3rd Qu.:65.81              3rd Qu.:63.44                   
##  Max.   :90.62              Max.   :95.67                   
##  NA's   :1                  NA's   :1                       
##  WGI_Political Stability WGI_Regulatory Quality WGI_Rule of Law
##  Min.   :18.91           Min.   :22.76          Min.   :19.01  
##  1st Qu.:54.22           1st Qu.:42.90          1st Qu.:40.69  
##  Median :64.71           Median :52.64          Median :52.64  
##  Mean   :63.35           Mean   :53.49          Mean   :54.25  
##  3rd Qu.:76.12           3rd Qu.:62.62          3rd Qu.:66.89  
##  Max.   :91.51           Max.   :88.49          Max.   :91.75  
##  NA's   :1               NA's   :1              NA's   :1      
##  WGI_Control of Corruption
##  Min.   : 6.06            
##  1st Qu.:28.89            
##  Median :41.90            
##  Mean   :45.55            
##  3rd Qu.:60.52            
##  Max.   :94.16            
##  NA's   :1

Component 9 - Water and Climate disasters

##      code            countryc9         Total Number of deaths...3
##  Length:186         Length:186         Min.   :   0.0            
##  Class :character   Class :character   1st Qu.:   4.0            
##  Mode  :character   Mode  :character   Median :  18.5            
##                                        Mean   : 284.3            
##                                        3rd Qu.: 138.0            
##                                        Max.   :8073.0            
##                                        NA's   :42                
##  Total number of people affected...4 Flood frequency 
##  Min.   :       0                    Min.   : 1.000  
##  1st Qu.:   19223                    1st Qu.: 2.000  
##  Median :  204880                    Median : 5.000  
##  Mean   : 3620305                    Mean   : 7.819  
##  3rd Qu.: 2390508                    3rd Qu.: 9.000  
##  Max.   :42149278                    Max.   :84.000  
##  NA's   :42                          NA's   :42      
##  Total Number of deaths...6 Total number of people affected...7
##  Min.   :  10.0             Min.   :   10300                   
##  1st Qu.: 241.0             1st Qu.:  653787                   
##  Median : 472.0             Median : 2185846                   
##  Mean   : 982.3             Mean   : 5876288                   
##  3rd Qu.:1468.5             3rd Qu.: 8020173                   
##  Max.   :2465.0             Max.   :30900000                   
##  NA's   :183                NA's   :142                        
##  Drought frequency
##  Min.   :1.000    
##  1st Qu.:1.000    
##  Median :1.000    
##  Mean   :1.417    
##  3rd Qu.:1.250    
##  Max.   :5.000    
##  NA's   :138
## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.

## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.

## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.

## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.

## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.

## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.

Component 10 - Water Resource Vulnerability

##      code            countryc10        Water Resource Vulnerability Index
##  Length:186         Length:186         Min.   :0.00000                   
##  Class :character   Class :character   1st Qu.:0.06725                   
##  Mode  :character   Mode  :character   Median :0.13800                   
##                                        Mean   :0.15947                   
##                                        3rd Qu.:0.21725                   
##                                        Max.   :0.57200                   
##                                        NA's   :26                        
##  GDP per Capita     Future Climate Change Projections
##  Min.   :   219.4   Min.   :0.000                    
##  1st Qu.:  2466.7   1st Qu.:2.325                    
##  Median :  7122.8   Median :3.600                    
##  Mean   : 17523.8   Mean   :3.819                    
##  3rd Qu.: 23920.0   3rd Qu.:5.000                    
##  Max.   :137781.7   Max.   :8.800                    
##  NA's   :2
## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.

## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.

## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.

## [1] "code"                                                      
## [2] "countryc1"                                                 
## [3] "Total renewable water resources per capita"                
## [4] "Interannual variability"                                   
## [5] "Water Independence"                                        
## [6] "countryc2"                                                 
## [7] "Proportion of water bodies with good ambient water quality"