Вивчайте Challenge: Remove Whitespace from Strings

When working with categorical data in a DataFrame, extra whitespace at the beginning or end of string values can cause serious inconsistencies. For example, the values "apple", " apple", and "apple " may look the same to you, but Python treats them as different strings. This can lead to problems when grouping, filtering, or comparing data, and may result in incorrect analysis or missed patterns. Cleaning up these inconsistencies by stripping whitespace is a crucial first step in preparing your data for analysis.


              12345678910
            
import pandas as pd

data = {
    "Fruit": [" apple", "banana ", "  cherry ", "date"],
    "Color": [" red", "yellow ", " red ", "brown"],
    "Count": [10, 5, 7, 3]
}

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

Завдання

Swipe to start coding

Write a function that removes leading and trailing whitespace from all string columns in a DataFrame.

The function must return a new DataFrame with the same columns as the input.
All leading and trailing whitespace must be removed from every string value in columns with string data type.
Non-string columns must remain unchanged.

Рішення

Все було зрозуміло?

Дякуємо за ваш відгук!

Секція 1. Розділ 5

single

Запитати АІ

Запитайте про що завгодно або спробуйте одне із запропонованих запитань, щоб почати наш чат

Awesome!

Completion rate improved to 5.56

Свайпніть щоб показати меню


              12345678910
            
import pandas as pd

data = {
    "Fruit": [" apple", "banana ", "  cherry ", "date"],
    "Color": [" red", "yellow ", " red ", "brown"],
    "Count": [10, 5, 7, 3]
}

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