Hub
Pricing About
ComponentComponent

Data Preprocessing

maarit profile image
Draft Latest edits on 
Dec 12, 2023 9:08 AM
Drag & drop
Like
Use or download
This component preprocesses the hourly electricity consumption values in the following ways: - Sort the data by time in ascending order - Aggregate the data to daily values - Create a column with previous week's daily values - Calculate the average electricity consumption by hour and weekday

Component details

Input ports
  1. Type: Table
    Input
    Hourly timestamps and the corresponding electricity consumption values
Output ports
  1. Type: Table
    Daily total values
    The total electricity consumption on each day
  2. Type: Table
    Lagged values
    Daily total values with an additional column for the previous week's values
  3. Type: Table
    Pivot table
    Hourly average electricity consumption by weekday

Used extensions & nodes

Created with KNIME Analytics Platform version 5.2.0
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.2.0

    knime

This component does not have nodes, extensions, nested components and related workflows

Legal

By using or downloading the component, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits