String cleaning (strip, lower, replace) in Data Analysis Python - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the strip() method do to a string?

The strip() method removes any spaces or specified characters from the start and end of a string. It helps clean extra spaces around text.

beginner

How does the lower() method help in string cleaning?

The lower() method converts all letters in a string to lowercase. This makes text uniform and easier to compare.

beginner

What is the purpose of the replace(old, new) method in string cleaning?

The replace() method changes all occurrences of a specified substring (old) with another substring (new). It helps fix or standardize text.

beginner

Given the string ' Hello World! ', what will string.strip().lower() return?

It will return 'hello world!'. First, strip() removes spaces at start and end, then lower() makes all letters lowercase.

beginner

Why is string cleaning important before analyzing text data?

String cleaning removes unwanted spaces, fixes letter cases, and replaces inconsistent parts. This makes data consistent and easier to analyze correctly.

What does my_string.strip() do?

A Replaces all spaces inside <code>my_string</code> with underscores

B Converts <code>my_string</code> to lowercase

C Splits <code>my_string</code> into a list of words

D Removes spaces from the start and end of <code>my_string</code>

strip() removes spaces or specified characters from the start and end of a string.

Which method changes all letters in a string to lowercase?

A strip()

B lower()

C replace()

D capitalize()

lower() converts all letters in a string to lowercase.

What will 'Data Science'.replace('Data', 'Big') return?

A 'Big Science'

B 'Data Big'

C 'Data Science'

D 'BigData Science'

The replace() method changes 'Data' to 'Big', so the result is 'Big Science'.

Why do we use string cleaning before analysis?

A To encrypt the data

B To increase the size of the dataset

C To make text data consistent and easier to compare

D To remove numbers from text

Cleaning text removes inconsistencies like extra spaces and case differences, making analysis more accurate.

What does ' Hello '.strip().lower() output?

A 'hello'

B ' hello '

C 'HELLO'

D 'Hello'

First, strip() removes spaces, then lower() converts to lowercase, resulting in 'hello'.

Explain how you would clean a text column in a dataset using strip(), lower(), and replace().

Think about removing spaces, unifying letter cases, and fixing words.

Why is it important to clean strings before comparing or analyzing text data?

Consider how messy text can cause confusion in analysis.

Practice

1. What does the strip() method do to a string in Python?

easy

A. Replaces parts of the string with new text

B. Removes spaces from the start and end of the string

C. Converts all characters to lowercase

D. Splits the string into a list of words

Solution

1. Step 1: Understand the purpose of strip()

   The strip() method removes whitespace characters from the beginning and end of a string.

2. Step 2: Compare with other methods

   lower() changes case, replace() changes parts of the string, and splitting creates lists, so they do not match strip().

3. Final Answer:

   Removes spaces from the start and end of the string -> Option B

4. Quick Check:

   strip() = remove spaces [OK]

Hint: strip() cleans edges of spaces fast [OK]

Common Mistakes:

• Thinking strip() changes case
• Confusing strip() with replace()
• Assuming strip() splits strings

2. Which of the following is the correct syntax to replace all occurrences of 'cat' with 'dog' in the string text?

easy

A. text.lower('cat', 'dog')

B. text.replace('dog', 'cat')

C. text.strip('cat', 'dog')

D. text.replace('cat', 'dog')

Solution

1. Step 1: Identify the correct method for replacement

   The replace() method is used to change parts of a string by specifying the old and new substrings.

2. Step 2: Check the syntax

   The syntax is string.replace(old, new). So, to replace 'cat' with 'dog', it is text.replace('cat', 'dog').

3. Final Answer:

   text.replace('cat', 'dog') -> Option D

4. Quick Check:

   replace(old, new) = correct syntax [OK]

Hint: replace(old, new) swaps text parts [OK]

Common Mistakes:

• Swapping old and new strings
• Using strip() or lower() instead of replace()
• Wrong method call syntax

3. What will be the output of the following code?

text = '  Hello World  '
cleaned = text.strip().lower().replace('world', 'there')
print(cleaned)

medium

A. 'hello there'

B. 'hello world'

C. ' hello there '

D. 'Hello There'

Solution

1. Step 1: Apply strip() to remove spaces

   The original string has spaces at start and end. strip() removes them, so string becomes 'Hello World'.

2. Step 2: Apply lower() to convert to lowercase

   Converts 'Hello World' to 'hello world'.

3. Step 3: Apply replace() to change 'world' to 'there'

   Replaces 'world' with 'there', resulting in 'hello there'.

4. Final Answer:

   'hello there' -> Option A

5. Quick Check:

   strip + lower + replace = 'hello there' [OK]

Hint: Chain strip, lower, replace for clean text [OK]

Common Mistakes:

• Forgetting strip() removes spaces
• Not converting to lowercase before replace
• Replacing with wrong case

4. The following code is intended to clean a string by removing spaces and converting to lowercase, but it causes an error. What is the problem?

text = '  Data Science  '
cleaned = text.strip.lower()
print(cleaned)

medium

A. replace() method is missing

B. lower() should be called before strip()

C. strip() is missing parentheses

D. print() is used incorrectly

Solution

1. Step 1: Identify method call syntax

   Methods like strip() require parentheses to be called. Here, strip is used without parentheses, so it is a method object, not called.

2. Step 2: Understand the error

   Trying to call lower() on a method object causes an error because strip was not executed.

3. Final Answer:

   strip() is missing parentheses -> Option C

4. Quick Check:

   Method calls need () [OK]

Hint: Always add () to call methods [OK]

Common Mistakes:

• Forgetting parentheses on methods
• Thinking order of strip and lower causes error
• Assuming replace() is required

5. You have a list of product codes with inconsistent formatting:

codes = ['  AB123 ', 'cd456', ' EF789', 'GH 012 ']

Which code snippet correctly cleans all codes by removing leading and trailing spaces and converting to lowercase?

hard

A. cleaned = [code.strip().lower() for code in codes]

B. cleaned = [code.lower() for code in codes]

C. cleaned = [code.replace(' ', '').lower() for code in codes]

D. cleaned = [code.strip().replace(' ', '').lower() for code in codes]

Solution

1. Step 1: Understand the goal

   We want to remove leading and trailing whitespace from each code and convert all letters to lowercase, preserving internal spaces.

2. Step 2: Analyze each option

   cleaned = [code.strip().lower() for code in codes] uses strip() to remove leading/trailing whitespace then lower() to convert case. Correct (e.g., 'GH 012 ' -> 'gh 012').
   cleaned = [code.lower() for code in codes] only converts to lowercase, leaves leading/trailing spaces. Incorrect.
   cleaned = [code.replace(' ', '').lower() for code in codes] removes all spaces including internal ('GH 012 ' -> 'gh012'). Incorrect.
   cleaned = [code.strip().replace(' ', '').lower() for code in codes] replace() removes internal spaces after strip(). Incorrect.

3. Final Answer:

   cleaned = [code.strip().lower() for code in codes] -> Option A

4. Quick Check:

   strip then lower cleans codes [OK]

Hint: Use strip() then lower() in list comprehension [OK]

Common Mistakes:

• Forgetting strip() and only using lower() leaves spaces
• Using replace(' ', '') removes internal spaces
• Redundant replace after strip removes internal spaces