Sorting columns in dataframes with panda

Question

I’m completely new to python so I don’t have a clue where to start but I have an excel spreadsheet table with 10,000 pieces of data about the google App Store. I’ve imported panda and imported the csv into python aswell. There are 5 columns including name, genre, rating, price, downloads. I need to sort the data frame from highest price first and descending down. Anyone have any simple solutions?

explained very well

Akhilesh_IN
– Akhilesh_IN

2019-09-12 17:52:47 +00:00
Commented Sep 12, 2019 at 17:52 — Akhilesh_IN
– Akhilesh_IN, Commented Sep 12, 2019 at 17:52

Aditya Mishra · Accepted Answer · 2019-09-12 17:43:28Z

1

Try this -

import pandas as pd
df = pd.read_csv('google-play-store.csv')
df.sort_values(by=['price'], ascending=False)

answered Sep 12, 2019 at 17:43

Aditya Mishra

1,9053 gold badges17 silver badges27 bronze badges

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

1 Comment

Deven Over a year ago

you need to use either inplace=True or store returned df into a variable.

Deven · Accepted Answer · 2019-09-12 18:29:00Z

1

Python has a very good API documentation for pandas. You can explore the sort_values method for a DataFrame here.

Note, by default it places NA values at the last, sorts in ascending order and inplace = False (that is return a new df). For your problem, you can use

import pandas as pd
df = pd.read_csv('your_filename.csv')
df.sort_values(by='price', ascending=False, inplace=True)

answered Sep 12, 2019 at 18:29

Deven

7411 gold badge7 silver badges22 bronze badges

Collectives™ on Stack Overflow

Sorting columns in dataframes with panda

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related