In this example, we will load a dataset from a .csv file, and we will apply different formatting to each column. More interestingly, we will apply conditional formatting to certain columns. This dataset will contain several fields, such as the career, the age, the salary, and whether the person has been contacted.

After that, we can use the table function to calculate the counts using two variables. We then use the same formattable package for coloring the frequencies in this table.

1. Import the libraries:

library(expss)
library(formattable)

2. Load the data and specify the format for each column. For the Person column, we do basic formatting (specifying the color and font weight), and for the Salary column, we use a color scale ranging between two different green colors. For the Contacted column, we define a conditional formatting (green or red) with an appropriate icon:

data = read.csv("/Users/admin/Documents/R_book/person_salary.csv", stringsAsFactors  = FALSE) 
Green = "#71CA97" 
Green2 = "#DeF7E9" 
table__out = data.frame(table(data$Career, data$Age)) 
colnames(table__out) = c("Career", "Age", "Freq") 
formattable(table__out, align =c("c", "c", "c"), list("Freq"= color_tile(Green, Green2))) 

This results in the following output: