python处理excel文件

import pandas as pd
 
# 假设你的TXT文件名为'my_file.txt'，并且使用逗号作为分隔符
df = pd.read_excel('./打标.xlsx')
relations = list(df['标签'].unique())


with open('./label.txt','a',encoding='utf-8') as fp:
    for i in relations:
        fp.write(i+'\n')


label_list = list(df['标签'])
text_list = list(df['法律文本'])

with open('./train.txt','a',encoding='utf-8') as fp:
    for i,j in zip(label_list,text_list):
        final_txt = i + '\t' + j + '\n'
        fp.write(final_txt)