Effective Data Manipulation with pandas/

...

/

Exercise: Sorting, Columns, Filtering, and Indexing Operations.

Exercise: Sorting, Columns, Filtering, and Indexing Operations.

Solve some problems related to sorting, columns, filtering, and indexing operations.

We'll cover the following...

Problem 1: Sorting

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 ...