擅长:python、mysql、java
<p>您可以使用带有<code>assign</code>的简单正则表达式,或者只广播您的列</p>
<p><code>.*</code>是一种贪婪的方法,用于匹配<code>ClassOfYear</code>之后直到字符串结尾的所有内容(行终止符除外)</p>
<pre><code>df = df.assign(newCol=df['ClassOfYear'].str.extract('(ClassOfYear.*)'))
print(df)
ClassOfYear newCol
0 ClassOfYear 2019 something ClassOfYear 2019 something
1 x ClassOfYear 2012 random text ClassOfYear 2012 random text
2 Amy ClassOfYear 2004 ClassOfYear 2004
3 David Beckham ClassOfYear 1994 ClassOfYear 1994
</code></pre>