Jan 20 · 2 min read · Hola and happy new year, everyone! I really wanted to upload this earlier, but it's alright, sooo, let's dive into the business of the day 😅. Did you know that most 'bugs' in your program aren't actually in your code? They're lurking in your data. I...
Join discussion
Nov 12, 2025 · 2 min read · Bối cảnh Trong thế giới dữ liệu ngày nay, chúng ta không làm việc với những bộ dữ liệu “hoàn hảo”. Thực tế, dữ liệu thực (real-world data) thường bị nhiễu, thiếu, và không nhất quán — hậu quả của: Kích thước dữ liệu khổng lồ (từ vài GB đến hàng TB)....
Join discussion
Nov 1, 2025 · 3 min read · Table of Contents Introduction What I learned What I built Description of Analysis Done Conclusion Introduction This week was a whole new experience. It wasn’t about knowing the importance of analyzing data but seeing it play out in real time ...
Join discussion
Aug 13, 2025 · 5 min read · Data cleansing in SQL is crucial for creating high-quality datasets. As data environments evolve, teams are moving from traditional SQL syntax to AI-driven automation and real-time anomaly detection. These practices reduce manual labor and enhance da...
Join discussion
Mar 8, 2025 · 16 min read · Introduction: Clean Up Your Data Garden Managing customer data in Salesforce can sometimes feel like walking through a wild garden. Records often get duplicated, fields might be incomplete, and inconsistent information can lead you to a dead end. Whe...
Join discussion
Sep 11, 2024 · 2 min read · Problem description & analysis: We have two Excel sheets, and there are same-structure tables in the two sheets. Sheet1 ABC 1Col1Col2Col3 2foo1NA 3bar2y 4baz3bar 5foo4z 6bar5NA 7baz6foo Sheet2 ABC 1Col1Col2Col3 2foo7bar 3bar8b...
Join discussion
Jul 10, 2024 · 1 min read · Today I earned my "Clean, transform, and load data in Power BI" badge! I’m so proud to be celebrating this achievement and hope this inspires you to start your own @MicrosoftLearn journey! Keep up the great work! Click to see my new achievement
Join discussionFeb 22, 2024 · 6 min read · Introduction Data wrangling is like preparing ingredients before cooking a meal. Imagine you have different types of vegetables, meat, and spices. Before you start cooking, you need to wash, chop, and organize everything neatly so that you can easily...
Join discussion
May 21, 2023 · 4 min read · Libraries import pandas as pd Data Loading df = pd.read_csv('features.csv') df df.describe() The describe() function in Pandas provides descriptive statistics of a DataFrame or Series. When applied to a DataFrame, it calculates and displays vari...
Join discussion
May 16, 2023 · 17 min read · INTRODUCTION Welcome to the world of data cleaning and preprocessing! In data analysis, a crucial step forms the foundation for accurate and reliable insights: data cleaning and preprocessing. If you're new to this exciting field, fear not! This begi...
CCess commented
