Python Pandas - 形成两个索引对象之间的交集并对结果进行排序


若要形成两个索引对象之间的交集,请在 Pandas 中使用 index1.intersection(index2) 方法。若要对结果进行排序,请使用 sort 参数。

首先,导入必需的库 −

import pandas as pd

创建 Pandas index1 和 index2 −

index1 = pd.Index([4, 3, 2, 1]) index2 = pd.Index([8, 2, 6, 4])

显示 Pandas index1 和 index2

print("Pandas Index1...\n",index1) print("Pandas Index2...\n",index2)

执行交集操作。使用“sort”参数对结果进行排序

res = index1.intersection(index2, sort=None)

示例

以下是代码 −

Open Compiler
import pandas as pd # Creating Pandas index1 and index2 index1 = pd.Index([4, 3, 2, 1]) index2 = pd.Index([8, 2, 6, 4]) # Display the Pandas index1 and index2 print("Pandas Index1...\n",index1) print("Pandas Index2...\n",index2) # Return the number of elements in Index1 and Index2 print("\nNumber of elements in index1...\n",index1.size) print("\nNumber of elements in index2...\n",index2.size) # Perform intersection # The results are sorted using the "sort" parameter res = index1.intersection(index2, sort=None) # Intersection of both the indexes and returning sorted result print("\nThe index1 and index2 intersection (sorted result)...\n",res)

输出

将产生以下输出 −

Pandas Index1...
Int64Index([4, 3, 2, 1], dtype='int64')
Pandas Index2...
Int64Index([8, 2, 6, 4], dtype='int64')

Number of elements in index1...
4

Number of elements in index2...
4

The index1 and index2 intersection (sorted result)...
Int64Index([2, 4], dtype='int64')

更新于: 2021 年 10 月 14 日

567 次浏览

开启您的 职业生涯

通过完成本课程获得认证

立即开始
广告