DEV Community

jayanth anbu
jayanth anbu

Posted on

Hands-on Data Cleaning Using Pandas in Google Colab

Data cleaning is one of the most crucial steps in any data science or analytics project. In this challenge, I worked on a real-world dataset from Kaggle with over 100,000 rows, performing various Pandas operations to clean, preprocess, and prepare it for further analysis.

๐Ÿ“‚ Dataset Details
For this challenge, I selected the E-commerce Sales Dataset from Kaggle containing around 120,000 rows and 12 columns.

It includes data such as:

๐Ÿงพ Order ID
๐Ÿ‘ค Customer Name
๐Ÿ›’ Product & Quantity
๐Ÿ’ฐ Sales & Discount
๐ŸŒ Region
๐Ÿ“… Order Date
Before Cleaning:

Rows โ†’ 120,000
Columns โ†’ 12
File format โ†’ .csv

โš™๏ธ Tools & Environment
Python 3
Google Colab
Libraries: Pandas, NumPy, Matplotlib

Top comments (0)