pandas的applymap可以做到这一点：

import pandas as pd

def shorten(s):
    return s.split(' - (')[0]
    
df = pd.DataFrame(['abc - (123)', 'def - (456)'])
print(df)
df = df.applymap(shorten)
print(df)

输出：

0
0  abc - (123)
1  def - (456)
     0
0  abc
1  def

如果只想修改特定列，例如“product_name”，请使用apply：

import pandas as pd

def shorten(s):
    return s.split(' - (')[0]
    
df = pd.DataFrame([['abc - (123)'], ['def - (456)']], columns = ['product_name'])
print(df)
df['product_name'] = df['product_name'].apply(shorten)
print(df)

试试这个：string.split(" - (")[0]

假设它是一个pandas dataframe df，类似would使用regex来执行'product_name'下所有项的替换。
df['product_name'] = df['product_name'].str.replace('- \(', '', regex=True)