在GraphPad棱镜中使用R型数据

Question

我使用R进行数据分析，但我实验室的其他人都使用GraphPad棱镜，我也被要求使用该软件展示我的数据。在R中，我习惯于以一种“每行一次观察”的方式处理数据，因此我可能有类似于

Sample  Gene    treatment   fold change
1       GBP1    no IFN      -0,11
2       GBP1    no IFN      -0,05
3       GBP1    no IFN       0,02
4       GBP1    IFN          300
5       GBP1    IFN          200
6       GBP1    IFN          400
1       GBP2    no IFN      -0,5
2       GBP2    no IFN      -0,55
3       GBP2    no IFN       0,3
4       GBP2    IFN          100
5       GBP2    IFN          140
6       GBP2    IFN          200

而Graphpad则希望数据的结构像这样

       no IFN 1    no IFN 2    no IFN 3    IFN 1    IFN 2    INF3
GBP1   -0,11       -0,05       0,02        300      200      400
GBP2   -0,5        -0,55       0,3         100      140      200

所以，我想知道是否有人知道将R样式数据导入GraphPad Prism 8的方法？我以一种强有力的方式把它和R自己转换成了失败。

最好的

尼可拉斯

Answer 1

您可以删除Sample列，为treatment列添加一个数字，然后使用pivot_wider以宽格式获取数据。

library(dplyr)

df %>%
  select(-Sample) %>%
  group_by(Gene, treatment) %>%
  mutate(treatment = paste0(treatment, row_number())) %>%
  tidyr::pivot_wider(names_from = treatment, values_from = fold_change)

# Gene  noIFN1 noIFN2 noIFN3 IFN1  IFN2  IFN3 
#  <chr> <chr>  <chr>  <chr>  <chr> <chr> <chr>
#1 GBP1  -0,11  -0,05  0,02   300   200   400  
#2 GBP2  -0,5   -0,55  0,3    100   140   200  

数据

df <- structure(list(Sample = c(1L, 2L, 3L, 4L, 5L, 6L, 1L, 2L, 3L, 
4L, 5L, 6L), Gene = c("GBP1", "GBP1", "GBP1", "GBP1", "GBP1", 
"GBP1", "GBP2", "GBP2", "GBP2", "GBP2", "GBP2", "GBP2"), treatment = c("noIFN", 
"noIFN", "noIFN", "IFN", "IFN", "IFN", "noIFN", "noIFN", "noIFN", 
"IFN", "IFN", "IFN"), fold_change = c("-0,11", "-0,05", "0,02", 
"300", "200", "400", "-0,5", "-0,55", "0,3", "100", "140", "200"
)), class = "data.frame", row.names = c(NA, -12L))