DataFrame object has no attribute 'sort_values'

Question

dataset = pd.read_csv("dataset.csv").fillna(" ")[:100]
dataset['Id']=0
dataset['i']=0
dataset['j']=0
#...
entries=dataset[dataset['Id']==0]
print type(entries)  # Prints <class 'pandas.core.frame.DataFrame'>
entries=entries.sort_values(['i','j','ColumnA','ColumnB'])

What might be the possible reason of the following error message at the last line?:

AttributeError: 'DataFrame' object has no attribute 'sort_values'

Romain · Accepted Answer · 2016-03-08T19:44:57.673

25

Hello sort_values is new in version 0.17.0, so check your version of pandas. In the previous versions you should use sort.

entries=entries.sort(['i','j','ColumnA','ColumnB'])

edited Mar 08 '16 at 19:44

answered Dec 28 '15 at 19:49

Romain

16,760
6
49
57

How can I update `pandas` on Windows (preferably using `pip`)? – Klausos Klausos Dec 28 '15 at 19:50
@KlausosKlausos `pip install -U pandas`? – Anton Protopopov Dec 28 '15 at 19:53
@Anton Protopopov: Thanks. I did `pip install pandas --update`. Looks like it's updating `pandas`. – Klausos Klausos Dec 28 '15 at 19:54
3

My advice on Windows is to use the [Anaconda](https://www.continuum.io/downloads) distribution since some dependencies of pandas could be tricky to update. – Romain Dec 28 '15 at 19:55
3

"--update" didnt work for me, but "--upgrade" did: "pip install pandas --upgrade" – fandang Feb 16 '16 at 13:47

score 2 · Answer 2 · edited Dec 26 '21 at 10:14

2

Check pandas version, In new versions uses sort_values in place of sort.

edited Dec 26 '21 at 10:14

ah bon

7,903
7
43
86

answered Oct 31 '17 at 07:21

Gagan

51
3

DataFrame object has no attribute 'sort_values'

2 Answers2

Linked