From the course: Machine Learning with Data Reduction in Excel, R, and Power BI
Unlock the full course today
Join today to access over 24,800 courses taught by industry experts.
Solution: Power BI
From the course: Machine Learning with Data Reduction in Excel, R, and Power BI
Solution: Power BI
(upbeat music) - [Instructor] I'm going to pick up with the PCA model in the Denver data frame that I worked on in the last chapter's challenge. I've already taken out the plot components because I'm going to create visuals using the Power BI scatter plots instead of R visuals. After running the PCA model for the challenge, let's convert the x component of the pca_challenge variable into a data.frame variable called project. Let's then add the data from the Denver data.frame variable as a field in the PCA model project variable. So we see we get a message up here. We receive an error message when we run this code because the original Denver data.frame variable has more rows in it than the project variable for the PCA model results. The reason we see this here is because there are some rows that don't have complete records for fields like TMIN and TMAX. To remove these incomplete rows before we even run the model…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.