r - 如何对 r 中的所有列进行计数和 dcast

Question

我在 r 中有以下数据框

     Company     Education    Health      
        A           NA          1              
        A           1           2             
        A           1           NA            

我想要以下格式的每列 (1,2,NA) 中的级别计数

     Company     Education_1   Education_NA   Health_1    Health_2    Health_NA
       A            2             1             1            1            1 

我如何在 R 中做到这一点？

Answer 1

您可以执行以下操作:

library(tidyverse)
df %>%
    gather(k, v, -Company) %>%
    unite(tmp, k, v, sep = "_") %>%
    count(Company, tmp) %>%
    spread(tmp, n)
## A tibble: 1 x 6
#  Company Education_1 Education_NA Health_1 Health_2 Health_NA
#  <fct>         <int>        <int>    <int>    <int>     <int>
#1 A                 2            1        1        1         1

---

示例数据

df <- read.table(text =
    "     Company     Education    Health
        A           NA          1
        A           1           2
        A           1           NA         ", header = T)