Python- How sort matrix [duplicate]

Question

I have a big matrix import for one .csv more than 50.000 lines.

I am working with panda and numpy, the matrix is a film data base, I would like to sort the matrix by budget and see for example 10 first line showing all columns for this matrix.

Example: Sort by revenue, this is my objective.

IMDb_data[['film', 'budget', 'revenue','vote_average','cast']].head(3)

film    budget  revenue   vote_average ..... cast   director    homepage
J.Park  100000    150          5       .....  AAA      BBB      CCC.com
Sun     50000     75           4       .....  AAA      BBB      CCC.com
Night    2000     50           3       .....  AAA      BBB      CCC.com

Code use for import the IMDb_data:

import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns
IMDb_data= pd.read_csv('tmdb-movies.csv')

BlueSheepToken · Accepted Answer · 2019-02-22 13:48:28Z

1

You are looking for the sort_values method, you can precise by which column, and the order (ascending or descending)

df.sort_values(by='budget', ascending=False)

For more keywords, you can check out the official documentation

by is taking either a string (to sort with one column) or a list of string to sort by lexicographic order

ascending is taking a boolean (default True)

edited Feb 22, 2019 at 13:48

answered Feb 22, 2019 at 13:39

BlueSheepToken

6,1973 gold badges23 silver badges47 bronze badges

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

Comments

Richard · Accepted Answer · 2019-02-22 13:38:00Z

0

IMDb_data.sort_values(by=['budget'], ascending=False) to sort by budget.

IMDb_data.sort_values(by=['revenue'], ascending=False) to sort by revenue.

pandas.DataFrame.sort_values

answered Feb 22, 2019 at 13:38

Richard

2,3662 gold badges21 silver badges38 bronze badges

Collectives™ on Stack Overflow

Python- How sort matrix [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related