Dataframe column doesn't sort

Question

Trying to sort the dataframe to show the highest value rows first but no matter what I try, nothing changes

new = pandas.DataFrame(d.items(), columns=['Trait', 'Count'])
new.sort_values('Count', ascending=False)
new['Percent'] = (new.Count / 1000) * 100
print(new)

What it's showing:

'Count' should be sorted in descending order by highest value to lowest and then obviously the equivalent row data should follow

                                Trait  Count  Percent
0                               Black    835     83.5
1                        Actual White     31      3.1
2                           Paperback     60      6.0
3                        Grape Poison      8      0.8
4                               Cielo      3      0.3
5                                Acid      6      0.6
6                               Olive      1      0.1
7                              Mailer     37      3.7
8                                Domo      7      0.7
9                               Hazel      4      0.4
10  Pink that is Almost Orange in Hue      2      0.2
11                              Vapor      1      0.1
12                               Grey      3      0.3
13                    MailerConstruct      1      0.1
14                              Blood      1      0.1

Ali Redha · Accepted Answer · 2023-02-01 04:37:35Z

1

you forget to add to new data frame try this code instead

new = pandas.DataFrame(d.items(), columns=['Trait', 'Count'])
new = new.sort_values('Count', ascending=False)
new['Percent'] = (new.Count / 1000) * 100
print(new)

answered Feb 1, 2023 at 4:37

Ali Redha

3452 silver badges14 bronze badges

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

Comments

Anastasiya-Romanova 秀 · Accepted Answer · 2023-02-01 04:35:34Z

0

Try this at line 2:

new = new.sort_values('Count', ascending=False)

or

new.sort_values('Count', ascending=False, inplace=True)

answered Feb 1, 2023 at 4:35

Anastasiya-Romanova 秀

3,37833 silver badges50 bronze badges

Comments

Ashok KS · Accepted Answer · 2023-02-01 04:37:49Z

0

You have to set the values to the variable or set inplace=True

new.sort_values('Count', ascending=False, inplace=True)

or

new = new.sort_values('Count', ascending=False)

answered Feb 1, 2023 at 4:37

Ashok KS

7017 silver badges25 bronze badges

Collectives™ on Stack Overflow

Dataframe column doesn't sort

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related