Icon

03 Flow Variables - Solution

03 Flow Variables - Solution
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