Question

How to calculate the mean (average) of each row in DataFrame and print with column with Python

Answer 1

import pandas as pd
 
df = pd.DataFrame(
    [['Tom', 91, 80, 94],
     ['Emmy', 98, 95, 96],
     ['Rubeus', 87, 81, 87],
     ['Dumbledore', 99, 100, 98],
     ['Axel', 75, 85, 90]],
    columns=['name', 'algebra', 'python', 'java'])
 
mean = df.mean(axis=1)

mean_name = pd.concat([df['name'], mean], axis=1)

print(mean_name)
  
  
  
'''
run:
  
         name          0
0         Tom  88.333333
1        Emmy  96.333333
2      Rubeus  85.000000
3  Dumbledore  99.000000
4        Axel  83.333333

'''

 

70+ SQL courses for beginners and professionals