Programming Homework Help

explain how to repeat the process for numeirc_df_without_shelf. Normalize then run PCA. Calculate cumulative explained variance ratio and determine how many dimensions you need to explain 90% of the variance. Save the components to a CSV file. Open the Excel file and add the correct row and column labels. Remember that in the file that is generated, new dimensions are the rows and old dimensions are the columns. Keep the new dimensions that you need to explain 90% of the variance and delete the rest. Check out the weights of the old dimensions on new dimensions and label the new dimensions beased on their relationship with the old dimensions. Copy and paste your Python code in a new sheet of the same CSV file and save as Excel. Submit the Excel file.

attached is the screen shots of the given program