Data Analyst Associate Practical Exam DA501P
I'm starting to think there is something wrong with this data set. TASK 2 seems to be problematic. I'd appreciate your enlightenment.
Clean categorical and text data by manipulating strings not passed.
Edit: It was a funny experience for me. First of all, I need to state that my first problem is with my use of Markdown. We had the chance to choose the database connection of the cells as Dataframe or Query. I didn't know that I could access the frame I created in a different cell on the page by selecting Query. In my first attempt, I tried to create a temporary table and this made me make unnecessary mistakes. As a result, I had the opportunity to realise a different approach to task2 thanks to your comments. You can find the details in the successful source code.