From the course: Python in Excel: Data Outputs in Custom Data Visualizations and Algorithms
Unlock the full course today
Join today to access over 24,300 courses taught by industry experts.
Leveraging Excel scatter plots
From the course: Python in Excel: Data Outputs in Custom Data Visualizations and Algorithms
Leveraging Excel scatter plots
- [Instructor] Next, let's create a visual for the predicted outcomes of the KMean clustering algorithm. Like the anomaly detection line chart we just created, in order to display the clusters separately with different colors in the visual, we need to first separate the labels into their own individual series. We ran the KMeans algorithm with two clusters, which return cluster labels of either zero or one. We'll first create a new column called "cluster zero" to say that if the result in column F has a value of zero, then it will return the high temperature value in column E, otherwise, it will return the NA Excel function. And because this cluster is one, I'm actually going to copy this one over as an example to reference cluster one. I'm going to say that if G17 equals one, then we return F17. There's a problem with their cell references here, but the good news is that it's a pretty straightforward fix to make. We'll first update our column reference for the first condition to say…
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.
Contents
-
-
-
-
-
Visualizing data1m 35s
-
(Locked)
Leveraging Excel line charts3m 58s
-
(Locked)
Leveraging Excel scatter plots5m 21s
-
(Locked)
Configuring Python in Excel with dynamic parameters4m 32s
-
(Locked)
Creating Python visuals2m 13s
-
(Locked)
Visualizing hierarchical clustering with dendrograms6m 43s
-
(Locked)
Breaking down time series models into components5m 29s
-
(Locked)
Challenge: Comparing time series components to anomalies50s
-
(Locked)
Solution: Comparing time series components to anomalies4m 56s
-
-