Find rows with non zero values in a subset of columns in pandas dataframe
<p>I have a datframe with 4 columns of strings and others as integers. Now I need to find out those rows of data where at least one of the column is a non-zero value (or > 0).</p>

<pre><code>manwra,sahAyaH,T7,0,0,0,0,T
manwra, akriti,T5,0,0,1,0,K 
awma, prabrtih,B6, 0,1,1,0,S
</code></pre>

<p>My output should be</p>

<pre><code>manwra, akriti,T5,0,0,1,0,K 
awma, prabrtih,B6, 0,1,1,0,S
</code></pre>

<p>I have tried the following to obtain the answer. The string values are in colums 0,1,2 and -1 (last column).</p>

<pre><code>KT[KT.ix[:,3:-2] != 0]
</code></pre>

<p>What I am receiving as output is </p>

<pre><code>NaN,NaNNaN,NaN,NaN,NaN,NaN,NaN
NaN,NaN,NaN,NaN,NaN,1,NaN,NaN
NaN,NaN,NaN,NaN,1,1,NaN,NaN
</code></pre>

<p>How to obtain the desired output</p>

<p>assume your dataframe is <code>df</code></p>

<pre><code>df.loc[(df.loc[:, df.dtypes != object] != 0).any(1)]
</code></pre>

<p><a href="http://i.stack.imgur.com/A6MMx.png" rel="nofollow"><img src="http://i.stack.imgur.com/A6MMx.png" alt="enter image description here"></a></p>

python pandas dataframe