Python - 从 Pandas DataFrame 中删除重复值
pythonserver side programmingprogramming更新于 2025/11/1 1:48:17
要从 Pandas DataFrame 中删除重复值，请使用 drop_duplicates() 方法。首先，创建一个包含 3 列的 DataFrame −
dataFrame = pd.DataFrame({'Car': ['BMW', 'Mercedes', 'Lamborghini', 'BMW', 'Mercedes', 'Porsche'],'Place': ['Delhi', 'Hyderabad', 'Chandigarh', 'Delhi', 'Hyderabad', 'Mumbai'],'UnitsSold': [95, 70, 80, 95, 70, 90]})
删除重复值 −
dataFrame = dataFrame.drop_duplicates()
示例
以下是完整代码 −
import pandas as pd
# 创建 DataFrame
dataFrame = pd.DataFrame({'Car': ['BMW', 'Mercedes', 'Lamborghini', 'BMW', 'Mercedes', 'Porsche'],'Place': ['Delhi', 'Hyderabad', 'Chandigarh', 'Delhi', 'Hyderabad', 'Mumbai'], 'UnitsSold': [95, 70, 80, 95, 70, 90]})
print"Dataframe...\n", dataFrame
# 计数 Car 列的频率
count = dataFrame['Car'].value_counts()
print"\n计数 Car 列中的数值"
print(count)
# 删除重复项
dataFrame = dataFrame.drop_duplicates()
print"\n删除重复项后更新的 DataFrame...\n",dataFrame
# 删除重复项后计算 Car 列的频率
count = dataFrame['Car'].value_counts()
print"\nCount in column Car"
print(count)
输出
这将产生以下输出 −
Dataframe... Car Place UnitsSold 0 BMW Delhi 95 1 Mercedes Hyderabad 70 2 Lamborghini Chandigarh 80 3 BMW Delhi 95 4 Mercedes Hyderabad 70 5 Porsche Mumbai 90 Count in column Car BMW 2 Mercedes 2 Porsche 1 Lamborghini 1 Name: Car, dtype: int64 Updated DataFrame after removing duplicates... Car Place UnitsSold 0 BMW Delhi 95 1 Mercedes Hyderabad 70 2 Lamborghini Chandigarh 80 5 Porsche Mumbai 90 Count in column Car BMW 1 Porsche 1 Lamborghini 1 Mercedes 1 Name: Car, dtype: int64
相关文章
有用资源
python 参考教程 - 该教程包含有关 python 的更多信息:https://www.cainiaomax.com/python/
