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

112 阅读 0 评论 74 点赞

我是靠谱客的博主俏皮台灯，这篇文章主要介绍python动态处理Excel(将一列拆分成多列)，现在分享给大家，希望可以做个参考。

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
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)