Python Pandas - 形成两个 Index 对象的交集并对结果进行排序

要形成两个Index对象的交集，请使用Pandas中的index1.intersection(index2)方法。要对结果进行排序，请使用sort参数。

首先，导入所需的库-

import pandas as pd

创建Pandasindex1和index2-

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

显示Pandasindex1和index2

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

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

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

示例

以下是代码-

import pandas as pd #创建Pandasindex1和index2 index1 = pd.Index([4, 3, 2, 1]) index2 = pd.Index([8, 2, 6, 4]) #显示Pandasindex1和index2 print("Pandas Index1...\n",index1) print("Pandas Index2...\n",index2) #返回Index1和Index2中元素的数量 print("\nNumber of elements in index1...\n",index1.size) print("\nNumber of elements in index2...\n",index2.size) #执行交叉 # The results are sorted using the "sort" parameter res = index1.intersection(index2, sort=None) #索引和返回排序结果的交集 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)