我的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,我如何使用熊猫来实现呢?
replace
df.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] 删除。
我来说两句