擅长:python、mysql、java
<p>不需要复杂的正则表达式:</p>
<pre class="lang-py prettyprint-override"><code>import pandas as pd
test = {'title': ['Other', 'Microbiological - Listeria', 'Extraneous Material', 'Chemical', 'Chemical - Histamine', 'Labelling, Other']}
example = pd.DataFrame(test)
print(example)
print()
example['hazard_extract'] = example['title'].str.split(' -|,').str[0]
print(example)
</code></pre>
<pre class="lang-none prettyprint-override"><code> title
0 Other
1 Microbiological - Listeria
2 Extraneous Material
3 Chemical
4 Chemical - Histamine
5 Labelling, Other
title hazard_extract
0 Other Other
1 Microbiological - Listeria Microbiological
2 Extraneous Material Extraneous Material
3 Chemical Chemical
4 Chemical - Histamine Chemical
5 Labelling, Other Labelling
</code></pre>