<p>我有以下数据框:-</p>
<p><a href="https://i.stack.imgur.com/quuGH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/quuGH.png" alt="enter image description here"/></a></p>
<p>我想过滤<code>claim_status</code>中有11个的地方</p>
<p>对于aa1的<code>claim_ststaus_reason</code>。你知道吗</p>
<p>我正在尝试下面的代码,但它只是给我所有的行</p>
<pre><code>my_list = 'aa1'
df[df['claim_status_reason'].str.contains( "|".join(my_list), regex=True)].reset_index(drop=True)
</code></pre>
<p>预期输出:-你知道吗</p>
<pre><code>1.) where there is 11 in claim_ststus
2.) where there is aa1 in the claim_status_reason
</code></pre>
<p>您可以使用<code>apply</code>获得所需的过滤器,如:</p>
<pre><code>df[(df['claim_staus'].apply(lambda x: 11 in x)) & (df['claim_status_reason'].apply(lambda x: 'a1' in x))]
</code></pre>