Pandas dataframe raises KeyError when sort_values() method is called

Question

I'm new at pandas and trying to simply learn something about it and it's dataframes. I want to sort data using one column, but when I tried to use:

 print(df.sort_values(by = 'avg_low'))

and

print(df.sort_values('avg_low'))

but it always throws KeyError. ('avg_low' is column's name) My data is:

month  avg_high  avg_low  record_high  record_low  avg_precipitation
Jan        58       42           74          22               2.97
Feb        34       42           74          22               2.97
Mar        54       42           74          22               1.97
Apr        65       42           74          21               2.97
May        32       42           74          22               3.32

what can I do to sort this somehow?

@ernest_k Oh, I pasted it from .txt document here and just forgot to remove commas.. — Guga Nemsitsveridze
– Guga Nemsitsveridze, Commented Dec 28, 2018 at 21:06

BENY · Accepted Answer · 2018-12-28 21:10:01Z

8

So you have white space in columns , let using str.strip clear it up then we can using sort values

df.columns=df.columns.str.strip()

answered Dec 28, 2018 at 21:10

BENY

324k22 gold badges176 silver badges250 bronze badges

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

Collectives™ on Stack Overflow

Pandas dataframe raises KeyError when sort_values() method is called

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related