rformattingr-markdown
Rmarkdown: Merge rows in a single column with without disturbing the rest of the table and export to excel
I have been trying to figure this out all morning. I want to collapse rows in a single column without summing the rest of the table. I don't know the proper terminology for what I am trying to do. I need to export the result to Excel, so I don't think I can use kableExtra to solve this as I normally would. Any suggestion will be helpful. The first table is what I have in R. The second table is the desired product.
The data and my R-code is here https://drive.google.com/drive/folders/156RqWANAu2wL-Tr-x_wsdZ_qjEgM_5jM?usp=sharing
Solution
library(dplyr)
library(openxlsx)
# I assume that your data is in a data frame called 'df'
result <- df %>%
group_by(DEPT, Degree) %>%
summarise(across(everything(), sum, na.rm = TRUE))
# Now you can write the result to an Excel file
write.xlsx(result, "output.xlsx")
You can use it with customized parameters in across() function.
This is brief letters and if you give me more information, I'd happy to help you!
- How to put infinity and -infinity on a graph with plot
- Is there a way to make R beep/play a sound at the end of a script?
- Understanding why grepl doesn't appear to be correctly identifying words
- How to modify legend symbol for geom_text using key_glyph?
- In R, how to check if a data.table contains a column and if it doesnt, create it and fill it with NA?
- Adabag package in R
- Group variables into toplevel variables within tbl_summary()
- Scrape Home Run Leaderboard from Baseball Savant using R
- Little hack for ggplot -- an easy way to add a text with the real means and standard deviation when using lines or bars
- How to retrieve Common Table Expressions (CTEs) as a R list?
- R Calculate multiple aggregations on several variables
- How to force shiny to update UI before reactive process finishes
- How to change GitHub Actions OS from macOS to Windows or Ubuntu?
- Assigndifferent paletes to different geoms but same scale
- R: Error "incorrect number of subscripts on matrix" when trying boot with roc
- How do I reference a function parameter inside a data.table with a column of the same name?
- ggraph: adjusting text label position on circular dendrogram
- List all months between two dates in R
- How to get column-wise summary statistics with missing codes?
- How to display only integer values on an axis using ggplot2
- How do I plot two geom_textlines + one geom_bar in a single ggplot?
- Convert Canadian Postal Code to Longitude and Latitude
- Adding percentage instead of observed counts on y axis on R figure
- Compute the Beta function with negative arguments
- Long to wide format based on variable suffixes in tidyverse in R
- ggplot2 0.9.0 automatically dropping unused factor levels from plot legend?
- Testing async ExtendedTask with shinytest2
- Dynamic geom_text() pastes of labels across facets in fact_wrap()
- Check if a directory is empty in R
- Read large number of small files efficiently in R