elsx文件转为csv并隔三取一

elsx文件转为csv并隔三取一

import csv
import pandas as pd

#转换xlsx文件为csv文件
def xlsx_to_csv_pd():
    data_xls = pd.read_excel(file_dress+'.xlsx', index_col=0)
    data_xls.to_csv(file_dress+'.csv', encoding='utf-8')


def deal_csv(file_dress,save_dress):
    with open(file_dress,'r') as f:
        reader=csv.DictReader(f)
        filedata=[]
        for row in reader:
            filedata.append(row['data'])
        print('filedata:', filedata[:10])
        #[0:-1:x]其中x决定几个中取一个，若3个中娶一个则x=3
        filedata = filedata[0:-1:3]
        name = ['data']
        test = pd.DataFrame(columns=name, data=filedata)
        print(test)
        test.to_csv(save_dress+'.csv', encoding='gbk')

if __name__=='__main__':
    file_dress='/home/had/Desktop/a/447-50'
    save_dress='/home/had/Desktop/a/447-51'
    xlsx_to_csv_pd()
    deal_csv(file_dress+'.csv',save_dress)