Return Requested Result

Sometimes we want to answer a few questions, so we need to extract only the relevant columns.

As a reminder, to extract a single-column series object:

column = df['col']

To extract multiple columns, specify the column names inside an array (this returns a dataframe):

columns = df[['col1', 'col2', 'col3', ...]]

To extract only the relevant rows, we can use slicing, just like in Python lists:

rows = df[row_index_start:row_index_end]

For example:

filtered_df = df[5:9]

filtered_df will hold rows 5, 6, 7, and 8.

Now to return the result in the order we want:

res = df.sort_values(by='column_name', ascending=True)