The assignment requires writing a program that reads a CSV file called 'borough-sales.csv' containing sales data for different areas in the UK. The program should calculate average sales across three years and categorize them into ranges (0-3000, 3001-5000, >=5001). It should generate a new CSV file with the calculated statistics.
Contribute Materials
Your contribution can guide someone’s learning journey. Share your
documents today.
4. Problem solving with lists, strings, and files Write a program that reads a csv data file calledborough-sales.csv(sample provided with the lab) that contains sales of land in various parts of the UK for years of 2012-2014. The file consists of 4 columns: the area and the 3 years of sales numbers. It will calculate the following stats (printing to screen optional): Areas with average sales across the three years in the ranges 0-3000, 3001-5000, >=5001. It should generate a CSV file (columns separated by commas, rows separated by newlines (\n). Note that the rows do not have to be in any particular order. It should create a table similar to the following (table incomplete): 0-30003001-5000>=5001 City of LondonBarnetBromley Barking and Dagenham CroydenWandsworth ……… ----- THE END ----- -1-