Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

How to Read and Write Excel Files in Python

Introduction
2. Exercise 1

Instruction

Here comes the first challenge.

Exercise

Load the tea_collection.xlsx file. The file structure is as follows:

Name Type Weight Year

A few teas have been drunk. Delete rows 2 to 4 and rows from 8 till the end of the sheet. Remove the C column.

Save the new contents in the file.

Stuck? Here's a hint!

Load the file with the load_workbook() function and get the active sheet in the workbook.

Use the .delete_rows() and .delete_columns() functions to modify the file contents appropriately.

Remember, after you delete the rows 2 to 4, the 8 row won't be row 8 anymore, it will be row 5.