擅长:python、mysql、java
<p>可以使用<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.str.contains.html" rel="nofollow noreferrer">^{<cd1>}</a>搜索匹配字符串,然后根据需要修改它:</p>
<pre><code>df.loc[df['job_title'].str.contains('teacher'), 'job_title'] = 'teacher'
</code></pre>
<p>例如:</p>
^{pr2}$
<p>将包含单词<code>'teacher'</code>的所有标题改为<code>'teacher'</code>:</p>
<pre><code>df.loc[df['job_title'].str.contains('teacher'), 'job_title'] = 'teacher'
print(df['job_title'].value_counts())
#teacher 3
#programmer 1
#Name: job_title, dtype: int64
</code></pre>
<p>请注意,在本例中,我覆盖了现有列,但您也可以轻松地创建新列:</p>
<pre><code>df.loc[df['job_title'].str.contains('teacher'), 'new_job_title'] = 'teacher'
</code></pre>