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)
示例
以下是代码 −
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')
广告