Data Cleaning in Python
Last Updated on November 8, 2023 by Editorial Team
Author(s): Louis Adibe
Originally published on Towards AI.
Master data cleaning in Python using the Panda library
Scott Graham on Unsplash
Today, I will show you how to implement data cleaning using pandas.
The dataset used in this publication comes from open-rice Hongkong
OpenRice.com is Hong Kong's most popular dining guide to help people find places to eat based on restaurant reviews…
www.openrice.com
And you can find the raw data here:
https://raw.githubusercontent.com/Louis192/Data/main/open-rice.csv
Pandas is a Python library that can be imported as pd for short.
There are different ways or forms of cleaning datasets in pandas, and today, I will focus on only three tracks.
Image by Author
The above diagram illustrates the three ways of data cleaning that I will be implementing today.
import pandas as pddf=pd.read_csv('data/open-rice.csv')df.head()Top… Read the full blog for free on Medium.
Join thousands of data leaders on the AI newsletter. Join over 80,000 subscribers and keep up to date with the latest developments in AI. From research to projects and ideas. If you are building an AI startup, an AI-related product, or a service, we invite you to consider becoming a sponsor.
Published via Towards AI
Towards AI Academy
We Build Enterprise-Grade AI. We'll Teach You to Master It Too.
15 engineers. 100,000+ students. Towards AI Academy teaches what actually survives production.
Start free — no commitment:
→ 6-Day Agentic AI Engineering Email Guide — one practical lesson per day
→ Agents Architecture Cheatsheet — 3 years of architecture decisions in 6 pages
Our courses:
→ AI Engineering Certification — 90+ lessons from project selection to deployed product. The most comprehensive practical LLM course out there.
→ Agent Engineering Course — Hands on with production agent architectures, memory, routing, and eval frameworks — built from real enterprise engagements.
→ AI for Work — Understand, evaluate, and apply AI for complex work tasks.
Note: Article content contains the views of the contributing authors and not Towards AI.