如何比较两个不同长度的 Python Pandas 系列？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/30214328/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How do I compare two Python Pandas Series of different lengths?
提问by HaPsantran
I have two Series of different lengths, and I want to get the indices for which both the indices andthe amountare the same in both series.
我有两个不同长度的系列，我想获得两个系列中指数和数量都相同的指数。
Here are the Series:
以下是系列：
ipdb> s1
s1
000007720 2000.00
group1 -3732.05
group t3 2432.12
group2 -38147.87
FSHLAJ -36711.09
EWkayuwo -3.22
Name: amount, dtype: float64
ipdb> s2
s2
000007720 2000.00
group1 -3732.05
group z 12390.00
group y 68633.43
group x 25.00
group w 3913.00
group v -12750.50
group u -53.49
group t -7500.00
group s -1575.82
group r -10.00
group q 1800.00
group p -4510.34
EWFhjkaQU 455.96
group2 -38147.87
FSHLAJ -36711.09
GEKWJ 5.54
Name: amount, dtype: float64
When I try to compare them, I get:
当我尝试比较它们时，我得到：
ipdb>s1 == s2
*** ValueError: Series lengths must match to compare
How can I achieve my objective?
我怎样才能实现我的目标？
回答by EdChum
You want to use isin:
你想使用isin：
In [121]:
s2[s2.isin(s1)]
Out[121]:
000007720
group1 -3732.05
group2 -38147.87
FSHLAJ -36711.09
Name: 2000.00, dtype: float64
I don't know which way round you wanted to perform the comparison, here is the other way:
我不知道你想用哪种方式进行比较，这是另一种方式：
In [122]:
s1[s1.isin(s2)]
Out[122]:
000007720
group1 -3732.05
group2 -38147.87
FSHLAJ -36711.09
Name: 2000.00, dtype: float64
The problem with trying to do s1 == s2is that it doesn't make sense comparing Series or arrays of different lengths.
尝试这样做的问题s1 == s2是比较不同长度的系列或数组没有意义。
If you want the indices to match also then add this as a condition:
如果您还希望索引匹配，则将其添加为条件：
In [131]:
s1[(s1.index.isin(s2.index)) & (s1.isin(s2))]
Out[131]:
000007720
group1 -3732.05
group2 -38147.87
FSHLAJ -36711.09
Name: 2000.00, dtype: float64
