<div dir="ltr">Hi Sanant and Samo,<div><br></div><div>Even easier and faster solution:</div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">df.columns[(df.values != 0).any(axis=0)]</blockquote><div class="gmail_extra">Or if some reason != 0 does not work for you:</div><div class="gmail_extra"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">df.columns[(~(df.values == 0)).any(axis=0)]</blockquote><div><div class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693gmail_signature">----<br>Pozdrawiam,  |  Best regards,<br>Maciek Wójcikowski<br><a href="mailto:maciek@wojcikowski.pl" target="_blank">maciek@wojcikowski.pl</a><br></div></div>
<br><div class="gmail_quote">2016-10-05 13:35 GMT+02:00 Samo Turk <span dir="ltr"><<a href="mailto:samo.turk@gmail.com" target="_blank">samo.turk@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div>Something like this might work:<br><br><span style="font-family:monospace,monospace">def non_zero(row, columns):<br>    return list(columns[~(row == 0)])<br><br>df.apply(lambda x: non_zero(x, df.columns), axis=1)</span><br><br></div>Cheers,<br></div>Samo<br></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693h5">On Wed, Oct 5, 2016 at 11:58 AM, Startup Hire <span dir="ltr"><<a href="mailto:blrstartuphire@gmail.com" target="_blank">blrstartuphire@gmail.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693h5"><div dir="ltr">Hi Pypers,<div><br></div><div>Hope you are doing well.</div><div><br></div><div>I am working on a project to find out the column names of non-zero values at a row level.</div><div><br></div><div>How can this effectively done in python pandas/dataframe?</div><div><br></div><div><br></div><div>For example, </div><div><br></div><div><table style="border-collapse:collapse;width:384pt" cellpadding="0" cellspacing="0" border="0" width="512">
 <colgroup><col style="width:48pt" span="8" width="64">
 </colgroup><tbody><tr style="height:15pt" height="20">
  <td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl63" style="height:15pt;width:48pt" height="20" width="64"><table style="border-collapse:collapse;width:524pt" cellpadding="0" cellspacing="0" border="0" width="699">
 <colgroup><col style="width:48pt" span="7" width="64">
 <col style="width:188pt" width="251">
 </colgroup><tbody><tr style="height:15pt" height="20">
  <td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="height:15pt;width:48pt" height="20" width="64"><br></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-left:none;width:48pt" width="64"><br></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-left:none;width:48pt" width="64"><br></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-left:none;width:48pt" width="64"><br></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-left:none;width:48pt" width="64"><br></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-left:none;width:48pt" width="64"><br></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-left:none;width:48pt" width="64"><br></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl66" style="border-left:none;width:188pt" width="251"><br></td></tr><tr style="height:15pt" height="20"><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="height:15pt;border-top:none" align="right" height="20"><br></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-top:none;border-left:none" align="right"><br></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-top:none;border-left:none" align="right"><br></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-top:none;border-left:none" align="right"><br></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-top:none;border-left:none" align="right"><br></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-top:none;border-left:none" align="right"><br></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-top:none;border-left:none" align="right"><table style="border-collapse:collapse;width:524pt" cellpadding="0" cellspacing="0" border="0" width="699">
 <colgroup><col style="width:48pt" span="7" width="64">
 <col style="width:188pt" width="251">
 </colgroup><tbody><tr style="height:15pt" height="20">
  <td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="height:15pt;width:48pt" height="20" width="64"><b>Column1</b></td>
  <td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-left:none;width:48pt" width="64"><b>Column </b>2</td>
  <td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-left:none;width:48pt" width="64"><b>Column </b>3</td>
  <td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-left:none;width:48pt" width="64">Column 4</td>
  <td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-left:none;width:48pt" width="64">Column 5</td>
  <td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-left:none;width:48pt" width="64">Column 6</td>
  <td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-left:none;width:48pt" width="64"><b>Column 7</b></td>
  <td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl66" style="border-left:none;width:188pt" width="251">New column to
  be created</td>
 </tr>
 <tr style="height:15pt" height="20">
  <td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="height:15pt;border-top:none" height="20">1</td>
  <td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-top:none;border-left:none">1</td>
  <td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-top:none;border-left:none">1</td>
  <td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-top:none;border-left:none">0</td>
  <td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-top:none;border-left:none">0</td>
  <td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-top:none;border-left:none">0</td>
  <td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-top:none;border-left:none">1</td>
  <td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-top:none;border-left:none">Column1,Column
  2,Column 3,Column7</td>
 </tr></tbody></table></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl65" style="border-top:none;border-left:none"><br></td>
 </tr></tbody></table></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl63" style="border-left:none;width:48pt" width="64"><br></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl63" style="border-left:none;width:48pt" width="64"><br></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl63" style="border-left:none;width:48pt" width="64"><br></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl63" style="border-left:none;width:48pt" width="64"><br></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl63" style="border-left:none;width:48pt" width="64"><br></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl63" style="border-left:none;width:48pt" width="64"><br></td><td class="gmail-m_706089077454943074m_5746520057854880522m_7355293152843336693m_5675979695095450938m_-2984627157137637428gmail-xl64" style="border-left:none;width:48pt" width="64"><br></td></tr></tbody></table><br></div><div><br></div><div><br></div><div>I might have to do it on approximately million rows</div><div><br></div><div>Regards,</div><div>Sanant</div></div>
<br></div></div>______________________________<wbr>_________________<br>
scikit-learn mailing list<br>
<a href="mailto:scikit-learn@python.org" target="_blank">scikit-learn@python.org</a><br>
<a href="https://mail.python.org/mailman/listinfo/scikit-learn" rel="noreferrer" target="_blank">https://mail.python.org/mailma<wbr>n/listinfo/scikit-learn</a><br>
<br></blockquote></div><br></div>
<br>______________________________<wbr>_________________<br>
scikit-learn mailing list<br>
<a href="mailto:scikit-learn@python.org" target="_blank">scikit-learn@python.org</a><br>
<a href="https://mail.python.org/mailman/listinfo/scikit-learn" rel="noreferrer" target="_blank">https://mail.python.org/mailma<wbr>n/listinfo/scikit-learn</a><br>
<br></blockquote></div><br></div></div>