You are provided with a data set that includes daily maximum temperatures at an airport. Your analysis requires you to create a new field containing the maximum temperature from five days ago. Which…

Question

Options

• AHistory node
• BFiller node
• CTranspose node
• DBinning node

• A
  88% (44)
• B
  4% (2)
• C
  2% (1)
• D
  6% (3)

Explanation

The History node is designed specifically to look back a specified number of rows (time periods) and retrieve a value from that point - making it the right tool for creating a field that holds the temperature from five days prior.

Why the others are wrong:

• Filler node (B) replaces missing or null values with substitutes - it doesn't shift or look back in time.
• Transpose node (C) pivots data between rows and columns, changing the data's orientation rather than creating lag variables.
• Binning node (D) groups continuous values into discrete categories (e.g., "hot", "warm", "cold") - useful for categorization, not time-shifting.

Memory tip: Think of the History node as a "time machine for rows" - whenever a question asks you to grab a value from N periods ago, that's your signal to reach for History.

No community discussion yet for this question.