How to use python_fundamentals_3 notebook on how to read Excel file and do conditional selection of rows?

First, make sure you have the necessary packages installed. You will need pandas (for reading Excel files) and numpy (for conditional selection).

Open the python_fundamentals_3 notebook and go to the section titled "Reading Excel Files".

Download the sample Excel file provided in the notebook and save it to your local machine.

Use the pandas function pd.read_excel() to read the Excel file into a pandas dataframe. Make sure to specify the file path and sheet name, if applicable.

Once you have the dataframe, you can use pandas functions to perform conditional selection. For example, you can use the .loc[] function to select rows based on a condition.

In the section titled "Conditional Selection of Rows", follow the example provided to select rows where the "Salary" column is greater than 50000.

You can modify the condition to suit your needs. For example, you can select rows where the "Department" column is equal to "Sales" or where the "Age" column is less than 30.

Run the code cells to see the output of your conditional selection.

You can also save the selected rows to a new Excel file using the pandas function .to_excel().

Once you have completed the exercise, make sure to save your changes to the notebook and any new files created.