From the course: Data Science Foundations: Data Assessment for Predictive Modeling
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Tips and tricks using simple aggregation commands
From the course: Data Science Foundations: Data Assessment for Predictive Modeling
Tips and tricks using simple aggregation commands
- [Instructor] Here we are in KNIME and we're going to do some simple aggregations and sorts. The reason this is valuable is that we'll be able to quickly determine what's going on with our IDs and our high order nominals the same kinds of things you might do with a pivot table in Excel. But I think it's especially quick and easy in KNIME. So let's start with the aggregation. So that's called the GroupBy node. If we just start to type it, it will help us find it. Here it is. We can drag it into place and let's be clear on why we would want to do this. It's those very high order nominals that really cause us trouble and in this data set country of origin is one of them. It's got a few dozen categories and that's a bit too many for us to include. We don't want the software to automatically dummy code it. That's really the issue that would bring us to something like the GroupBy node. So let's take a look inside. Don't…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.