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-08 19:44:57Z

28

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 8, 2016 at 19:44

answered Dec 28, 2015 at 19:49

Romain

22.2k6 gold badges63 silver badges77 bronze badges

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

5 Comments

Klausos Klausos Over a year ago

How can I update pandas on Windows (preferably using pip)?

Anton Protopopov Over a year ago

@KlausosKlausos pip install -U pandas?

Klausos Klausos Over a year ago

@Anton Protopopov: Thanks. I did pip install pandas --update. Looks like it's updating pandas.

Romain Over a year ago

My advice on Windows is to use the Anaconda distribution since some dependencies of pandas could be tricky to update.

fandang Over a year ago

"--update" didnt work for me, but "--upgrade" did: "pip install pandas --upgrade"

ah bon · Accepted Answer · 2021-12-26 10:14:28Z

3

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

edited Dec 26, 2021 at 10:14

ah bon

10.1k22 gold badges82 silver badges185 bronze badges

answered Oct 31, 2017 at 7:21

Gagan

713 bronze badges

Collectives™ on Stack Overflow

DataFrame object has no attribute 'sort_values'

2 Answers 2

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related