将包含数值列的Pandas数据帧保存为Excel中的文本

pip install pandas

import pandas as pd

data = {'姓名': ['张三', '李四', '王五'],
        '年龄': [25, 30, 35],
        '工资': [5000, 6000, 7000]}
df = pd.DataFrame(data)

df.to_excel('dataframe.xlsx', index=False)

from openpyxl import load_workbook

# 加载Excel文件
book = load_workbook('dataframe.xlsx')

# 选择第一个工作表
writer = pd.ExcelWriter('dataframe.txt', engine='openpyxl')
writer.book = book
writer.sheets = dict((ws.title, ws) for ws in book.worksheets)

# 保存为纯文本格式的Excel文件
writer.save()