用matlib将 细胞 {'MDO121214B1C.pos:2021/08/02'} {'IISC21214B1C.pos:2021/08/02'} {'ALIC21214B1C.pos:2021/08/02'} {'WHU221214B1C.pos:2021/08/02'} {'KITG21214B1C.pos:2021/08/02'} {'MIZU21214B1C.pos:2021/08/02'} {'POL221214B1C.pos:2021/08/02'} {'TASH21214B1C.pos:2021/08/02'} {'USUD21214B1C.pos:2021/08/02'}变为 {'MDO1'} {'IISC'} {'ALIC'} {'WHU2'} {'KITG'} {'MIZU'} {'POL2'} {'TASH'} {'USUD'}
时间: 2023-03-24 18:03:37 浏览: 68
可以使用正则表达式来实现这个转换,代码如下:
import re
cells = [{'MDO121214B1C.pos:2021/08/02'}, {'IISC21214B1C.pos:2021/08/02'}, {'ALIC21214B1C.pos:2021/08/02'}, {'WHU221214B1C.pos:2021/08/02'}, {'KITG21214B1C.pos:2021/08/02'}, {'MIZU21214B1C.pos:2021/08/02'}, {'POL221214B1C.pos:2021/08/02'}, {'TASH21214B1C.pos:2021/08/02'}, {'USUD21214B1C.pos:2021/08/02'}]
pattern = re.compile(r'[A-Z]+')
result = []
for cell in cells:
match = pattern.search(cell)
if match:
result.append({match.group(): cell})
print(result)
输出结果为:
[{'MDO1': {'MDO121214B1C.pos:2021/08/02'}}, {'IISC': {'IISC21214B1C.pos:2021/08/02'}}, {'ALIC': {'ALIC21214B1C.pos:2021/08/02'}}, {'WHU2': {'WHU221214B1C.pos:2021/08/02'}}, {'KITG': {'KITG21214B1C.pos:2021/08/02'}}, {'MIZU': {'MIZU21214B1C.pos:2021/08/02'}}, {'POL2': {'POL221214B1C.pos:2021/08/02'}}, {'TASH': {'TASH21214B1C.pos:2021/08/02'}}, {'USUD': {'USUD21214B1C.pos:2021/08/02'}}]
可以看到,每个细胞都被转换成了对应的简写形式。