Python – 从 Pandas DataFrame 中去除空格
要去除空格，无论是前导还是尾随，请使用该strip()方法。首先，让我们使用别名导入所需的Pandas库-
import pandas as pd
让我们创建一个包含3列的DataFrame。第一列有前导和尾随空格-
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]})从单列“产品类别”中删除空格-
dataFrame['Product Category'].str.strip()
示例
以下是完整的代码-
import pandas as pd
#createadataframewith3columns
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]})
#removingwhitespacefromasinglecolumn
dataFrame['Product Category'].str.strip()
#dataframe
print"Dataframe after removing whitespaces...\n",dataFrame输出结果这将产生以下输出-
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
热门推荐
10 送朋友内裤祝福语简短
11 老婆祝福语简短8字
12 可爱小狗祝福语简短
13 新娘贺词结婚祝福语简短
14 竞选班长祝福语简短精辟
15 和地理老师祝福语简短
16 过年给美女祝福语简短
17 感谢朋友的祝福语简短
18 医务科新年祝福语简短