我有帶有技能名稱的數據框，我想為這些技能提取唯一的首字母Skill_name InitialsRisk Management RMScope Management SMStakeholder Management StM我嘗試了正則表達式，但在這兩種情況下它都給了我 SM。有任何想法嗎？
2 回答
拉風的咖菲貓
TA貢獻1995條經驗 獲得超2個贊
我建議像下面的代碼片段一樣遍歷名稱，并將所有現有的首字母縮寫保存在一個集合中：
all_names = [
'Risk Management',
'Scope Management',
'Stakeholder Management',
]
seen = set()
def find_initials(name, seen):
first, last = name.split()
for i in range(1, len(last)+1):
for j in range(1, len(first) + 1):
initials = first[:j] + last[:i]
if initials not in seen:
seen.add(initials)
return initials
# full name is found in seen!
for i in range(100):
initials = f'{first}{last}{i}'
if initials not in seen:
seen.add(initials)
return initials
initials = [find_initials(name, seen) for name in all_names]
print(initials) # ['RM', 'SM', 'StM']
呼啦一陣風
TA貢獻1802條經驗 獲得超6個贊
我找到了另一個解決方案
unique = list()
def unique_initials(full_name):
name_list = full_name.split()
initials = ''
for name in name_list:
initials += name[0]
if initials not in unique:
unique.append(initials)
return initials
else:
initials = ''
i=0
for name in name_list:
if i==0:
initials += name[:2]
i +=1
else:
initials += name[0]
return initials
Skills['Initials'] = Skills['Name'].apply(lambda x: unique_initials(x))
添加回答
舉報
0/150
提交
取消