How doing division each cell dataframe

Question

I want calculate division of each cell by sum of each row. Actually there are many column not only A and B.

import pandas as pd
data = pd.DataFrame({'A':[1,2,3,1,2,3,1],
                 'B':[4,5,6,4,5,6,4]]})

sum_row = data.sum(axis=1)

Here is an example of what I expect.

`data.div(data.sum(1), axis=0)` – user3483203 Aug 15 '19 at 16:39 — user3483203, Aug 15 '19 at 16:39

score 0 · Answer 1 · answered Aug 15 '19 at 17:22

I think this should do the trick

import pandas as pd
data = pd.DataFrame({'A':[1,2,3,1,2,3,1],
                 'B':[4,5,6,4,5,6,4]})

data['sum_row'] = data.sum(axis=1)

for col in list(data.columns.values):
    data[col + ' / Sum_Row'] = [data['A'].iloc[e] / data['sum_row'].iloc[e] for e in range(0, len(data['A']))]

How doing division each cell dataframe

1 Answers1