excel转csv文件的代码。简单暴力好用

# import pandas as pd
# data = pd.read_excel('novel.xlsx',sheet_name='novel')
# data.to_csv('data.csv',encoding='utf-8')

#!/usr/bin/python3
# -*- coding: utf-8 -*-

# 导入CSV安装包
import csv

import pandas as pd
data = pd.read_excel('experiment.xlsx',sheet_name='experiment')

text=data['text'].tolist()
label=data['label'].tolist()

# 1. 创建文件对象
f = open('experiment.csv','w',encoding='utf-8',newline='')

# 2. 基于文件对象构建 csv写入对象
csv_writer = csv.writer(f,delimiter='\t')

# 3. 构建列表头
csv_writer.writerow(["text","label"])
for i,j in zip(text,label):
    csv_writer.writerow([str(i),int(j)])

# 4. 写入csv文件内容

# csv_writer.writerow(["c",'20','男'])
# csv_writer.writerow(["w",'22','女'])

# 5. 关闭文件
f.close()