Sorting DataFrames

Sort by a column in ascending order (lowest first):

import pandas as pd
 
df = pd.read_csv('/data/companies.csv')
 
sorted_df = df.sort_values(
    'Year Established'
)
print(sorted_df[['Company Name',
    'Year Established']].head(3))

Python

Output

Pass ascending=False to reverse the order:

import pandas as pd
 
df = pd.read_csv('/data/companies.csv')
 
top = df.sort_values(
    'Revenue (USD)',
    ascending=False
)
print(top[['Company Name',
    'Revenue (USD)']].head(3))

Python

Output

Sort by multiple columns by passing a list. The second column is used to break ties:

import pandas as pd
 
df = pd.read_csv('/data/companies.csv')
 
sorted_df = df.sort_values(
    ['Industry', 'Revenue (USD)'],
    ascending=[True, False]
)
print(sorted_df[['Company Name',
    'Industry',
    'Revenue (USD)']].head(4))

Python

Output

pychallenger

What will be the output?

What will be the output?

What will be the output?

What will be the output?

What will be the output?