我的df看起来像，
S2PName S2PName-Category
0 IDLY Food
98 IDLY 4 PARCEL Food
99 IDLY 2 PARCEL Food
100 IDLY 5 PARCEL Food
101 IDLY 3 PARCEL Food
114 IDLY 6 PARCEL Food
我想拥有我的df作为
S2PName S2PName-Category
0 IDLY Food
98 IDLY PARCEL Food
所以我需要检查单词'IDLY'和'PARCEL'，而不管它们之间的数字如何，然后将其重命名为IDLY PARCEL，我如何使用熊猫来实现呢？
replacedf.replace('IDLY\s+\d+\s+PARCEL', r'IDLY PARCEL', regex=True)
S2PName S2PName-Category
0 IDLY Food
98 IDLY PARCEL Food
99 IDLY PARCEL Food
100 IDLY PARCEL Food
101 IDLY PARCEL Food
114 IDLY PARCEL Food
更通用
df.replace('(\w+)\s+\d+\s+(\w+)', r'\1 \2', regex=True)
S2PName S2PName-Category
0 IDLY Food
98 IDLY PARCEL Food
99 IDLY PARCEL Food
100 IDLY PARCEL Food
101 IDLY PARCEL Food
114 IDLY PARCEL Food
本文收集自互联网，转载请注明来源。
如有侵权，请联系 [email protected] 删除。
我来说两句