Import your data

data <- read_excel("../00_data/myData.xlsx")
data
## # A tibble: 21,560 × 12
##     year gnis_id geometry   metad…¹ numbe…² parkn…³ region state unit_…⁴ unit_…⁵
##    <dbl>   <dbl> <chr>      <chr>     <dbl> <chr>   <chr>  <chr> <chr>   <chr>  
##  1  1904 1163670 POLYGON    NA            1 Crater… PW     OR    CRLA    Crater…
##  2  1941 1531834 MULTIPOLY… NA            1 Lake R… PW     WA    LARO    Lake R…
##  3  1961 2055170 MULTIPOLY… NA            1 Lewis … PW     WA    LEWI    Lewis …
##  4  1935 1530459 MULTIPOLY… NA            1 Olympic PW     WA    OLYM    Olympi…
##  5  1982  277263 POLYGON    NA            1 Santa … PW     CA    SAMO    Santa …
##  6  1919  578853 MULTIPOLY… NA            1 NA      NE     ME    ACAD    Acadia…
##  7  1969 1329499 MULTIPOLY… NA            1 NA      IM     TX    AMIS    Amista…
##  8  1967  589056 POLYGON    NA            1 NA      NE     MD    ASIS    Assate…
##  9  1944 1377082 POLYGON    NA            1 NA      IM     TX    BIBE    Big Be…
## 10  1989  302659 POLYGON    NA            1 NA      SE     FL    BICY    Big Cy…
## # … with 21,550 more rows, 2 more variables: unit_type <chr>, visitors <dbl>,
## #   and abbreviated variable names ¹​metadata, ²​number_of_records, ³​parkname,
## #   ⁴​unit_code, ⁵​unit_name

Pivoting

long to wide form

N/A

wide to long form

data %>%
    
    pivot_wider(names_from = year,
                values_from = visitors)
## # A tibble: 386 × 124
##    gnis_id geometry metad…¹ numbe…² parkn…³ region state unit_…⁴ unit_…⁵ unit_…⁶
##      <dbl> <chr>    <chr>     <dbl> <chr>   <chr>  <chr> <chr>   <chr>   <chr>  
##  1 1163670 POLYGON  NA            1 Crater… PW     OR    CRLA    Crater… Nation…
##  2 1531834 MULTIPO… NA            1 Lake R… PW     WA    LARO    Lake R… Nation…
##  3 2055170 MULTIPO… NA            1 Lewis … PW     WA    LEWI    Lewis … Nation…
##  4 1530459 MULTIPO… NA            1 Olympic PW     WA    OLYM    Olympi… Nation…
##  5  277263 POLYGON  NA            1 Santa … PW     CA    SAMO    Santa … Nation…
##  6  578853 MULTIPO… NA            1 NA      NE     ME    ACAD    Acadia… Nation…
##  7 1329499 MULTIPO… NA            1 NA      IM     TX    AMIS    Amista… Nation…
##  8  589056 POLYGON  NA            1 NA      NE     MD    ASIS    Assate… Nation…
##  9 1377082 POLYGON  NA            1 NA      IM     TX    BIBE    Big Be… Nation…
## 10  302659 POLYGON  NA            1 NA      SE     FL    BICY    Big Cy… Nation…
## # … with 376 more rows, 114 more variables: `1904` <dbl>, `1941` <dbl>,
## #   `1961` <dbl>, `1935` <dbl>, `1982` <dbl>, `1919` <dbl>, `1969` <dbl>,
## #   `1967` <dbl>, `1944` <dbl>, `1989` <dbl>, `1988` <dbl>, `1993` <dbl>,
## #   `1955` <dbl>, `1976` <dbl>, `1980` <dbl>, `1934` <dbl>, `1951` <dbl>,
## #   `1925` <dbl>, `1948` <dbl>, `1931` <dbl>, `1940` <dbl>, `1971` <dbl>,
## #   `1979` <dbl>, `2011` <dbl>, `2004` <dbl>, `1968` <dbl>, `1984` <dbl>,
## #   `1987` <dbl>, `1985` <dbl>, `1973` <dbl>, `1936` <dbl>, `1992` <dbl>, …

Separating and Uniting

Separate a column

N/A

Unite two columns

data %>%
    
    unite(col = "location", c(state,region), sep = "/")
## # A tibble: 21,560 × 11
##     year gnis_id geome…¹ metad…² numbe…³ parkn…⁴ locat…⁵ unit_…⁶ unit_…⁷ unit_…⁸
##    <dbl>   <dbl> <chr>   <chr>     <dbl> <chr>   <chr>   <chr>   <chr>   <chr>  
##  1  1904 1163670 POLYGON NA            1 Crater… OR/PW   CRLA    Crater… Nation…
##  2  1941 1531834 MULTIP… NA            1 Lake R… WA/PW   LARO    Lake R… Nation…
##  3  1961 2055170 MULTIP… NA            1 Lewis … WA/PW   LEWI    Lewis … Nation…
##  4  1935 1530459 MULTIP… NA            1 Olympic WA/PW   OLYM    Olympi… Nation…
##  5  1982  277263 POLYGON NA            1 Santa … CA/PW   SAMO    Santa … Nation…
##  6  1919  578853 MULTIP… NA            1 NA      ME/NE   ACAD    Acadia… Nation…
##  7  1969 1329499 MULTIP… NA            1 NA      TX/IM   AMIS    Amista… Nation…
##  8  1967  589056 POLYGON NA            1 NA      MD/NE   ASIS    Assate… Nation…
##  9  1944 1377082 POLYGON NA            1 NA      TX/IM   BIBE    Big Be… Nation…
## 10  1989  302659 POLYGON NA            1 NA      FL/SE   BICY    Big Cy… Nation…
## # … with 21,550 more rows, 1 more variable: visitors <dbl>, and abbreviated
## #   variable names ¹​geometry, ²​metadata, ³​number_of_records, ⁴​parkname,
## #   ⁵​location, ⁶​unit_code, ⁷​unit_name, ⁸​unit_type

Missing Values

data %>%
    
    fill(region)
## # A tibble: 21,560 × 12
##     year gnis_id geometry   metad…¹ numbe…² parkn…³ region state unit_…⁴ unit_…⁵
##    <dbl>   <dbl> <chr>      <chr>     <dbl> <chr>   <chr>  <chr> <chr>   <chr>  
##  1  1904 1163670 POLYGON    NA            1 Crater… PW     OR    CRLA    Crater…
##  2  1941 1531834 MULTIPOLY… NA            1 Lake R… PW     WA    LARO    Lake R…
##  3  1961 2055170 MULTIPOLY… NA            1 Lewis … PW     WA    LEWI    Lewis …
##  4  1935 1530459 MULTIPOLY… NA            1 Olympic PW     WA    OLYM    Olympi…
##  5  1982  277263 POLYGON    NA            1 Santa … PW     CA    SAMO    Santa …
##  6  1919  578853 MULTIPOLY… NA            1 NA      NE     ME    ACAD    Acadia…
##  7  1969 1329499 MULTIPOLY… NA            1 NA      IM     TX    AMIS    Amista…
##  8  1967  589056 POLYGON    NA            1 NA      NE     MD    ASIS    Assate…
##  9  1944 1377082 POLYGON    NA            1 NA      IM     TX    BIBE    Big Be…
## 10  1989  302659 POLYGON    NA            1 NA      SE     FL    BICY    Big Cy…
## # … with 21,550 more rows, 2 more variables: unit_type <chr>, visitors <dbl>,
## #   and abbreviated variable names ¹​metadata, ²​number_of_records, ³​parkname,
## #   ⁴​unit_code, ⁵​unit_name