The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Data Cleaning and Sales Analysis
## Project Overview
This project demonstrates an end-to-end data cleaning and exploratory data analysis (EDA) workflow using Python.
The dataset was intentionally generated with multiple data quality issues to simulate real-world business scenarios commonly encountered by Data Analysts and Data Scientists.
---
## Objectives
- Identify data quality issues.
- Handle missing values.
- Remove duplicate records.
- Standardize mixed date formats.
- Perform exploratory data analysis.
- Generate business insights.
- Create visualizations for decision-making.
---
## Dataset Issues
The raw dataset contained several intentional problems:
- Missing values in `Qty`
- Missing values in `Harga`
- Duplicate transactions
- Mixed date formats
- Inconsistent category naming
---
## Data Cleaning Process
The following steps were performed:
1. Loaded and profiled the raw dataset.
2. Identified missing values and duplicate records.
3. Removed duplicate transactions.
4. Filled missing values using median imputation.
5. Investigated mixed date formats.
6. Built a custom date parser to standardize dates.
7. Saved the cleaned dataset.
---
## Results
### Before Cleaning
| Metric | Value |
|----------|---------|
| Total Records | 1009 |
| Missing Qty | 8 |
| Missing Harga | 5 |
| Duplicate Records | 10 |
# After Cleaning
| Metric | Value |
|----------|---------|
| Total Records | 999 |
| Missing Qty | 0 |
| Missing Harga | 0 |
| Duplicate Records | 0 |
| Failed Date Parsing | 0 |
---
## Business Insights
### Best-Selling Products
Kopi Arabica was the top-selling product, followed by Teh Hijau and Mouse.
### Sales by City
Bandung generated the highest sales volume, indicating strong market potential compared to Surabaya and Jakarta.
### Category Performance
Electronics dominated sales performance.
An inconsistency between `Makanan` and `makanan` was discovered, highlighting the importance of data standardization before analysis.
### Revenue
The total revenue generated was:
Rp 13,593,130,000
## Technologies Used
- Python
- Pandas
- NumPy
- Matplotlib
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
Hey everyone!
I made OVERTIME 🌙 a living map of how the world really sleeps.
The problem / the idea
We celebrate the 5am club. We rarely see the others; the night-shift nurse, the new parent awake at 3am, the insomniac watching the ceiling, and the guard who clocks out at sunrise. I built this for the lyrics inspiration "8 billion people are 8 billion lamps in the night."
What it is
A quiet, generative map of a single day. Each glowing light is one real person's rhythm, when they sleep, move, eat, and how stressed they are. Data visualization is drawn from ~1,200 lives across 9 regions of the world, gathered into one symbolic city. Add your own rhythm and watch your light fly into the crowd. Toggle Weekday vs Weekend and the whole sky shifts. You find your people, you find night owls, early risers, and the sleepless. No scores, no "good" or "bad" sleep. Just where you land, among a thousand others. Whether you sleep late or barely sleep at all, the message is one: you're not alone in the dark, so please take care of yourself. 💛
How I built it (workflow + tools)
Designed in Figma and built entirely in Figma Make. The community isn't random noise; it's a research-calibrated dataset modeled as a mixture of real human archetypes (night owls, night-shift workers, the sleepless, early birds, long sleepers), so the field is genuinely human: people asleep at 6am, people with 3 hours of sleep, people who barely move. A generative particle engine renders every life as its own light, so no two nights look alike.
#ConfigMakeathon · Built with Figma + Figma Make
🌱 Smart Farming Dashboard, designed to grow results.
-> Real-time field intelligence metrics
-> Optimal planting condition tracker
-> Live sensor monitoring across zones
-> 24-hour weather trend insights
-> AI-powered yield predictions
Clean. Smart. Built for farmers who think ahead. 🚜
Smart use of data + agriculture.
Aura Peace Core App Design
An advanced wellness platform transitioning seamlessly from a light-themed workout planner to a dark-themed health telemetry dashboard.
Key Highlights
AI & Figma Make: Used to rapidly iterate responsive layouts and complex component states.
UX Architecture: Clean visual hierarchy optimized for quick readability during active training sessions.
Data Visualization: Custom UI components designed for high data-density without cluttering the screen.
Future Scope for Personalization
Adaptive Themes: Light/dark modes that automatically trigger based on your workout environment or ambient light.
Modular Dashboard: Drag-and-drop widgets so users can prioritize the exact bio-metrics matching their fitness goals.
AI Personal Insights: A smart summary card translating raw telemetry into actionable recovery and breathing tips.
The light-to-dark theme transition for a wellness app makes a lot of sense from a UX perspective. Morning workout planning in light mode, nighttime biometric review in dark, that context-awareness is good product thinking.
Trending
Claude
Claude has entered the design space. How are you using Claude Design?
Contra University
Learn from expert creatives how to earn more using next-gen AI tools.
MagicPath
The canvas is infinite, and exploration is becoming the workflow. How are you using MagicPath?
creativeaiflow
Creative AI workflows are evolving. What tools do you use, and what are their strengths and weaknesses?
freelancerlife
Freelancer life is wins, pivots, and everything in between. What’s yours right now?