在下面的代码中,每个“Person”都有一个对应的“Sales”值,但是当我执行print(compData.max())“Vanessa”时,得到的值是“340”,它在初始的“df”中属于“Amy”
import numpy as np
import pandas as pd
data = {'Company':['GOOG','GOOG','MSFT','MSFT','FB','FB'],
'Person':['Sam','Charlie','Amy','Vanessa','Carl','Sarah'],
'Sales':[200,120,340,124,243,350]}
df = pd.DataFrame(data)
compData = df.groupby('Company')
print(df)
print(compData.max())
print(df.loc[3])
这是输出:
Company Person Sales
0 GOOG Sam 200
1 GOOG Charlie 120
2 MSFT Amy 340
3 MSFT Vanessa 124
4 FB Carl 243
5 FB Sarah 350
Person Sales
Company
FB Sarah 350
GOOG Sam 200
MSFT Vanessa 340
Company MSFT
Person Vanessa
Sales 124
此外,当我执行print(df.loc[3])“Vanessa”时获得正确的值
隔江千里
达令说
相关分类