python 如何将print的结果导入excel

如何将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')