HW2_IanKennedy

HW2 for DACSS 601. There are four columns of data in the selected spreadsheet. Territory (string), resp (string), count (numerical), and percent (numerical). I also created a new column labeled ‘High Count’ (string) and used the ‘select’ tool to show only the following columns: territory, count, & High_Count

HW2_Data <- read_excel(path = "C:/Users/kenne/Documents/R_Workspace/australian_marriage_tidy.xlsx")
HW2_Data %>%
  arrange(desc(count))%>%
  mutate(High_Count = case_when(count >= 2000000 ~ "High",
                                count < 2000000 ~ "Low" ))%>%
  select(territory, count, High_Count)

# A tibble: 16 x 3
   territory                         count High_Count
   <chr>                             <dbl> <chr>     
 1 New South Wales                 2374362 High      
 2 Victoria                        2145629 High      
 3 New South Wales                 1736838 Low       
 4 Queensland                      1487060 Low       
 5 Victoria                        1161098 Low       
 6 Queensland                       961015 Low       
 7 Western Australia                801575 Low       
 8 South Australia                  592528 Low       
 9 Western Australia                455924 Low       
10 South Australia                  356247 Low       
11 Tasmania                         191948 Low       
12 Australian Capital Territory(c)  175459 Low       
13 Tasmania                         109655 Low       
14 Australian Capital Territory(c)   61520 Low       
15 Northern Territory(b)             48686 Low       
16 Northern Territory(b)             31690 Low