CODEWITHSUNDEEP
pythonsortingpandasdataframe
Cobain
Cobain

Reputation: 195

Sorting a Pandas dataframe

I have the following dataframe:

Join_Count  1
LSOA11CD    
E01006512   15
E01006513   35
E01006514   11
E01006515   11
E01006518   11
...

But when I try to sort it:

BusStopList.sort("LSOA11CD",ascending=1)

I get the following:

Key Error: 'LSOA11CD'

How do I go about sorting this by either the LSOA column or the column full of numbers which doesn't have a heading?

The following is the information produced by Python about this dataframe:

<class 'pandas.core.frame.DataFrame'>
Index: 286 entries, E01006512 to E01033768
Data columns (total 1 columns):
1    286 non-null int64
dtypes: int64(1)
memory usage: 4.5+ KB

Upvotes: 1

Views: 3544

Answers (1)

Andy Hayden
Andy Hayden

Reputation: 375485

'LSOA11CD' is the name of the index, 1 is the name of the column. So you must use sort index (rather than sort_values):

BusStopList.sort_index(level="LSOA11CD", ascending=True)

Upvotes: 2

Related Questions