use pivot_wider to change only some columns to wide format and keep others in long format in r

library(tidyr)

# Sample data frame
df <- data.frame(
  id = c(1, 1, 2, 2),
  name = c("Alice", "Alice", "Bob", "Bob"),
  attribute = c("height", "weight", "height", "weight"),
  value = c(160, 130, 180, 150)
)

# Using pivot_wider to spread only the 'value' column
result <- df %>%
  pivot_wider(
    id_cols = id:name,
    names_from = attribute,
    values_from = value
  )

# Displaying the result
print(result)
416 chars
21 lines