Python Pandas - 形成两个 Index 对象的并集但不排序结果


要形成两个 Index 对象的交集,在 Pandas 中使用 index1.intersection(index2) 方法。要避免对结果进行排序,请使用 sort 参数并将其设置为 False

首先,导入所需的库 -

import pandas as pd

创建两个 Pandas 索引 -

index1 = pd.Index([10, 20, 30, 40, 50])
index2 = pd.Index([80, 65, 60, 70, 55])

显示 Pandas index1 和 index2 -

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

执行并集操作。我们使用值‘False’使用了“排序”参数,以对结果执行非排序 -

res = index1.union(index2, sort=False)

示例

代码如下 -

import pandas as pd

# Creating two Pandas index
index1 = pd.Index([10, 20, 30, 40, 50])
index2 = pd.Index([80, 65, 60, 70, 55])

# 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 union
# We have used the "sort" parameter to unsort the results
res = index1.union(index2, sort=False)

# Union of both the indexes
# Results are unsorted
print("\nThe index1 and index2 Union with unsorted result...\n",res)

输出

将产生以下输出 -

Pandas Index1...
Int64Index([10, 20, 30, 40, 50], dtype='int64')
Pandas Index2...
Int64Index([80, 65, 60, 70, 55], dtype='int64')

Number of elements in index1...
5

Number of elements in index2...
5

The index1 and index2 Union with unsorted result...
Int64Index([10, 20, 30, 40, 50, 80, 65, 60, 70, 55], dtype='int64')

更新时间: 2021-10-14

223 次浏览

启动您的职业生涯

通过完成课程获得认证

开始
广告
© . All rights reserved.