10.14 Pivot Pairwise Binary Table

20210224 The use case is to turn a table with three columns, consisting of two columns of binary values and the third some measure, into a confusion type matrix.

tibble(a=c(0, 0, 1, 1),
       b=c(0, 1, 0, 1),
       c=c(8346, 275, 2736, 945)) %T>%
  print() %>%
  tidyr::pivot_wider(names_from=b, values_from=c)
## # A tibble: 4 x 3
##       a     b     c
##   <dbl> <dbl> <dbl>
## 1     0     0  8346
## 2     0     1   275
## 3     1     0  2736
## 4     1     1   945
## # A tibble: 2 x 3
##       a   `0`   `1`
##   <dbl> <dbl> <dbl>
## 1     0  8346   275
## 2     1  2736   945


Your donation will support ongoing development and give you access to the PDF version of this book. Desktop Survival Guides include Data Science, GNU/Linux, and MLHub. Books available on Amazon include Data Mining with Rattle and Essentials of Data Science. Popular open source software includes rattle, wajig, and mlhub. Hosted by Togaware, a pioneer of free and open source software since 1984.
Copyright © 1995-2021 Graham.Williams@togaware.com Creative Commons Attribution-ShareAlike 4.0.