擅长:python、mysql、java
<p><a href="http://pandas.pydata.org/" rel="nofollow">^{<cd1>}</a>为这种类型的字符串替换提供了一些很好的语法。如果您的csv文件非常大,它可能非常适合:</p>
<pre><code>In [76]:
print df
val
0 win-abc123
1 def456-windows
2 123123-WIN-ghi789
3 rhel-jkl012
4 45u8234dgf-redhat-mno345
5 pqr678-RHEL
In [77]:
df['val'] = df.val.str.replace(r'\b(win|windows|WIN)\b', 'WIN')
df['val'] = df.val.str.replace(r'\b(rhel|redhat|RHEL)\b', 'RHEL')
print df
val
0 WIN-abc123
1 def456-WIN
2 123123-WIN-ghi789
3 RHEL-jkl012
4 45u8234dgf-RHEL-mno345
5 pqr678-RHEL
</code></pre>