Icon

01 Date and Time Manipulation - Solution

01 Date and Time Manipulation - Solution
Exercise: Date and Time ManipulationRead the New York City Airbnb data by executing the File Reader node.1) Convert the timestamps in the last_review column from string to Date&Time2) Remove rows with missing values in the last_review column3) Remove the time values from the timestamps4) Extract the day of the week from each timestamp5) Count the number of last reviews on each day of the week. Which day of theweek has the highest count? And the lowest? Read AB_NYC_2019dataRemove timeExtract weekdayCount by weekdayRemove rows wherelast_review is missing File Reader String to Date&Time Modify Time Extract Date&TimeFields GroupBy Sorter Missing Value Exercise: Date and Time ManipulationRead the New York City Airbnb data by executing the File Reader node.1) Convert the timestamps in the last_review column from string to Date&Time2) Remove rows with missing values in the last_review column3) Remove the time values from the timestamps4) Extract the day of the week from each timestamp5) Count the number of last reviews on each day of the week. Which day of theweek has the highest count? And the lowest? Read AB_NYC_2019dataRemove timeExtract weekdayCount by weekdayRemove rows wherelast_review is missingFile Reader String to Date&Time Modify Time Extract Date&TimeFields GroupBy Sorter Missing Value

Nodes

Extensions

Links