Sorting values in a dataframe

Question

I've been trying to sort the values on my a dataframe that I've been given to work on.

The following is my dataframe.

1981    1.78
1982    1.74
1983    1.61
1984    1.62
1985    1.61
1986    1.43
1987    1.62
1988    1.96
1989    1.75
1990    1.83
1991    1.73
1992    1.72
1993    1.74
1994    1.71
1995    1.67
1996    1.66
1997    1.61
1998    1.48
1999    1.47
2000     1.6
2001    1.41
2002    1.37
2003    1.27
2004    1.26
2005    1.26
2006    1.28
2007    1.29
2008    1.28
2009    1.22
2010    1.15
2011     1.2
2012    1.29
2013    1.19
2014    1.25
2015    1.24
2016     1.2
2017    1.16
2018    1.14

I've been trying to sort my dataframe in descending order such that the highest values on the right would appear first. However whenever I try to sort it, it would only sort based on the year which are the values on the left.

dataframe.sort_values('1')

I've tried using sort_values and indicating '1' as the column that I want sorted. This however returns ValueError: No axis named 1 for object type <class 'pandas.core.series.Series'>

Because the first argument will be taken as by. You need to use the axis keyword — roganjosh
– roganjosh, Commented Sep 2, 2019 at 17:29

Vishnudev Krishnadas · Accepted Answer · 2019-09-02 17:48:03Z

1

From the error that OP mentioned, The data structure is a Series and hence the sort function should just be called directly

s = s.sort_values(ascending=False)

The error was raised because, in pandas.Series.sort_values the first argument is axis.

edited Sep 2, 2019 at 17:48

answered Sep 2, 2019 at 17:35

Vishnudev Krishnadas

11k2 gold badges29 silver badges58 bronze badges

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

Comments

Georgina Skibinski · Accepted Answer · 2019-09-02 17:31:21Z

0

The argument of sort_values() should be column name:

df=df.sort_values("col2")

answered Sep 2, 2019 at 17:31

Georgina Skibinski

13.5k2 gold badges16 silver badges44 bronze badges

Collectives™ on Stack Overflow

Sorting values in a dataframe

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related