擅长:python、mysql、java
<p>使用<code>str.split(r"\bat\b", expand=True)</code></p>
<p>例如:</p>
<pre><code>import pandas as pd
df = pd.DataFrame({"Job": ["Operation Manager at Barclays", "Chief Operating Officer at Llyods"]})
df[["Job", "Location"]] = df["Job"].str.split(r"\bat\b", expand=True)
print(df)
</code></pre>
<p><strong>输出:</strong></p>
^{pr2}$