Python操作Excel自动化开发源代码

# pip install pandas # pip 安装工具 install 安装 pandas 模块 import pandas as pd # 读入文件 data = pd.read_excel('shuju.xlsx') data['year'] = data['type'].apply(lambda x:x.split('/')[0].strip()) data['c'] = data['type'].apply(lambda x:x.split('/')[1].strip()) data['t'] = data['type'].apply(lambda x:x.split('/')[2].strip()) writer = pd.ExcelWriter('temp.xlsx') # data.to_excel(writer,sheet_name='原始数据') # 根据年限分割 # for i in data['year'].unique(): # data[data['year'] == i].to_excel(writer,sheet_name=i) # 根据类型分割 type_list = set(z for i in data['t'] for z in i.split(' ')) type_list.remove('1978(中国大陆)') for ty in type_list: data[data['t'].str.contains(ty)].to_excel(writer,sheet_name=ty) writer.close()