擅长:python、mysql、java
<p>与<code>bfill</code>一起使用<code>applymap</code></p>
<pre><code>df[df.applymap(lambda x : 'oil' in x)].bfill(1).loc[:,'A']
Out[80]:
0 NaN
1 NaN
2 fuel oil
3 crude oil
4 crude oil
5 fuel oil
6 NaN
Name: A, dtype: object
</code></pre>