Wip处理

import pandas as pd

read_file = 'Wip原始(1).xlsx'
save_file = 'Wip处理结果.csv'


def fox(row):
    com = row
    if '.' 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'])).days
    except 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)