Python Pandas - 返回完全刪除重複值的索引


要返回完全刪除重複值的索引,請使用 index.drop_duplicates() 方法。

首先,匯入所需庫 −

import pandas as pd

建立包含一些重複資料的索引 −

index = pd.Index(['Car','Bike','Airplane','Ship','Airplane'])

顯示索引 −

print("Pandas Index with duplicates...\n",index)

返回刪除了重複值的索引。值為 "False" 的 "keep" 引數將丟棄每組重複項的所有出現 −

print("\nIndex with duplicate values removed (drops all occurrences)...\n",
index.drop_duplicates(keep = False))

示例

以下為程式碼 −

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 "False" drops all occurrences for each set of duplicated entries
print("\nIndex with duplicate values removed (drops all occurrences)...\n",
index.drop_duplicates(keep = False))

輸出

將生成以下程式碼 −

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 (drops all occurrences)...
Index(['Car', 'Bike', 'Ship'], dtype='object')

更新於: 13-10-2021

197 瀏覽

開啟你的 事業

完成課程獲得認證

開始
廣告