Python Pandas - 返回值中删除重复值,但保留第一个值
要返回值中删除重复值,但保留第一个值,请使用 index.drop_duplicates() 方法。使用 keep 参数,值设为 first。
首先,导入所需的库 −
import pandas as pd
创建具有某些重复值的索引 −
index = pd.Index(['Car','Bike','Airplane','Ship','Airplane'])
显示索引 −
print("Pandas Index with duplicates...\n",index)返回值中删除重复值。值设为 "first" 的 "keep" 参数保留每组重复条目的第一次出现 −
index.drop_duplicates(keep='first')
示例
以下是代码 −
import pandas as pd
# Creating the index with some duplicates
index = pd.Index(['Car','Bike','Airplane','Ship','Airplane'])
# Display the index
print("Pandas Index with duplicates...\n",index)
# Return the dtype of the data
print("\nThe dtype object...\n",index.dtype)
# get the bytes in the data
print("\nGet the bytes...\n",index.nbytes)
# get the dimensions of the data
print("\nGet the dimensions...\n",index.ndim)
# Return Index with duplicate values removed
# The "keep" parameter with value "first" keeps the first occurrence for each set of duplicated entries
print("\nIndex with duplicate values removed (keeping the first occurrence)...\n",index.drop_duplicates(keep='first'))输出
这将生成以下代码 −
Pandas Index with duplicates... Index(['Car', 'Bike', 'Airplane', 'Ship', 'Airplane'], dtype='object') The dtype object... object Get the bytes... 40 Get the dimensions... 1 Index with duplicate values removed (keeping the first occurrence)... Index(['Car', 'Bike', 'Airplane', 'Ship'], dtype='object')
广告
数据结构
网络
RDBMS
操作系统
Java
iOS
HTML
CSS
Android
Python
C 编程
C++
C#
MongoDB
MySQL
Javascript
PHP