python正则方式过滤掉excel中的某个字

最新推荐文章于 2024-06-23 15:22:06 发布

谁说大象不能跳舞

最新推荐文章于 2024-06-23 15:22:06 发布

阅读量553

点赞数

分类专栏： python

本文链接：https://blog.csdn.net/jiahonhyu0609/article/details/90180181

版权

python 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

import re
with open('C:\\Users\\lvhao\\Desktop\\作者数据处理.txt','r') as f:
    dic = {}
    for line in f:
        linelist = line.split('\t')
        # print(linelist[1])
        keywords = ['著','主编','编','[]',']','撰','【','】']
        name = re.sub('|'.join(keywords),'',linelist[1])
        dic[linelist[0]] = name
with open('C:\\Users\\lvhao\\Desktop\\result.xlsx','w') as file:
    for i in dic:
        file.write(i + '\t' + dic[i])