摘取大熊猫的最后部分

Question

我有一个有价值的专栏：

虚拟数据：

df["temp_design"] = ['Are Premium Design tree (LKL#)',
       'THE Premium Design tree (TKL+)',
       'THZPremium Design tree (TKL+)',
       'THG THEM Entry tree temporary align (MKP#)', nan,
       'THZPremium Design tree (CHU#)',
       'THZPremium Design tree (ZHU2+)',
       'TRUE PREMIUM TEMPORARY DESIGN (ZHU+)',
       'BASIC TEMPORARY DESIGN (ZHU+)']

我想要创建一个新列，它的值出现在最后一个括号中。

有人能帮我脱下这根绳子吗？

df["output_col"] =["LKL#","TKL+","TKL+","MKP#","CHU#","ZHU2+","ZHU+","ZHU+"]

Answer 1

与匹配打开和关闭括号的regex一起使用提取，并用with捕获内容。

df['temp_design'].str.extract(r'\((.*?)\)$') 

    0
0   LKL#
1   TKL+
2   TKL+
3   MKP#
4   NaN
5   CHU#
6   ZHU2+
7   ZHU+
8   ZHU+