python 两组数据显著差异_查找两列之间差异最大的行

我有一个包含Gold和Gold.1列的数据帧。我想找出这两列的差异最大的行。

对于下面的数据帧，这将返回我的第6行。df

Out:

Gold Gold.1

0 2 1

1 1 4

2 6 9

3 4 4

4 4 8

5 5 5

6 5 2 ---> The difference is maximum (3)

7 5 9

8 5 3

9 5 6

我试着用了以下方法：df.where(max(df['Gold']-df['Gold.1']))

但这引发了一个值错误：df.where(max(df['Gold']-df['Gold.1']))

Traceback (most recent call last):

File "", line 1, in

df.where(max(df['Gold']-df['Gold.1']))

File "../python3.5/site-packages/pandas/core/generic.py", line 5195, in where

raise_on_error)

File "../python3.5/site-packages/pandas/core/generic.py", line 4936, in _where

raise ValueError('Array conditional must be same shape as '

ValueError: Array conditional must be same shape as self

如何找到满足此条件的行？