python - Normalize rows of pandas data frame by their sums

Question

(This question already has answers here): question from:https://stackoverflow.com/questions/35678874/normalize-rows-of-pandas-data-frame-by-their-sums

Answer 1

You can use

df.div(df.sum(axis=1), axis=0)

df.sum(axis=1) sums up each row; df.div(..., axis=0) then divides.

Example:

import pandas as pd

df = pd.DataFrame({'a': [1, 2], 'b': [3, 4]})
>>> df.div(df.sum(axis=1), axis=0)
    a   b
0   0.250000    0.750000
1   0.333333    0.666667