# Clean the dataframe to make it more usable
df = dfs['Sheet1'].copy()
# Dropping the first row as it is a header row repeated
# Also, renaming columns for clarity
df = df.drop(index=0)
df.columns = ['S/N', 'Name of School', 'Gender', 'Age', 'Unused', 'PSSAT Score']
# Drop the 'Unused' column as it does not contain any relevant information
df = df.drop(columns=['Unused'])
# Convert the Age and PSSAT Score columns to numeric types
df['Age'] = pd.to_numeric(df['Age'])
df['PSSAT Score'] = pd.to_numeric(df['PSSAT Score'])
# Display the cleaned dataframe to verify changes
display(df.head())