擅长:python、mysql、java
<p>让我们试试这个正则表达式:</p>
<pre><code>pattern = '\((\w+)\) (\w+)'
df['Companies_Compressed'] = (df.Companies.str.extractall(pattern)
.agg(' '.join, axis=1)
.groupby(level=0).apply('; '.join)
.fillna(df['Companies'])
)
Companies Companies_Compressed
0 Arbino (Arb) Corp Arb Corp
1 Arbino (Arb) Corp; Bakroaho (Bak) Bank Arb Corp; Bak Bank
2 Zinga NaN
</code></pre>