R中双向表中变量的均值

Question

我试着用观察的平均值得到一个双向的表格。我的数据就像这样

df
 ID       value  Cl   Dom          Con
 <chr>    <dbl> <chr> <chr>        <chr>     
 G1-MAT1      1 B     Knowing      Ar
 G1-MAT2      0 B     Knowing      Ar
 G1-MAT3      0 B     Knowing      Ar
 G1-MAT4      1 C     Knowing      Ar
 G1-MAT5      1 B     Knowing      Ar
 G1-MAT6      0 B     Reasoning    Me
 G1-MAT7      1 B     Reasoning    Ar
 G1-MAT8      1 C     Reasoning    Ar
 G1-MAT9      1 B     Knowing      Me
 G1-MAT10     0 B     Knowing      Ar

我正试着用蒂迪弗斯得到这样的东西。

  Dom              Ar       Me
  <chr>            <dbl>    <dbl>
  Reasoning        1        0
  Knowing          0.5      1

其中的条目是观察的手段。有可能吗？

Answer 1

在基数R中：

xtabs(value~., aggregate(value~Dom + Con, df, mean))

           Con
Dom          Ar  Me
  Knowing   0.5 1.0
  Reasoning 1.0 0.0

您可以使用reshape

reshape(aggregate(value~Dom + Con, df, mean), 
             timevar =  'Con', idvar = 'Dom', dir = 'wide')
        Dom value.Ar value.Me
1   Knowing      0.5        1
2 Reasoning      1.0        0