python - mix the information of all columns in a single column

Question

I have a dataset like this:

df = pd.DataFrame({'ID':["a"," b", "c","d", "e"],
               'P1': [10, 28, 34, 56, 78],
              'P2':[ 90, 54, 54, 32, 16],
              'P3':[14, 15, 24, 90,34]})

which contains the grades of students for each problem. I need to creat a new column named "Notes" which contains the grades of all problems in one column. the output must look like this:

question from:https://stackoverflow.com/questions/65869962/mix-the-information-of-all-columns-in-a-single-column

Answer 1

Use:

#Calculate Total
df['Total'] = df.filter(regex='P').sum(axis=1)
#Create Notes
df['Notes'] = df.filter(regex='P').astype(str)
    .apply(lambda row: ','.join(row.index + ';' + row), axis=1)
print(df)


   ID  P1  P2  P3  Total              Notes
0   a  10  90  14    114  P1;10,P2;90,P3;14
1   b  28  54  15     97  P1;28,P2;54,P3;15
2   c  34  54  24    112  P1;34,P2;54,P3;24
3   d  56  32  90    178  P1;56,P2;32,P3;90
4   e  78  16  34    128  P1;78,P2;16,P3;34