Pandas计算基于行的百分比

import pandas as pd

data = {'A': [1, 2, 3, 4, 5],
        'B': [6, 7, 8, 9, 10]}
df = pd.DataFrame(data)

def calculate_percentage(row):
    total = row['A'] + row['B']
    percentage_A = row['A'] / total * 100
    percentage_B = row['B'] / total * 100
    return pd.Series([percentage_A, percentage_B], index=['Percentage A', 'Percentage B'])

df[['Percentage A', 'Percentage B']] = df.apply(calculate_percentage, axis=1)

print(df)

   A   B  Percentage A  Percentage B
0  1   6     14.285714     85.714286
1  2   7     22.222222     77.777778
2  3   8     27.272727     72.727273
3  4   9     30.769231     69.230769
4  5  10     33.333333     66.666667