From the course: Data Cleaning and Manipulating with Python in Excel

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Challenge: Advanced data cleaning

Challenge: Advanced data cleaning

From the course: Data Cleaning and Manipulating with Python in Excel

Start my 1-month free trial Buy for my team

Challenge: Advanced data cleaning

“

(lively music) - [Instructor] In chapter two, we discussed ways on how to clean text data, understand time data, validate data, and how to manipulate columns. Now, it's time to put those skills to the test in our Chapter Two Challenge. You can find the data on the Challenge tab in the Chapter Two Exercise File. Okay, so here's the situation. You just started your recent analyst role and are taking over some of the reporting from the previous employee. The only problem is the old reporting is a complete mess and we have to showcase it in a much more appropriate, organized fashion. To do this, you have to complete the following steps. First, give your Conditions column data a title for each cell. Second, we have to combine the City column along with the titled Conditions output and ensure the titled Region is in parentheses. Third, show a preview of what the rows look like when the Region is only East. And fourth, figure out what the hour of each day is in the Date column. What are you…

Contents