DataFrame object does not have a sort attribute

Question

hi, can help me resolve issues?

【】 Anaconda3-4.4.0

import pandas as pd
from sqlalchemy import create_engine

engine = create_engine('mysql+pymysql://root:123456@localhost:3306/mysql?charset=utf8')
sql = pd.read_sql('all_gzdata', engine, chunksize = 10000)

counts = [ i['fullURLId'].value_counts() for i in sql] 
counts = pd.concat(counts).groupby(level=0).sum() 
counts = counts.reset_index() 
counts.columns = ['index', 'num'] 
counts['type'] = counts['index'].str.extract('(\d{3})') 
counts_ = counts[['type', 'num']].groupby('type').sum() 

the above codes are normal, but if I add the sentence below python warns: "DataFrame object" does not have attribute "sort" "

counts_.sort('num', ascending = False)

Answer 1

... The issue is resolved.

The last code should be "counts_.sort_values ​​('num', ascending = False)" .