Guest User

Untitled

a guest
Nov 20th, 2017
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. library(tidyverse)
  2. library(readxl)
  3.  
  4. file_name <- "australian_marriage_law_postal_survey_2017_-_participation_final.xls"
  5.  
  6. areas <-
  7. read_excel(
  8. path = file_name,
  9. range = "Table 5!A8:A650"),
  10. col_names = "area") %>%
  11. filter(!grepl("Division|Australia$", area)) %>%
  12. mutate(area = gsub("\\([a-z]\\)","",area)) %>%
  13. drop_na()
Add Comment
Please, Sign In to add comment