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
6. Exercise 5

Instruction

That was a good one! Here comes the last exercise.

Exercise

There are five sheets in the file: February, March, April, May, and June.

Load the spendings.xlsx file. Each worksheet has the same structure:

date spendings
<date> <spendings>

We have to correct some mistakes:

  • Remove the row for the 30th day in April (row number 31).
  • Deduct 2.00 from every value spent in March that was greater than 50.00.
  • Add 2.00 to every value spent in May that was smaller than 30.00.
  • Save the workbook to the corrected_workbook.xlsx file.

The number of rows in each sheet is the number of days in a month plus one.