首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >按函数后汇总信息

问按函数后汇总信息
EN

Stack Overflow用户
提问于 2019-04-19 04:56:33
回答 1查看 32关注 0票数 0

如何在by函数中汇总来自pairwise.t.test的所有p值?因此,我想将HW1、HW2、HW3和PG的p.value从pairwise.t.test中提取到一个data.frame中(参见下面的输出示例)。实际上,我有的不仅仅是HW1,HW2,HW3和PG,这只是一个更短的数据。

代码语言:javascript
复制
dflong <- structure(list(moda = structure(c(4L, 4L, 4L, 4L, 4L, 1L, 1L, 
1L, 1L, 1L, 2L, 2L, 2L, 2L, 2L, 3L, 3L, 3L, 3L, 3L, 4L, 4L, 4L, 
4L, 4L, 1L, 1L, 1L, 1L, 1L, 2L, 2L, 2L, 2L, 2L, 3L, 3L, 3L, 3L, 
3L, 4L, 4L, 4L, 4L, 4L, 1L, 1L, 1L, 1L, 1L, 2L, 2L, 2L, 2L, 2L, 
3L, 3L, 3L, 3L, 3L), .Label = c("HW1", "HW2", "HW3", "PG"), class = "factor"), 
    replicates = c(1L, 2L, 3L, 4L, 5L, 6L, 7L, 8L, 9L, 10L, 11L, 
    12L, 13L, 14L, 15L, 16L, 17L, 18L, 19L, 20L, 1L, 2L, 3L, 
    4L, 5L, 6L, 7L, 8L, 9L, 10L, 11L, 12L, 13L, 14L, 15L, 16L, 
    17L, 18L, 19L, 20L, 1L, 2L, 3L, 4L, 5L, 6L, 7L, 8L, 9L, 10L, 
    11L, 12L, 13L, 14L, 15L, 16L, 17L, 18L, 19L, 20L), time = c("t0", 
    "t0", "t0", "t0", "t0", "t0", "t0", "t0", "t0", "t0", "t0", 
    "t0", "t0", "t0", "t0", "t0", "t0", "t0", "t0", "t0", "t14", 
    "t14", "t14", "t14", "t14", "t14", "t14", "t14", "t14", "t14", 
    "t14", "t14", "t14", "t14", "t14", "t14", "t14", "t14", "t14", 
    "t14", "t29", "t29", "t29", "t29", "t29", "t29", "t29", "t29", 
    "t29", "t29", "t29", "t29", "t29", "t29", "t29", "t29", "t29", 
    "t29", "t29", "t29"), unified = c(1096.6, 1304, 1205.2, 1278.9, 
    1221.3, 1090.7, 1022.7, 1071.3, 808.8, 1093.9, 1710.5, 1541.3, 
    1352.3, 1550.8, 1482.8, 1733.1, 1652.2, 1736.2, 1730.2, 1554, 
    263.7, 283, 302.3, 305.3, 288, 314.4, 369.3, 408.5, 408.5, 
    376.9, 295.9, 299.7, 304, 306.9, 309.3, 300.7, 300.6, 298.3, 
    302, 306, 6.68, 6.58, 6.63, 6.44, 6.55, 5.53, 4.56, 3.58, 
    3.84, 4.67, 6.57, 6.62, 6.62, 6.6, 6.62, 6.69, 6.86, 6.99, 
    6.95, 6.81)), row.names = c(NA, -60L), class = "data.frame")

yy <-dflong$unified
xx <-dflong$time
pair <- function(x) {hhg <- pairwise.t.test(yy,xx,data=x, p.adj = "bonf") }
o <-by(dflong$unified, dflong$moda, FUN=pair )

这就是我期望的输出,但是如果它很难编写脚本,它可以是其他的东西。

代码语言:javascript
复制
           HW1      HW2       HW3      PG
t0-t0      1        1        1          1
t0-t14     0.156    0.145    0.487      0.156
t0-t29     0.487    0.789    0.487      0.687
t14-t14    1        1        1          1
t14-t29    0.147    0.148    0.125      0.156
t29-t29    1        1        1          1
EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2019-04-19 05:20:28

下面是使用tidyverse包的一个(冗长的)可能性:

代码语言:javascript
复制
library(tidyverse)
dflong %>% 
  as_tibble %>% 
  select(-replicates) %>% 
  group_by(moda, time) %>% 
  nest(.key = data) %>% 
  {left_join(., ., by = "moda", suffix = c("_1", "_2"))} %>%
  filter(as.numeric(gsub("t", "", time_1)) <= as.numeric(gsub("t", "", time_2))) %>% 
  mutate(time = paste(time_1, time_2, sep = "-")) %>% 
  mutate(pval = map2_dbl(data_1, data_2, ~t.test(.x[[1]], .y[[1]])$p.value)) %>% 
  select(moda, time, pval) %>% 
  spread(moda, pval)

 A tibble: 6 x 5
     time          HW1          HW2          HW3           PG
*   <chr>        <dbl>        <dbl>        <dbl>        <dbl>
1   t0-t0 1.000000e+00 1.000000e+00 1.000000e+00 1.000000e+00
2  t0-t14 1.154305e-04 2.874392e-05 2.544053e-06 6.916064e-06
3  t0-t29 4.647212e-05 1.243158e-05 1.202839e-06 4.619454e-06
4 t14-t14 1.000000e+00 1.000000e+00 1.000000e+00 1.000000e+00
5 t14-t29 2.746895e-05 2.655776e-08 1.945818e-09 2.955209e-06
6 t29-t29 1.000000e+00 1.000000e+00 1.000000e+00 1.000000e+00
票数 2
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/55753634

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档