Using the data provided to you (on Excel file), build a computational statistics data pipeline that automates the cleaning, transformation and initial analysis of the data. As part of this, you are expected to employ some dimension reduction and/or feature extraction techniques to reduce the dimensionality of the data for future analysis.
Sample Solution
