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.
