从字符串本身中的单词展开缩写

Question

我有一个dataframe列，每行都有扩展词及其缩写形式。 如何用行中的扩展形式替换缩写

例如— 输入测向

df_1 = pd.DataFrame({'Words':['Chief Environmental Commitment Officer (CECO)', 'Advertising Director (Ad Director)', 'Digital Advertising Manager (Digital Ad Manager)','Postmaster Relief (PMR)']})

输出测向

df_1 = pd.DataFrame({'Words':['Chief Environmental Commitment Officer (CECO)',
'Advertising Director (Ad Director)',
'Digital Advertising Manager (Digital Ad Manager)','Postmaster Relief (PMR)'],
                     'Output':['Chief Environmental Commitment Officer Chief Environmental Commitment Officer',
                               'Advertising Director Advertising Director',
                               'Digital Advertising Manager Digital Advertising Manager',
                               'Postmaster Relief Postmaster Relief']})

我不想创建一个缩略语词典然后替换它们，还有其他方法吗，因为我对python有点陌生

Answer 1

可以使用正则表达式。例如：

import re

def replaceAbb(words):
    words = re.sub(r'(\(CECO\))', 'Chief Environmental Commitment Officer', words)
    # repeat above line for all other abbrevations
    return words

# apply this function over the column in df
df_1['Output'] = df_1['Words'].apply(replaceAbb)

https://regexr.com/是一个很好的测试/构建正则表达式的站点，以防您感到困惑