Effective Data Manipulation with pandas/

...

/

Solution: Sorting, Columns, Filtering, and Indexing Operations

Solution: Sorting, Columns, Filtering, and Indexing Operations

See the solution to problems related to sorting, columns, filtering and indexing operations.

We'll cover the following...

Solution 1

Given the following dataframe:

    col1 col2 col3 col4
0     A    B    C    D 
1     E    F    NaN  H
2     I    J    Z    Y
3     S    X    E    V
4     Q    A    B    W

Perform the following operations:

a) Sort the index.

b) Sort by a single column col1.

c) Sort by col1 in descending order.

d) Sort by two columns, col1 and col2.

Sort the index

Press + to interact
import pandas as pd
import numpy as np
df=pd.DataFrame({
  "": ['A','B','C','D'],
  "col1": ['E','F',np.NaN, 'H'],
  "col2": ['I','J','Z','Y'],
  "col3": ['S','X','E','V'],
  "col4": ['Q', 'A','B','W']
})
print(df.sort_index(axis='columns'))

  • Line 12: We sort the DataFrame df by the column indices. It rearranges the columns in the DataFrame in alphabetical order.

...