image_output_1.png
import pandas as pd

df = pd.read_excel('/kaggle/input/students-employability-dataset/Student-Employability-Datasets.xlsx')
df.shape

new_df = df.drop(columns=['CLASS', 'Name of Student', 'Student Performance Rating'])
total = pd.DataFrame({'Skills': new_df.columns, 'Total Value': new_df.sum()})

df_employed = df.loc[df['CLASS'] == 'Employable']
df_employed = df_employed.drop(columns=['Name of Student', 'CLASS'])
ave_skills = pd.DataFrame({'Average Score': df_employed.mean()})
ave_skills

df_employed.head()