将列表导入excel并以矩阵形式排列

最新推荐文章于 2022-03-10 16:36:37 发布

原创

最新推荐文章于 2022-03-10 16:36:37 发布 · 1.6k 阅读

1 ·

CC 4.0 BY-SA版权

将 [[(0, 0.043816663), (1, 0.04390042), (2, 0.91228294)], [(0, 0.03811829), (1, 0.03805999), (2, 0.9238217)]]
嵌套列表导入Excel并以矩阵的形式排列

def saveAticleTopicsResultToFile(result,outPutFile):   
    r = []
    i = 1
    for article in result:
        item = {'article_id/topicType':i}
        for topic_result in article:
            item[str(topic_result[0])] = topic_result[1]
        r.append(item)
        i += 1
    writeDataToExcleFile(r,outPutFile)


def test2():
    print ("执行--test2()---satrt")
    all_araticle_results = [[(0, 0.043816663), (1, 0.04390042), (2, 0.91228294)], [(0, 0.03811829), (1, 0.03805999), (2, 0.9238217)], [(0, 0.9325682), (1, 0.03382831), (2, 0.03360352)], [(0, 0.028840436), (1, 0.9424222), (2, 0.028737377)]]
    saveAticleTopicsResultToFile(all_araticle_results,'data_topics.xlsx')
    print ("执行--test2()---complet")

# 执行测试
#topics_r = [(0, '0.004*"dad" + 0.003*"love" + 0.003*"nature" + 0.003*"unit" + 0.003*"friends" + 0.003*"families" + 0.003*"