03_​Data_​Aggregation_​Exercise

0 ×

Data Aggregation - Solution

Solution to exercise 7 for the KNIME Analytics Platform for Data Wranglers course
- Calculate multiple aggregation using the Pivoting and GroupBy node
- Join grouped data
- Extract date fields from a DateTime value
- Handle missing values
- Manipulate strings
- Calculate new features using the Math Formula node

URL: Slides (KNIME Analytics Platform for Data Wranglers) https://www.knime.com/form/material-download-registration
URL: Basic Aggregations with the GroupBy node https://www.youtube.com/watch?v=JQ-OWMt48ew
URL: Advanced Aggregations with the GroupBy Node https://www.youtube.com/watch?v=i2LIKPOgNoM
URL: The Pivoting node https://www.youtube.com/watch?v=zo9YdH9kgKQ

Nodes

• CSV Reader1 ×
• Concatenate1 ×
• GroupBy1 ×
• Number To String1 ×
• Numeric Outliers1 ×
• Show all 6 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Statistics Nodes

Links

• No links available