Q$1)$

Download the file "Raw File for test.xlsx$$ and $$Final Test Result File.csv$.$ Use appropriate data cleaning techniques and methods in Pandas to convert the raw file into the data structure as shown in $$Final Test Result File.csv$$ and answer the following questions. Your answers should be accurate. All cleaning and manipulation should be done in Python only. Be careful for subtotals in the data to avoid double counting. $(50$ marks$)$

Paste your cleaning code here $,$

$$

Write the full code that lead to the answer of each of the following questions in the single cell below each question.

Q$2)$ What is the grand total number of students in this college?

$10$ marks

$$

Q$3)$ What is the total number of students in each semester?

$10$ marks

$$

Q$4)$ Show the average number of students in each School using a bar graph.

$10$ marks

$$

Q$5)$ Import the tips dataset and complete the parts below $,$

$5$a$)$ Find out the correlation between total bill, tip and size column using appropriate data frame method.

$5$b$)$ Show the result of question $4$ in a form of a seaborn package heatmap.

$20$ marks

$$