Hi Maveryx,
A solution to last week’s challenge can be found here.
This week's challenge, contributed by our Community member AntoBennetsha Jabamalai (@AntobennetshaJ), will sharpen your data preparation skills. A big thanks to Anto!
Who among us has not encountered the task of handling dates in various formats in our daily work? But let’s be honest: who regularly checks the date format before streamlining their processes?
In this challenge, we are faced with the task of cleaning a set of dates in a survey dataset. The date was collected in a string field, which meant that survey respondents entered the dates in different formats. This resulted in dates having different delimiters and additional, unnecessary information. For practical analysis of the survey data, it is crucial to standardize all dates into a consistent format (YYYY-MM-DD) and organize them from the oldest to the most recent.
Need a bit of guidance? The interactive lesson Separating Data into Columns and Rows in Academy offers insights on handling values like those in our dataset, which include multiple separators such as slashes, hyphens, and dots, as well as other superfluous characters.
Good luck!
