python动态处理Excel(将一列拆分成多列)

import pandas as pd
word = ['学生','老师']   # 关键词
book = pd.read_excel('1.xlsx',engine='openpyxl') # 读取excel
for idx, row in book.iterrows():
    try:
        work = str(row['工作单位'])
        for w in word:
            if w in work:
                workLen = len(w)
                job1 = ''
                book.loc[idx, '工作单位'] = job1.join(str(work)[:-workLen]) # 定位
                zhiwu = ''
                book.loc[idx, '职务'] = w
                break
    except Exception as e:
        pass
book.to_excel('2.xlsx', sheet_name='Sheet1', index=False, header=True)