Icon

03 Flow Variables

03 Flow Variables
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? 327 rooms/apartments Manhattan Read AB_NYC_2019dataCount byHost IDSortId with mostroomsFilter rooms of the host idwith most roomsCSV 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? 327 rooms/apartments Manhattan Read AB_NYC_2019dataCount byHost IDSortId with mostroomsFilter rooms of the host idwith most roomsCSV Reader GroupBy Sorter Row Filter Table Rowto Variable

Nodes

Extensions

Links