Wip处理

import pandas as pdread_file = 'Wip原始(1).xlsx'
save_file = 'Wip处理结果.csv'def fox(row):com = rowif '.' in str(com):return int(com * 100)else:return str(com).replace('%', '')def ct(row):# print(row)try:return (pd.to_datetime(row['Wafer_shipping_data']) - pd.to_datetime(row['Wafer_start_date'])).daysexcept Exception as e:return ''df = pd.read_excel(read_file)
print(df)
df["Cycle Time"] = df.apply(ct, axis=1)
df["Total_layers"] = df['Total_layers/Rem.layers'].map(lambda x: x.split('/')[0])
df['Rem_layers'] = df['Total_layers/Rem.layers'].map(lambda x: x.split('/')[-1])
df['Completed'] = df['Completed(%)'].apply(fox)
df['Lot_status'] = ''
df['Remark'] = ''del df['Total_layers/Rem.layers']
del df['Completed(%)']
del df['备注']df.to_csv(save_file, index=False)

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！