如何将print(ppi.scorePPITreesP(proteinsA, proteinsB))的结果倒入excel表格???
import numpy as np
from matplotlib import pyplot as plt
from sklearn import manifold
import PPI as ppi
# Fanconia Anemia proteins files
# shall exist in the sub-folder ./PPIData. These files contain the corresponding protein sequences from Fanconia Anemia
proteinNames = ['FAAP24', 'FANCM', 'FANCC', 'FANCD2', 'FANCI', 'FANCL', 'FANCE', 'FANCG', 'FANCF', 'FANCB', 'FANCA', 'FAAP100', 'FAAP20']
n = len(proteinNames)
n = len(proteinNames)
distM = np.zeros([n, n])
distV = []
for i in range(0, n):
nameA = proteinNames[i]
proteinsA = ppi.getAllSequences(nameA) # The Fanconi Anemia file: one file contain the same protein for different geneomes
print(nameA, len(proteinsA))
for j in range(0, n):
nameB = proteinNames[j]
proteinsB = ppi.getAllSequences(nameB)
print(nameB, len(proteinsB))
dist = 1 - ppi.scorePPITreesP(proteinsA, proteinsB)
distV.append(dist)
distM[i, j] = dist
print(nameA, nameB, dist)
print(ppi.scorePPITreesP(proteinsA, proteinsB))
print(distM)
print()
'''
'''
print(ppi.scorePPITreesP(proteinsA, proteinsB))的结果如下所示:
https://blog.csdn.net/weixin_41770169/article/details/90053602
import numpy as np
import xlwt
#读入数据
data_file = 'D:/.../ionosphere.data'
#分隔数据存入二维数组
data = np.genfromtxt(data_file, delimiter=',', dtype='|S10')
#创建工作簿
book = xlwt.Workbook()
#创建表单
sheet1 = book.add_sheet(u'sheet1',cell_overwrite_ok=True)
#按i行j列顺序依次存入表格
for i in range(data.shape[0]):
for j in range(data.shape[1]):
sheet1.write(i,j,data[i][j])
#保存文件
book.save('D:/work/Trans_data/test.xls')