如何在Rmarkdown的kable生成LaTeX表格中合并指定表头

Got it, let's fix that table header exactly how you want it. Here's a modified kableExtra approach that achieves merged, centered headers for Species and Percentage Change (with its description) across both header rows, while keeping the "Parts" section properly grouped over the four measurement columns.

Step 1: Updated R Markdown Code #

First, we'll adjust the kable column names and use LaTeX's multirow (via add_header_above) to create the cross-row headers. Don't forget to load the multirow package in your header includes!

---
output: pdf_document
header-includes: 
  - \usepackage{xcolor}
  - \usepackage{multirow} # Required for cross-row header merging
---

library(kableExtra)
library(tidyr)
library(dplyr)
data(iris)

# Generate the summary table as before
iris_summary <- iris %>% 
  as_tibble() %>% 
  gather(key = variable, value = value, -Species) %>% 
  group_by(Species, variable) %>% 
  summarise(value = mean(value), .groups = "drop") %>% 
  spread(key = variable, value = value) %>% 
  mutate(`Percentage Change` = `Petal.Length`/`Petal.Width`*100)

# Build the table with merged headers
iris_summary %>% 
  kable(
    format = 'latex', 
    align = 'c', 
    linesep = '', 
    booktabs = TRUE, 
    escape = FALSE,
    # Leave first/last column headers blank (we'll fill them via multirow)
    col.names = c("", "Sepal.Length", "Sepal.Width", "Petal.Length", "Petal.Width", "")
  ) %>% 
  add_header_above(
    header = c(
      # Cross-row header for Species, centered
      "\\multirow{2}{*}{\\centering Species}" = 1,
      # Group header for the 4 measurement columns
      "Parts" = 4,
      # Cross-row header for Percentage Change, with line-broken description
      "\\multirow{2}{*}{\\centering Percentage Change\\\\(Petal Length/Petal Width)}" = 1
    ),
    escape = FALSE
  ) %>% 
  kable_styling(
    latex_options = c('striped', 'HOLD_position', 'scale_down')
  ) %>% 
  # Optional: Adjust column widths for better header fit
  column_spec(1, width = "2cm") %>% 
  column_spec(6, width = "3cm")

How This Works #

1. Blank Base Headers: We set the first and last columns of the base table header to empty strings. This lets the multirow headers from the top row span down into the second row without overlapping text.
2. multirow Command: The \multirow{2}{*}{...} LaTeX command tells the table to span the header text across 2 rows. \centering ensures the text is centered vertically and horizontally in the merged space.
3. Line-Broken Description: For Percentage Change, we use \\\\ (double backslash in R strings) to add a line break for the "(Petal Length/Petal Width)" note, keeping it neatly within the merged header.

Alternative LaTeX Manual Fix #

If you prefer to tweak the generated LaTeX code directly (after knitting once), look for the tabular environment and modify the header rows like this:

\begin{tabular}{cccccc}
\toprule
\multirow{2}{*}{\centering Species} & \multicolumn{4}{c}{Parts} & \multirow{2}{*}{\centering Percentage Change\\(Petal Length/Petal Width)} \\
& Sepal.Length & Sepal.Width & Petal.Length & Petal.Width & \\
\midrule
...
\end{tabular}

This achieves the same result by manually defining the cross-row and merged-column headers directly in LaTeX.

内容的提问来源于stack exchange，提问作者lokheart