Pandas, editing dataframe

Question

I have df that is similar to the following:

value  is_1  is_2 is_3
5      0     1    0
7      0     0    1
4      1     0    0

(it is guaranteed, that the sum of values from columns is_1 ... is_n is equal to 1 calculating by each row)

I need to get the next result:

is_1  is_2  is_3
0     5     0
0     0     7
4     0     0

(I should find the column is_k that is more than 0, and fill it with value from "value" column)

What is the best way to achieve it?

MaxU - stand with Ukraine · Accepted Answer · 2017-07-15 13:12:52Z

2

I'd do it this way:

In [16]: df = df.mul(df.pop('value').values, axis=0)

In [17]: df
Out[17]:
   is_1  is_2  is_3
0     0     5     0
1     0     0     7
2     4     0     0

edited Jul 15, 2017 at 13:12

answered Jul 15, 2017 at 13:07

MaxU - stand with Ukraine

212k37 gold badges402 silver badges437 bronze badges

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

Collectives™ on Stack Overflow

Pandas, editing dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related