hook_if: Supply an expression to identify which header groups are...

Description Usage Arguments Examples

View source: R/hook_if.R

Description

This function is used with the .hook_if or .hook_if_rev arguments in the locate_groups function. This expression must evaluate to a single value for each header group. For example, see below that any(fmt_alignment_indent == 0) is used rather that fmt_alignment_indent == 0.

It passes an expression to dplyr::summarise that identifies which header groups are hooked

Usage

1

Arguments

...

expression applied to a identifies which header groups are hooked

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
## Not run: 


library(tidyverse)

# Read in tidyxl data frame
xl_df <-
  locatr_example("worked-examples.xlsx") %>%
  xlsx_cells_fmt(sheets = "pivot-hierarchy") %>%
  append_fmt(fmt_alignment_indent)

# Add location annotations
xl_df <-
  xl_df %>%
  locate_data(data_type == "numeric") %>%
  locate_groups(
    direction = "W",
    .groupings = groupings(fmt_alignment_indent),
    .hook_if = hook_if(any(fmt_alignment_indent == 0))
  ) %>%
  locate(direction = "N", name = student)

# Use `migrate` to reshape the data frame such that each data cells has its own row and each
 header variable has its own column.
xl_df %>% migrate()

## End(Not run)

ianmoran11/locatr documentation built on June 14, 2020, 3:32 a.m.