6 and 7 please please I need it

Processing Grades You have a class that has its evaluation results stored in multiple Excel files in the folder ./Results. This folder has the following files: as in the following examples: 1) List.xlsx: The list of registered students showing for each student, the sequence number, the registration number and name (withheld for privacy). E 1 2 w N 3 A B C D Section Sequence Number Name 1 1 0079330 1 2 0084355 1 3 0085546 1 4 0086085 1 5 0090366 4 + 5 6 . 2) Result Files: Each file has the result of one evaluation tool and contains the name of the evaluation tool, its weight, and number and mark of every evaluated student. Ignore any other columns that may be present in these files. Note that: Some mark fields may be empty Some students may not have some entries The results of one evaluation tool may be on multiple files B C D A B C D 1 Number Name Q2 1 Number Name Q1 Notes 2 10 2 10 3 0084355 10 3 0079330 7 4 0085546 2 4 0084355 Absent 5 0086085 3 5 0085546 4 3) Scale.xlsx: The scale for converting from marks to grades. A B 1 A 80 2 A- 75 3 B+ 70 4 65 5 60 6 4 || 55 7 C 8 C- 9 50 45 40 35 30 10 D 11 D- 4) Convert the total mark to grades based on Scale file Read the Scale file Create the bins in reverse order and add an entry for the total mark (100) o Create a column for the grade using pd.cut Save data to Excel file o 5) Summarize the student grades using a bar plot Use sns.barplot on the value counts of the grades column O 6) Plot the histograms of each result and of the total using seaborn's displot o Use plt.close after saving each plot You need to loop over the result columns o 7) Normalize the result columns then plot the scatter matrix using seaborn's pairplot o Normalize the result columns in to a new dataframe 8) For the normalized results, plot box plot using seaborn's catplot o Use pd.melt Use pandas to read and process these Excel files and seaborn to generate the required plots. 4) Convert the total mark to grades based on Scale file o Read the Scale file Create the bins in reverse order and add an entry for the total mark (100) o Create a column for the grade using pd.cut o Save data to Excel file o 5) Summarize the student grades using a bar plot Use sns.barplot on the value counts of the grades column o 6) Plot the histograms of each result and of the total using seaborn's displot o Use plt.close after saving each plot o You need to loop over the result columns X 7) Normalize the result columns then plot the scatter matrix using seaborn's pairplot o Normalize the result columns in to a new dataframe 8) For the normalized results, plot box plot using seaborn's catplot o Use pd.melt Use pandas to read and process these Excel files and seaborn to generate the required plots