如何删除可变长度字符串的一部分

Question

我有一个 DataFrame，其中一列是如下所示的字符串行：Received value 126;AOC;H3498XX from 602Received value 101;KYL;0IMMM0432 from 229我想删除（或不替换）第二个分号之后的部分，使其看起来像Received value 126;AOC; from 602但是我想删除的这部分将具有不同且不可预测的长度（总是 AZ 和 0-9 的组合）。分号和 froms 将始终存在以供参考。我试图通过研究这个链接来使用正则表达式：https : //docs.python.org/3/library/re.htmlimport refor row in df[‘column’]:    row = re.sub(‘;[A-Z0-9] from’ , ‘; from’, row)我认为 [A-Z0-9] 未能结合我想要的不同长度方面。

Answer 1

使用str.replace()with的示例str.split()：

s = ['126;AOC;H3498XX from 602', '101;KYL;0IMMM0432 from 229']

for elem in s:

    print(elem.replace(elem.split(";",2)[-1].split()[0],''))

输出：

126;AOC; from 602

101;KYL; from 229

编辑：

同样适用于以下示例：

s = ['Received value 126;AOC;H3498XX from 602', 'Received value 101;KYL;0IMMM0432 from 229']

for elem in s:

    print(elem.replace(elem.split(";",2)[-1].split()[0],''))

输出：

Received value 126;AOC; from 602

Received value 101;KYL; from 229

Answer 2

使用模式 (Received value \d+;[A-Z]+;)\w+(\s.*?)

前任：

import re

s = ["Received value 126;AOC;H3498XX from 602", "Received value 101;KYL;0IMMM0432 from 229"]

for i in s:

    print( re.sub(r"(Received value \d+;[A-Z]+;)\w+(\s.*?)", r"\1", i) )

输出：

Received value 126;AOC;from 602

Received value 101;KYL;from 229