library(kabel)

library(knitr)
library(dplyr)
## 
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
install.packages("kableExtra",repos = "http://cran.us.r-project.org")
## 
## The downloaded binary packages are in
##  /var/folders/2s/wscqbbmd5_x9v9_5hg7_v6_00000gp/T//RtmpkbNw2W/downloaded_packages
library(kableExtra)
## 
## Attaching package: 'kableExtra'
## The following object is masked from 'package:dplyr':
## 
##     group_rows
join_pprev <- read.csv("/Users/aatmiksaini/join_pprev.csv")
kable(join_pprev) %>%
  kable_styling(bootstrap_options = "bordered")%>%
  column_spec(5,background = ifelse(join_pprev$OTP_detected > 10, "red","yellow"))%>%
  column_spec(6,background = ifelse(join_pprev$OTP_populated < 95, "red","yellow"))%>%
  column_spec(7,background = ifelse(join_pprev$OTP_submitted > 10, "red","yellow"))%>%
  column_spec(8,background = ifelse(join_pprev$dom_check > 10, "red","yellow"))
X merchant_id payment_instrument_group bank OTP_detected OTP_populated OTP_submitted dom_check
1 dreamplug_direct card HDFC 33.33 66.67 33.33 4.76
2 dreamplug_direct net banking HDFCNB 0.00 0.00 0.00 11.75
3 kiranakart net banking AXISNB 0.00 0.00 0.00 10.25
4 myairtel card AXIS 2.97 43.32 3.82 1.63
5 myairtel card CITI 3.38 70.87 0.66 5.04
6 myairtel card HDFC 5.60 73.86 4.84 1.32
7 myairtel card ICICI 2.58 71.03 1.06 1.82
8 myairtel card PAYZAPP 0.00 0.00 0.00 11.82
9 myairtel credit card ICICICC 55.64 14.06 37.46 5.49
10 myairtel credit card RBLCC 11.80 53.57 8.17 1.27
11 myairtel credit card SBICC 3.80 68.72 7.04 0.42
12 myairtel credit card YESCC 20.32 58.06 1.30 0.61
13 myairtel debit card ANDHDC 0.94 55.75 2.11 1.26
14 myairtel debit card AXISDC 0.00 0.00 0.00 12.50
15 myairtel debit card BOMDC 10.47 57.01 2.23 2.57
16 myairtel debit card CANARADC 3.90 63.97 2.69 1.64
17 myairtel debit card CUBDC 0.00 0.00 0.00 7.09
18 myairtel debit card DBSDC 32.35 82.35 32.35 0.98
19 myairtel debit card ICICIDC 31.52 53.54 28.94 1.12
20 myairtel debit card IDBIDC 0.68 57.28 0.75 0.88
21 myairtel debit card INDDC 3.91 65.41 8.29 0.77
22 myairtel debit card IOBDC 13.01 56.85 18.42 2.28
23 myairtel debit card KOTAKDC 8.11 64.86 13.36 0.69
24 myairtel debit card PNBDC 4.35 54.82 6.92 0.63
25 myairtel debit card RBLDC 31.46 42.22 31.46 1.99
26 myairtel debit card SBIDC 0.99 58.16 0.75 0.13
27 myairtel debit card SYNDC 14.16 10.84 5.15 0.92
28 myairtel debit card UBIDC 25.38 48.36 21.33 0.00
29 myairtel debit card YESDC 5.12 73.45 7.63 0.10
30 myairtel net banking AXISNB 4.39 33.72 7.26 0.27
31 myairtel net banking CANARANB 3.70 23.05 2.31 7.12
32 myairtel net banking HDFCNB 7.76 31.02 8.65 0.03
33 myairtel net banking ICICINB 0.85 43.27 2.26 2.97
34 myairtel net banking INDNB 26.50 26.50 26.50 5.88
35 myairtel net banking KOTAKNB 0.00 0.00 0.00 7.39
36 myairtel net banking PNBNB 9.42 6.44 9.42 3.57
37 myairtel net banking SBINB 70.00 0.00 70.00 40.00
38 myairtel net banking TMBNB 0.00 0.00 0.00 20.28
39 myairtel net banking UCONB 0.00 0.00 0.00 7.71