ANL252: Propose and carry out at least three (3) data pre-processing tasks to clean and prepare the given dataset using Python: Python for Data Analytics Assignment, SUSS, Singapore

Question 1
Propose and carry out at least three (3) data pre-processing tasks to clean and prepare the given dataset using Python. Provide relevant explanations using no more than 500 words (note: this word limit excludes the Python code).

Question 2
Use Python to plot three (3) charts based on the processed dataset obtained from Question 1. Discuss the insights derived from each chart. Note that each chart and its corresponding Python codes and insights collectively carry 10 marks. The charts and Python codes are to be provided as part of the answer in the main report. [No more than 500 words (including in-text citation, excluding the Python codes)]

Question 3
Use linear regression to further explore the processed dataset obtained from Question 1, where the dependent variable is ‘Total_trade_value’. Explain the modelling approach taken. [No more than 300 words (including in-text citation)]

Question 4
State the linear regression equation obtained from Question 3. Discuss the relevant insights. [No more than 200 words (including in-text citation, excluding Python code)]

Question 5
Based on the given dataset, please discuss alternative data analytics methods that could be employed to complement or enhance the insights derived from the linear regression model. [No more than 300 words (including in-text citation)]