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')