Python使用教程【三】Python提取Excel表格指定列到txt文本中

发布于:2023-04-27 ⋅ 阅读:(144) ⋅ 点赞:(0)

1、源码

import pandas as pd
import numpy as np

tip1 = input('请输入文件名:')
tip2 = input('请输入起始列数: ')
tip3 = input('请输入结束列数: ')

def read_excel(tip1,tip2, tip3):
    data1 = pd.read_excel(str(tip1))
    numpy_data = np.array(data1.iloc[:, int(tip2)+1:int(tip3)+1]).astype(float)
    data = numpy_data.tolist()

    with open('test.txt','w') as file:
        for i in range(len(data)):
            s = str(data[i]).replace('[','').replace(']','')
            s = s.replace("'",'').replace(',','') +'\n'
            file.write(s)
            return '结束'

if __name__ == "__main__":
    read_excel(tip1,tip2, tip3)

2、输入
在这里插入图片描述


网站公告

今日签到

点亮在社区的每一天
去签到