Most harmful natural events in the US

Synopsis

In this analysis, I study the most harmful natural events in the US. Two criteria are used for this assessment: economic and population health damage caused by natural events. Economic damage is defined as the sum of damage to property and crops. Human health damage is defined as the sum of the number of fatalities and injuries. Our results suggest that tornados are by far the most harmful natural event in relation to population health. As for economic damage, floods are the most harmful natural event.

Data Processing

The NOAA Storm Database is employed for this analysis.

Data transformations:

# Load packages
library(dplyr,warn.conflicts=F, quietly=T)     
library(knitr,warn.conflicts=F, quietly=T)
library(ggplot2,warn.conflicts=F, quietly=T)

# Load data
setwd("C:/Users/Daniel Abreu/OneDrive - ISEG/Documents/coursera")
data <- read.csv("repdata_data_StormData.csv",header=TRUE)

# Convert info on crop and property damage to numeric data
data$PROPEXP[data$PROPDMGEXP == "+"]  <- 0
data$PROPEXP[data$PROPDMGEXP == "-"] <- 0
data$PROPEXP[data$PROPDMGEXP == "?"] <- 0
data$PROPEXP[data$PROPDMGEXP == "K"] <- 1000
data$PROPEXP[data$PROPDMGEXP == "M"] <- 1e+06
data$PROPEXP[data$PROPDMGEXP == ""]  <- 1
data$PROPEXP[data$PROPDMGEXP == "B"] <- 1e+09
data$PROPEXP[data$PROPDMGEXP == "m"] <- 1e+06
data$PROPEXP[data$PROPDMGEXP == "0"] <- 1
data$PROPEXP[data$PROPDMGEXP == "5"] <- 1e+05
data$PROPEXP[data$PROPDMGEXP == "6"] <- 1e+06
data$PROPEXP[data$PROPDMGEXP == "4"] <- 10000
data$PROPEXP[data$PROPDMGEXP == "2"] <- 100
data$PROPEXP[data$PROPDMGEXP == "3"] <- 1000
data$PROPEXP[data$PROPDMGEXP == "h"] <- 100
data$PROPEXP[data$PROPDMGEXP == "7"] <- 1e+07
data$PROPEXP[data$PROPDMGEXP == "H"] <- 100
data$PROPEXP[data$PROPDMGEXP == "1"] <- 10
data$PROPEXP[data$PROPDMGEXP == "8"] <- 1e+08

data$CROPEXP[data$CROPDMGEXP == "M"] <- 1e+06
data$CROPEXP[data$CROPDMGEXP == "K"] <- 1000
data$CROPEXP[data$CROPDMGEXP == "m"] <- 1e+06
data$CROPEXP[data$CROPDMGEXP == "B"] <- 1e+09
data$CROPEXP[data$CROPDMGEXP == "0"] <- 1
data$CROPEXP[data$CROPDMGEXP == "k"] <- 1000
data$CROPEXP[data$CROPDMGEXP == "2"] <- 100
data$CROPEXP[data$CROPDMGEXP == ""]  <- 1
data$CROPEXP[data$CROPDMGEXP == "?"] <- 0

data$PROPDMG <- data$PROPDMG * data$PROPEXP
data$CROPDMG <- data$CROPDMG * data$CROPEXP

# Compute i) sum of fatalities and  injuries by natural event; ii) sum of property and crop damage by natural event
data_pophealth <- data %>%
          group_by(EVTYPE) %>%
          mutate(fatal_inj = FATALITIES + INJURIES) %>%
          summarise(sum_fatalities = sum(FATALITIES), sum_injuries=sum(INJURIES), sum_fatal_inj = sum(fatal_inj)) %>%
          arrange(desc(sum_fatal_inj))
  
data_econdamage <- data %>%
          group_by(EVTYPE) %>%
          mutate(propcropdmg = PROPDMG + CROPDMG)  %>%
          summarise(sum_propdmg = sum(PROPDMG), sum_CROPDMG=sum(CROPDMG), sum_propcropdmg = sum(propcropdmg)) %>%
          arrange(desc(sum_propcropdmg))

Results

num <- rep(1:10)

# Top 10 natural events with highest number of fatalities and injuries

ggplot(data_pophealth[1:10,], aes(x=reorder(EVTYPE,-num),y=sum_fatal_inj)) + 
      geom_bar(stat = "identity", width = 0.5) + 
      ggtitle("Top 10 natural events with highest number of fatalities and injuries") +
      labs(x = "Natural event", y = "Sum of fatalities and injuries") + 
      coord_flip() 

# Top 10 natural events with highest property and crop damage

ggplot(data_econdamage[1:10,], aes(x=reorder(EVTYPE,-num),y=sum_propcropdmg)) + 
      geom_bar(stat = "identity", width = 0.5) + 
      ggtitle("Top 10 natural events with highest property and crop damage") +
      labs(x = "Natural event", y = "Sum of property and crop damage") + 
      coord_flip()