根据某列索引从原始数据中提取感兴趣行
excel中很常见的操作。例如,根据第一列数据中,1,3,5,7行的数据,从原始数据中提取行。
例如,整个基因表达谱20000个基因,感兴趣的100个,想提取它们的表达值。
注意:必须指定索引来自第几列(默认第一列)
|
输入原始数据
|
sample A-1 A-2 A-3 B-1 B-2 B-3
TSPAN6 5.7 11.7 9.9 5.7 4.5 3.2
TNMD 9.43 10.67 9.39 3.4 2.5 2.3
DPM1 10.59 9.89 8.5 4.2 5.75 2.5
SCYL3 10.38 10.2 8.5 5.1 2.8 2.4
C1orf112 5.75 10.85 10.9 3.9 4.2 2.8
FGR 9.82 10.45 8.5 2.5 3.4 3.5
CFH 8.9 11.02 10.33 5.75 2.4 5.75
FUCA2 10.59 10.67 9.94 6.55 5.75 5.55
GCLC 2.5 5.2 3.5 9.21 9.76 11.47
NFYA 3.5 4.2 2.5 9.21 11.78 5.75
STPG1 4.5 3.2 2.7 9.89 10.72 8.81
NIPAL3 3.5 2.2 1.9 10.85 9.76 9.73
LAS1L 3.5 4.2 3.5 11.33 9.76 10.49
ENPP4 5.1 1.2 5.75 11.22 9.76 8.81
|
|
感兴趣基因
|
TSPAN6
DPM1
GCLC
STPG1
|
| 输出 |
sample A-1 A-2 A-3 B-1 B-2 B-3
TSPAN6 5.7 11.7 9.9 5.7 4.5 3.2
DPM1 10.59 9.89 8.5 4.2 5.75 2.5
GCLC 2.5 5.2 3.5 9.21 9.76 11.47
STPG1 4.5 3.2 2.7 9.89 10.72 8.81
|
如何引用?
建议直接写网址。助力发表7600+篇
(google学术),6000+篇
(知网)论文
正式引用:Tang D, Chen M, Huang X, Zhang G, Zeng L, Zhang G, Wu S, Wang Y.
SRplot: A free online platform for data visualization and graphing. PLoS One. 2023 Nov 9;18(11):e0294236. doi: 10.1371/journal.pone.0294236. PMID: 37943830.
方法章节:Heatmap was plotted by https://www.bioinformatics.com.cn (last accessed on 10 Dec 2024), an online platform for data analysis and visualization.
致谢章节:We thank Mingjie Chen (Shanghai NewCore Biotechnology Co., Ltd.) for providing data analysis and visualization support.