擅长:python、mysql、java
<p>请使用<code>str.replace</code>将特殊字符<code>(</code>{<cd3>}特殊字符<code>()</code>之前的任何<code>alphanumerics</code>替换为<code>''</code></p>
<pre><code>df['Companies_Compressed']=df['Companies'].str.replace('((\w+\s){1,2}(?=[(])|[()])','')
</code></pre>
<p>关于第二个问题</p>
<pre><code>df1=df.assign(Company_prefix=df['Companies'].str.extract('(\w+\s\w+|\w+)(?=\s[(])'),short_form =df['Companies'].str.extract('(?<=[(])(.*?)(?=[)])')).dropna()
print(df1)
</code></pre>