擅长:python、mysql、java
<p>用<code>loc</code>和<code>str.contains</code>试着用<code>str.replace</code>:</p>
<pre><code>df.loc[df.name.str.contains('Al'), 'sport'] = df.sport.str.replace('large', 'L')
</code></pre>
<p>例如:</p>
<pre><code>>>> df.loc[df.name.str.contains('Al'), 'sport'] = df.sport.str.replace('large', 'L')
>>> df
name sport
0 Bob tennis small
1 Jane football medium
2 Alice basketball L
>>>
</code></pre>
<p>筛选<code>name</code>列包含<code>Al</code>的行,然后在<code>sports</code>列中将<code>large</code>替换为<code>L</code></p>