Ns126:Calendar/NOTES/2015-4-21

From ZhangLabWiki
Revision as of 18:45, 21 April 2015 by >Shicheng
Jump to navigation Jump to search


  • Now, I do know how to insert figures, but I don't know how to insert tables into MediaWiki. Therefore, I write a small code to transfer routine table to wikitable.
  • I must say: mediawiki is really a excellent tool to manage the lab and monitor the progress or task to help us complete the project quickly.
perl table2wikitable.pl input.table.txt
#!/usr/bin/perl
#table2wikitable.pl
use strict;
use Cwd;
chdir getcwd;

my $input=@ARGV[0];

open F,$input;
print "{| class=\"wikitable\" style=\"text-align: right; color: red;\"\n";
while(<F>){
chomp;
my @line=split /\t/;
my $tmp=join("||",@line);
print "| $tmp\n|-\n";
}
print"|}\n";
 


  • corresponding table is as the following. Pan-Cancer Methylation 450K dataset were collected from TCGA Project to identify optional padloc regions.
Symbol Case Control Cancer 肿瘤名称
KIRC 160 160 Kidney renal clear cell carcinoma 肾透明细胞癌
BRCA 92 92 Breast invasive carcinoma 浸润性乳腺癌
THCA 56 56 Thyroid carcinoma 甲状腺癌
HNSC 50 50 Head and Neck squamous cell carcinoma 头颈部鳞状细胞癌
PRAD 49 49 Prostate adenocarcinoma 前列腺癌
LIHC 49 49 Liver hepatocellular carcinoma 肝癌
KIRP 45 45 Kidney renal papillary cell carcinoma 肾乳头状细胞癌
LUSC 41 41 Lung squamous cell carcinoma 肺腺癌
COAD 39 39 Colon adenocarcinoma 结肠癌
UCEC 30 30 Uterine Corpus Endometrial carcinoma 子宫内膜癌
LUAD 26 26 Lung adenocarcinoma 肺鳞癌