如何从文本文件中读取数据，然后使用Python将它们写入Excel文件？

Question

我正在编写代码，从一个已有的文本文件中读取数据，然后通过创建一个新的文件将其写入Excel文件

distance_matrix.txt

[0]

[1, 0]

[13, 12, 0]

[17, 16, 10, 0]

[16, 15, 8, 1, 0]

[13, 12, 4, 5, 4, 0]

[12, 11, 6, 11, 10, 6, 0]

• 我首先打开文本文件，然后读取它并将其存储在一个列表中

  file1 = open("distance_matrix.txt", "r") contents1 = file1.readlines()

• 然后我将内容1存储在另一个列表中（我不确定它是否真的是一个列表，因为当我打印它时，我只得到最后一行！）

    import re
    numbers = []
    for i in contents1:
            numbers = re.split(', |\[|\]', i)
            numbers.remove('')
            numbers.remove('\n')

    for i in numbers:
        print(numbers[0])

• 在那之后，我尝试将它写入一个Excel文件，首先创建一个新的文件，然后写入

    df = pd.DataFrame(
        {#"A":numbers}
    )

    writer = ExcelWriter("MyData.xls")
    df.to_excel(writer,"sheet1", index = False)
    writer.save()

My question is how would I write this triangle shape inside the Excel file with a header to each column after taking those numbers from the text file?

A B C D E F G

[0]

[1, 0]

[13, 12, 0]

[17, 16, 10, 0]

[16, 15, 8, 1, 0]

[13, 12, 4, 5, 4, 0]

[12, 11, 6, 11, 10, 6, 0]

Answer 1

默认情况下，头是True

DataFrame.to_excel(self, excel_writer, sheet_name='Sheet1', na_rep='', float_format=None, columns=None, header=True, index=True, index_label=None, startrow=0, startcol=0, engine=None, merge_cells=True, encoding=None, inf_rep='inf', verbose=True, freeze_panes=None)

尝试添加header=False

df = pd.DataFrame(
        {#"A":numbers}
    )

    writer = ExcelWriter("MyData.xls")
    df.to_excel(writer,"sheet1", index = False, header=False)
    writer.save()