'DataFrame' object has no attribute 'sort'

#-*- coding: utf-8 -*-
#菜品盈利数据 帕累托图
from __future__ import print_function
import pandas as pd

#初始化参数
dish_profit = '../data/catering_dish_profit.xls' #餐饮菜品盈利数据
data = pd.read_excel(dish_profit, index_col = u'菜品名')
data = data[u'盈利'].copy()
data.sort(ascending = False)

出错

AttributeError: 'Series' object has no attribute 'sort'

原因

sort() was deprecated for DataFrames in favor of either:

• sort_values() to sort by column(s)
• sort_index() to sort by the index

sort() was deprecated (but still available) in Pandas with release 0.17 (2015-10-09) with the introduction of sort_values() and sort_index(). It was removed from Pandas with release 0.20 (2017-05-05).

解决方法

改成data.sort_values(ascending=False)