我在试着找出maximum_pressure和minimum_pressure哪一天的差异最大，

Question

附上了数据框照片，尝试了一天，但得到了错误

Maximum pressure  Minimum pressure  Day
12                   21             2013/03/12
25                   14             2015/04/16
27                   18             2010/09/21 

df.loc[max(df['Maximum pressure '] -df['Minimum pressure ']),'Day']

Answer 1

我会这样做：(inp =问题中的df片段)

import pandas as pd

inp = [{'maximum pressure':12, 'minimum pressure':21,'Date':'2013/03/12'}, {'maximum pressure':25,'minimum pressure':14,'Date':'2015/04/16'}, {'maximum pressure':27,'minimum pressure':18,'Date':'2010/09/21'}]

df = pd.DataFrame(inp)

df['difference pressure']= df['maximum pressure']-df['minimum pressure']

df.loc[df['difference pressure'] == df['difference pressure'].max()]