Get Started

Converting quarters into months

A company has a challenge in separating data into months. It has received the following data:

Quarter Amount
Quarter 1 700
Quarter 2 650

The split across the months within each quarter is equal. Your goal is to separate this data into a list format containing the amounts per month for the first two quarters.

This is a part of the course

“Financial Forecasting in Python”

View Course

Exercise instructions

  • Create a list for quarters containing the numerical units per quarter, and initialize a new empty list qrtlist. The latter step has been done for you.
  • Create a for loop that converts the qrt in the quarters list into months with the formula round(qrt/3, 2). The round() function with the second argument 2 rounds the numbers down to a readable format.
  • Add the three equal values of month to qrtlist.
  • Print the qrtlist.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Create a list for quarters and initialize an empty list qrtlist
quarters = [____, 650]
qrtlist = []

# Create a for loop to split the quarters into months and add to qrtlist
for qrt in ____:
 month = round(____ / 3, 2)
 qrtlist = qrtlist + [____, ____, ____]
 
# Print the result
print("The values per month for the first two quarters are {}.".format(____))
Edit and Run Code