Icon

03 Flow Variables

03 Flow Variables - Solution
Exercise: Flow VariablesRead the New York City Airbnb data by executing the File 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? ReadAB_NYC_2019 File Reader GroupBy Sorter Row Filter Table Rowto Variable Exercise: Flow VariablesRead the New York City Airbnb data by executing the File 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? ReadAB_NYC_2019File Reader GroupBy Sorter Row Filter Table Rowto Variable

Nodes

Extensions

Links