mBlock Coding and Robotics Starter Classes in Bedok, Singapore

1. Introduction: Why String Cleaning Is Critical

Client text rarely arrives standardized. Common problems:

• Inconsistent casing — "ELECTRONICS" vs "electronics" (Python is case-sensitive)
• Leading/trailing spaces — e.g. " Shoes " breaks grouping and filters
• Unwanted separators — hyphens and symbols used inconsistently

Pandas string tools live under the .str accessor. A typical pipeline:

"  HOME-APPLIANCES  "
  → .str.strip()    → "HOME-APPLIANCES"
  → .str.lower()    → "home-appliances"
  → .str.replace()  → "home appliances"

2. Setup: Dirty Text in a DataFrame

import pandas as pd

data = {
    "Product_ID": [101, 102, 103, 104],
    "Category": [
        "  ELECTRONICS  ",          # whitespace + uppercase
        "home-appliances",         # hyphen
        "CLOTHING-ACCESSORIES  ",  # uppercase, hyphen, trailing space
        "  electronics"            # leading space + lowercase
    ]
}

df = pd.DataFrame(data)
print(df)

Rows 0 and 3 are the same category but do not match until cleaned. Rows 1 and 2 need hyphens turned into spaces.

3. Case and Whitespace: .str.lower() and .str.strip()

• .str.lower() — all letters lowercase for uniform matching
• .str.strip() — remove leading and trailing spaces

Chain them and store in a new column:

df["Category_Clean"] = df["Category"].str.strip().str.lower()
print(df[["Category", "Category_Clean"]])

Result: whitespace gone and every entry lowercase (e.g. both electronics rows align).

4. Replacing Characters with .str.replace()

df["Category_Clean"] = df["Category_Clean"].str.replace("-", " ")
print(df[["Category", "Category_Clean"]])

"home-appliances" → "home appliances"; "clothing-accessories" → "clothing accessories". Text is then lowercase, trimmed, and free of hyphens.

5. Essential Methods at a Glance

Method	Syntax	What it does
lower()	df[col].str.lower()	All letters lowercase — fixes case-sensitive mismatches
strip()	df[col].str.strip()	Trims leading/trailing spaces — clean grouping and filters
replace()	df[col].str.replace(old, new)	Swap characters (e.g. hyphens → spaces)