在r/formattable中，如何调整列格式(不包括“总计”行)

Question

在r/formattable中，如何调整不包括total行的列格式？

library(formattable)
df <- data.frame(category=c('a','b','total'),value=c(1,2,3))
formattable(df,list(
  category[-3,] = formatter("span",
                       style = x ~ style(color = "red")
  )
))

Answer 1

我们可以使用ifelse

library(formattable)
formattable(df,list(
  category = formatter("span",
                            style = x ~ ifelse(x != 'total', 
       style(color = "red"), x)
  )
))

​

​

如果是基于“类别”的value列

formattable(df,list(
  value = formatter("span",
                            style = x ~ ifelse(df$category != 
       'total', style(color = "red"), x)
  )
))