为什么我的 Python 熊猫数据帧条带方法不适用于尾随空格？我该如何解决它？

Question

我有这样的代码从数据帧中去除空白

# 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]})
print ("Dataframe before removing whitespaces...n",dataFrame)
# 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)

删除空白之前的数据帧。。。

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

删除空白后的数据帧。。。

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

"后面的空白；Electronics"；没有剥离。你知道我该怎么解决这个问题吗？

Answer 1

正如Umar所说，你需要做这样的事情：

# 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]})
print ("Dataframe before removing whitespaces...n",dataFrame)
# removing whitespace from more than 1 column
dataFrame['Product Category'] = dataFrame['Product Category'].str.strip()
dataFrame['Product Name'] = dataFrame['Product Name'].str.strip()
# dataframe
print ("Dataframe after removing whitespaces...n",dataFrame)