如何用Python把两个txt合并成一个excel

在Python里实现如图这样 让文件夹下的两个txt合并到excel里。

你题目的解答代码如下：（如有帮助，望采纳！谢谢! 点击我这个回答右上方的【采纳】按钮）

import pandas as pd
data = {
    "数据1":[],
    "数据2":[]
}
with open(r'01.txt', 'r', encoding='utf-8') as f1:
    for v in f1:
        data["数据1"].append(v.strip())
with open(r'02.txt', 'r', encoding='utf-8') as f2:
    for v in f2:
        data["数据2"].append(v.strip())
df = pd.DataFrame(data)
print(df)
df.to_excel(r'xxxx.xlsx',index=None)

import pandas as pd
a = pd.read_csv('1.txt',header=None,names=['data1'])
b = pd.read_csv('2.txt',header=None,names=['data2'])
pd.concat([a,b],axis=1).to_excel('3.xlsx',index=None)