Ns126:Calendar/NOTES/2015-4-21
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 | 肺鳞癌 |