Pandas - Selecting multiple dataframe criteria
<p>I have a DataFrame with multiple columns and I need to set the criteria to access specific values from two different columns. I'm able to do it successfully on one column as shown here:</p>

<pre><code>status_filter = df[df['STATUS'] == 'Complete']
</code></pre>

<p>But I'm struggling to specify values from two columns. I've tried something like this but get errors:</p>

<pre><code>status_filter = df[df['STATUS'] == 'Complete' and df['READY TO INVOICE'] == 'No']
</code></pre>

<p>It may be a simple answer, but any help is appreciated.</p>

<p>you can use:</p>

<pre><code>status_filter = df[(df['STATUS'] == 'Complete') &amp;  (df['READY TO INVOICE'] == 'No')]
</code></pre>

python pandas dataframe