R语言方法
setwd("D:/TCGA_coexpression")
miRNA <- read.table("diff_miRNAExp.txt",row.names=1,header=T,sep="\t",check.names=F)
mRNA <- read.table("diffmRNAExp.txt",row.names=1,header=T,sep="\t",check.names=F)
colnames(miRNA) <- gsub("(....)?-(..)?-(....)?-(...)?.*","\\1-\\2-\\3-\\4",colnames(miRNA)) #此处的?号用于非贪婪匹配,最后的.*可以让最后的替换成功
colnames(mRNA) <- gsub("(....)?-(..)?-(....)?-(...)?.*","\\1-\\2-\\3-\\4",colnames(mRNA))
sameid <- intersect(colnames(miRNA),colnames(mRNA))
merge <- rbind(id=same,miRNA[,sameid],mRNA[,sameid])
write.table(merge,file="merge.txt",sep="\t",quote=F,col.names=F)
miRNALable <- cbind(rownames(miRNA),"miRNA")
mRNALable <- cbind(rownames(mRNA),"gene")
node <- rbind(c("ID","Classify"),miRNALable,mRNALable)
write.table(node,file="nodelable.txt",sep="\t",quote=F,col.names=F,row.names=F)