Unlock the full potential of AI with Building LLMs for Production—our 470+ page guide to mastering LLMs with practical projects and expert insights!


Data Cleaning in Python
Artificial Intelligence   Data Engineering   Data Science   Latest   Machine Learning

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 libraryData Cleaning in Python
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…


And you can find the raw data here:


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

Feedback ↓