Data Cleaning PRO Tip: Dealing with text & numbers in same column скачать в хорошем качестве

Data Cleaning PRO Tip: Dealing with text & numbers in same column

Recently I had to deal with a weird data clean up scenario. My client (a large hotel chain) was getting room booking data with mixed format. The booking date column occasionally has a text value which needs to extracted and used for proper analysis. In this short tip video, let me show you how to deal with such problems using Excel. ⏱Video topics 👉 =============== 0:00 - The text & numbers problem 0:39 - Avoiding the problem by removing text data 2:32 - How to separate and properly arrange data (with Power Query) 📗Sample file ============ If you want to practice this concept, here is a sample workbook. https://chandoo.org/wp/wp-content/upl... 👩‍💻👨‍🎓 LEARN MORE about Data Cleaning ================================= 📺 YOUTUBE VIDEOS: on Power Query (complete tutorial, 80 mins, 260k views) -    • Power Query Tutorial - What is it, how to ...   on Data cleaning (top 10 tips, 15 mins, 300k views) -    • Data cleaning in Excel - 10 tricks *PROs* ...   More data cleaning (10 more tips, 15 mins, 50k views) -    • Data Cleaning in Excel - 10 Tricks (Beginn...   👩‍💻 COURSES: 💥Power Query mini-course (2 hours, full PQ with many practical examples) - https://chandoo.org/wp/power-query-po... 📚FULL Excel (24+ hours, 100s of examples) - https://chandoo.org/wp/excel-school-p... ~ A data analyst walks in to the bar. A pretty lady smiles at him and walks over. She says, "You look cool. Here is my number. Text me your number." The data analyst replies, "Sorry, but I don't TEXT() numbers" 🤦‍♂️😂 #datacleaning #excel