kableExtra collapse_rows not working - reason unknown

[leoncio]

Hello,

I am discovering cool kableExtra features for tables, yet cannot get collapse_rows to work. Can you spot what is wrong with the code?

library(kable)
library(kableExtra)

mtcars <- arrange(mtcars, cyl)
kbl(mtcars) |> kable_classic(full_width=F) |> collapse_rows(columns = 2, valign = "top")

[ganapap1]

@leoncio

library(kable)
library(kableExtra)

mtcars <- arrange(mtcars, cyl)
kbl(mtcars) |> kable_classic(full_width=F) |> collapse_rows(columns = 2, valign = "top")

Hope this is of some use to you
function to collapse_row

#' Collapse the values within a grouped dataframe
#' 
#' 
collapse_rows_df <- function(df, variable){
  group_var <- enquo(variable)
  df %>%
    group_by(!! group_var) %>%
    mutate(groupRow = 1:n()) %>%
    ungroup() %>%
    mutate(!!quo_name(group_var) := ifelse(groupRow == 1, as.character(!! group_var), "")) %>%
    select(-c(groupRow))
}

To execute:
collapse_rows_df(mtcars,cyl)

Credit goes to

How to collapse groups of row values within a table using formattable?

[leoncio]

@ganapap1

collapse_rows_df(mtcars,cyl)

Thanks - this is some workaround indeed.
While the original collapse_rows has nice additional settings, the core task is solved by this function, I will keep it in case nobody has a clue what's wrong with the original, thanks

[ganapap1]

Ok, I understand. in connection with kableExtra table, you may please review my video on my channel "Happy Learning-GP". here is the link: Making Awesome HTML Table with kableExtra package in R - YouTube

[leoncio]

Great, thanks for the link ;D

[cderv]

If your question's been answered (even by you!), would you mind choosing a solution? It helps other people see which questions still need help, or find solutions if they have similar problems. Here’s how to do it:

FAQ: How do I mark a solution?

If your question has been answered, don't forget to mark the solution! How do I mark a solution? Find the reply you want to mark as the solution and look for the row of small gray icons at the bottom of that reply. Click the one that looks like a box with a checkmark in it: [image] Hovering over the mark solution button shows the label, "Select if this reply solves the problem". If you don't see the mark solution button, try clicking the three dots button ( ••• ) to expand the full set of options. When a solution is chosen, the icon turns green and the hover label changes to: "Unselect if this reply no longer solves the problem". Success! [solution_reply_author] …

[leoncio]

Well, sure, but the question has not been answered yet.
@ganapap1 presented a valuable workaround - but the question how to use collapse_rows so it works has not been answered.
Do you think waiting for a solution is futile?

[cderv]

Oh sorry I thought it was my bad.

You could also open a Feature request or an issue with kableExtra repo is something is off.

[leoncio]

Ok, thanks. To be honest I do not know how to open an issue with kableExtra repo.

And to do that I guess I should be quite sure that it is not my coding mistake, which I am not.

[cderv]

@leoncio

To be honest I do not know how to open an issue with kableExtra repo.

The repo of the package is here: GitHub - haozhu233/kableExtra: Construct Complex Table with knitr::kable() + pipe.

[leoncio]

Ok, thanks, the issue is opened

[cderv]

Sharing link here for reference :

collapse_rows not working

[dysonsphere]

Thanks. This really helped me out!