sort excel columns using pandas [duplicate]

Question

I want to sort the excel file worksheet called "LTE_PrbUtil" and it has a column called "CELL" which is string descending. When I run the program and find some error:

  File "C:\Users\p4532\Desktop\QGIS_project\highloading.py", line 18, in <module> df = df.sort(columns="CELL")
  File "C:\Python27\lib\site-packages\pandas\core\generic.py", line 3081, in __getattr__
    return object.__getattribute__(self, name)
AttributeError: 'DataFrame' object has no attribute 'sort'`

Here is my code:

import shutil
import pandas as pd
import xlrd
xl=pd.ExcelFile("C:\Users\p4532\Desktop\QGIS_project\HighUtilCells_new.xlsx")                                                                           
df = xl.parse("LTE_PrbUtil")
df = df.sort(columns="CELL")

It seems the dataframe cannot recognize sort. Can anyone help?

sort is deprecated.

cs95
– cs95

2017-10-17 03:06:07 +00:00
Commented Oct 17, 2017 at 3:06 — cs95
– cs95, Commented Oct 17, 2017 at 3:06

Scott Boston · Accepted Answer · 2017-10-17 02:59:05Z

3

Use sort_values:

df = df.sort_values('CELL')

answered Oct 17, 2017 at 2:59

Scott Boston

154k15 gold badges160 silver badges207 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sort excel columns using pandas [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related