dwww Home | Show directory contents | Find package

# names_glue affects output names & auto-converts data.table to lazy_dt

    Code
      show_query(step)
    Output
      setnames(dcast(DT, formula = "..." ~ x + y, value.var = c("a", 
      "b"))[, .(a_X_1, a_Y_2, b_X_1, b_Y_2)], c("a_X_1", "a_Y_2", "b_X_1", 
      "b_Y_2"), c("X1_a", "Y2_a", "X1_b", "Y2_b"))

# can sort column names

    Code
      show_query(step)
    Output
      dcast(DT, formula = "..." ~ chr, value.var = "int")[, .(Mon, 
          Tue, Wed)]

# can sort column names with id

    Code
      show_query(step)
    Output
      setcolorder(dcast(DT, formula = id ~ chr, value.var = "int"), 
          c("id", "Mon", "Tue", "Wed"))

# can repair names if requested

    Code
      pivot_wider(df, names_from = lab, values_from = val)
    Error <vctrs_error_names_must_be_unique>
      Names must be unique.
      x These names are duplicated:
        * "x" at locations 1 and 2.
    Code
      pivot_wider(df, names_from = lab, values_from = val, names_repair = "unique")
    Message <rlib_message_name_repair>
      New names:
      * `x` -> `x...1`
      * `x` -> `x...2`
    Output
      Source: local data table [1 x 2]
      Call:   setnames(dcast(copy(DT), formula = x ~ lab, value.var = "val"), 
          1:2, c("x...1", "x...2"))
      
        x...1 x...2
        <dbl> <dbl>
      1     1     2
      
      # Use as.data.table()/as.data.frame()/as_tibble() to access results

Generated by dwww version 1.15 on Tue Jul 2 08:08:14 CEST 2024.