Skip to content Skip to sidebar Skip to footer

Greater/less Than Comparisons Between Pandas Dataframes/series

How can I perform comparisons between DataFrames and Series? I'd like to mask elements in a DataFrame/Series that are greater/less than elements in another DataFrame/Series. For in

Solution 1:

The problem here is that it's interpreting the index as column values to perform the comparison, if you use .gt and pass axis=0 then you get the result you desire:

In [203]:
x.gt(x.mean(axis=1), axis=0)

Out[203]:
       a     b
0FalseTrue1FalseTrue

You can see what I mean when you perform the comparison with the np array:

In [205]:
x > x.mean(axis=1).valuesOut[205]:
       a      b
0FalseFalse1FalseTrue

here you can see that the default axis for comparison is on the column, resulting in a different result

Post a Comment for "Greater/less Than Comparisons Between Pandas Dataframes/series"