Icon

03 Flow Variables - Solution

Solution to an exercise for creating and using flow variables.

Filter data based on a previous result in a workflow

CHECK YOUR ANSWERS:
The host id with the most listings offers 327 rooms/apartments located in Manhattan



Exercise: Flow VariablesRead the New York City Airbnb data by executing the CSV Reader node. Filter the data to the listings ofthe host with the most offers:1) Count the number of rows by host id2) Sort the aggregated data descending by the count of rows3) Transform the top row into a flow variable4) Use a Row Filter node to filter the original dataset. Overwrite the filtering pattern with the host_idflow variable. How many rooms or apartments does this host id offer? In which neighborhood groupare they located? Read AB_NYC_2019dataCount byhost idId with mostroomsFilter to therooms of the idwith most rooms CSV Reader GroupBy Sorter Row Filter Table Rowto Variable Exercise: Flow VariablesRead the New York City Airbnb data by executing the CSV Reader node. Filter the data to the listings ofthe host with the most offers:1) Count the number of rows by host id2) Sort the aggregated data descending by the count of rows3) Transform the top row into a flow variable4) Use a Row Filter node to filter the original dataset. Overwrite the filtering pattern with the host_idflow variable. How many rooms or apartments does this host id offer? In which neighborhood groupare they located? Read AB_NYC_2019dataCount byhost idId with mostroomsFilter to therooms of the idwith most roomsCSV Reader GroupBy Sorter Row Filter Table Rowto Variable

Nodes

Extensions

Links