Collapse binary Pandas Dataframe into one column

Question

I have a Dataframe of the form:

  a b c d e
0 0 1 0 1 0
1 0 0 0 1 1
2 1 1 0 0 0

I would like to collapse it taking only the ones to only one row, like:

   x 
0 'bd' 
1 'de' 
2 'ab'

Thanks in advance

BENY · Accepted Answer · 2020-07-03 14:09:59Z

7

Try with dot

df['x']=df.dot(df.columns)

answered Jul 3, 2020 at 14:09

BENY

324k22 gold badges176 silver badges250 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1