groupings: Groupings

In ianmoran11/locatr: Easier Tidying of Data from Spreadsheets

Description

This functions passes grouping expressions to the .groupings argument of locate_groups. It works most naturally with fmt_* functions.

Usage

groupings(...)

Arguments

...	mutate expression to group headers.

Examples

## Not run: 

# 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.