Python Pandas – Remove leading and trailing whitespace from more than one column

To remove leading or trailing whitespace, use the strip() method. At first, create a DataFrame with 3 columns “Product Category”, “Product Name” and “Quantity” −

dataFrame = pd.DataFrame({ 'Product Category': [' Computer', ' Mobile Phone', 'Electronics ', 'Appliances', ' Furniture', 'Stationery'],'Product Name': ['Keyboard', 'Charger', ' SmartTV', 'Refrigerators', ' Chairs', 'Diaries'],'Quantity': [10, 50, 10, 20, 25, 50]})

Removing whitespace from more than one column −

dataFrame['Product Category'].str.strip() dataFrame['Product Name'].str.strip()

Example

Following is the complete code −

import pandas as pd # create a dataframe with 3 columns dataFrame = pd.DataFrame({    'Product Category': [' Computer', ' Mobile Phone', 'Electronics ', 'Appliances', ' Furniture', 'Stationery'],'Product Name': ['Keyboard', 'Charger', ' SmartTV', 'Refrigerators', ' Chairs', 'Diaries'],'Quantity': [10, 50, 10, 20, 25, 50]}) # removing whitespace from more than 1 column dataFrame['Product Category'].str.strip() dataFrame['Product Name'].str.strip() # dataframe print"Dataframe after removing whitespaces...\n",dataFrame

Output

This will produce the following output −

Dataframe after removing whitespaces...    Product Category   Product Name Quantity 0         Computer       Keyboard 10 1     Mobile Phone        Charger 50 2      Electronics        SmartTV 10 3       Appliances  Refrigerators 20 4        Furniture         Chairs 25 5       Stationery        Diaries 50