Pandas报错AttributeError: Cannot access callable attribute 'sort_values' of 'DataFrameGroupBy' objects
完整报错如下:
AttributeError: Cannot access callable attribute 'sort_values' of 'DataFrameGroupBy' objects, try using the 'apply' method
报错代码如下:
import pandas as pd data = pf.read_csv('test.csv',header = 0) df = pd.DataFrame(data) df = df.groupby('date', group_keys=False).sort_values('Value', ascending=False).groupby('date').head(10).reset_index() print(df)
报错原因:
groupby 之后变成了 DataFrameGroupBy,不能直接调用 sort_values() 函数,需使用 apply() 函数,代码更改为如下:
import pandas as pd data = pf.read_csv('test.csv',header = 0) df = pd.DataFrame(data) df = df.groupby('date', group_keys=False).apply(lambda x: x.sort_values('virus_connectivity', ascending=False)).groupby('date').head(10).reset_index() print(df)
以上,问题解决~