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
Analyzed COVID-19 data across US states using Python, Pandas, and Matplotlib. Cleaned and processed raw Excel data, calculated key metrics such as Death Rate (%) and Positive Rate (%), and generated US-wide summary statistics. Created visualizations to identify trends and compare state-level COVID-19 impacts. This project demonstrates skills in data cleaning, analysis, and data visualization.
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
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.
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?
Related posts
Real-World Data Cleaning with Python & Pandas:
Cleaned a real-world messy dataset (highest-grossing concert tours) using Python and pandas. Handled missing values, removed irrelevant columns, converted currency text to numeric values, and resolved encoding issues like hidden Unicode characters and footnote markers embedded in the raw data.
Tools used: Python, pandas
https://github.com/emanwajid85/concert-tours-data-cleaning
I built a small data-cleaning workflow around one simple rule: bad rows should never silently disappear.
Synthetic demo results:
• 20 raw order records
• 16 clean rows
• 2 duplicates removed
• 2 invalid rows quarantined
• $3,690 paid revenue reconciled
The output includes a clean CSV, a rejected-row file, an audit log, and an Excel dashboard. Dates, names, emails, regions, products, and payment statuses are standardized.
The key design choice is quarantine + reasons, not just dropping bad rows and exporting. That lets a reviewer trace exactly what changed and decide whether rejected records should be repaired.
For recurring exports, what needs the most manual review in your workflow: duplicates, inconsistent labels, or invalid amounts and dates?
I help businesses turn messy, disorganized data into clean, usable insights — and automate the repetitive tasks that eat up your time.
What I offer:
🧹 Data Cleaning — Excel/CSV cleanup, deduplication, formatting, handling missing values
🕸️ Web Scraping — extracting structured data from any public website, at any scale
⚙️ Automation — scheduled reports, Google Sheets integration, automated email delivery
I build real, working solutions — not just one-off scripts. Every project I take on is designed to be reliable and easy for you to understand and reuse.
See examples of my work: github.com/emanwajid85
