Question

(Python)

Write a program called sales.py that uses a list to hold the sums of the sales for each month. The list will have 12 items with index 0 corresponds with month of “Jan”, index 1 with month “Feb”, etc.

o Write a function called Convert() which is passed a string which is a month name (ex. “Jan”) and returns the matching index (ex. 0). Hint – use a list of strings to hold the months in the correct order, e.g., months = [‘Jan’, ‘Feb’, …]

o Month Name Index

Jan 0

Feb 1

Mar 2

Apr 3

May 4

Jun 5

Jul 6

Aug 7  

Sep 8

Oct 9

Nov 10

Dec 11

o Download the text file sales.txt from https://drive.google.com/open?id=1jCqinXsf2wyh_xo8XjBXxsjB1SYwtgf7 and put it in your PyCharm project folder. Open and read the file which contains an unknown number of data sets. Each data set contains a month name on one line and the sales for the month on the second line. Because of this format, reading the file using a simple for loop can be tricky (because you have to read two lines to obtain one record). As a result you may want to call the readline() function and use a while loop (calling the readline() function twice). Note – readline() does not strip off the newline character at the end of the line, so you will need to strip this off your string (using the replace(‘\n’, ‘’) function).

o Using a list with 12 floating point numbers to accumulate your sales by month. As you read each pair of data, call the Convert() function to index the list and update the correct sale sum in the lists of sums by month. Compute the grand total of all sales.

o After you’ve read all the records, then use a for loop to iterate over the months and report the month number and the sums for each month. Use the string.format() function to format zones to align data using 2 decimal places on the monetary figures. Next report the grand total with currency format and 2 decimal places.

o The output of the program will look as follows:

COS-120 [C:\Usersl michal PycharmProjects\COS-120] -sale... File Edit View Navigate Code Refactor Run Iools VCS Window Help coS-120sales.py salesQ t Run: sales x C: Users mlcha \venvicos-1201Scripts python.exe C:/U Month Sum $800.00 $500.00 $800.00 $1,200.00 $500.00 $1,700.00 $1,400.00 $1,700.00 $1,200.00 $1,700.00 $0.00 $4,100.00 Jan Feb Mar Apr May Jun İ Jul Aug Sep oct NOV Dec Grand total is: $15, 600.00 Process finished with exit code 0 4: Run6: TODO Terminal Python Console Event Log 27:45 CRLFUTF-8

Answer 1

#code screenshot

null

#code

months = ['Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec']
  
def convert(s): #convert function implementation
i=0
while i<len(months):
if(months[i]==s):
return i
i += 1
return -1 #returns -1 if s is not in months list

f = open("sales.txt") #opens sales.txt file
values = [0,0,0,0,0,0,0,0,0,0,0,0]
total = 0.0
while True: #populates the values list and adds the values to total
s = f.readline().replace('\n','')
if s=="":
break
index = convert(s)
s = f.readline()
if s=="":
break
val = s.replace('\n','')
values[index] += float(val)

print('Month Sum')
i=0
#prints list values to the console using loop
while i<len(months):
print(months[i],' $%7.2f'%values[i])
total += values[i]
i+=1
print('\nGrand Total is: $%.2f'%total)

#output screenshot